Thursday, June 18, 2020

Change or remove windows saved passwords

1. Press Windows + R and type explorer shell:::{1206F5F1-0569-412C-8FEC-3204630DFB70} in the Run dialog box, hit Enter key to open Credential Manager snap-in.

2. Choose the credentials you want to remove and click on down arrow icon next to it.

3. Finally, click Remove.

Wednesday, March 18, 2020

This site can’t be reached error

Open a Command prompt and run these commands

           ipconfig /release
           ipconfig /all
           ipconfig /flushdns
           ipconfig /renew


Tuesday, March 17, 2020

How to search particular date records in sql sqerver

select * from tableName where CONVERT(varchar,[Timestamp],3) = '17/03/20' //here timestamp your table column name and data type datetime.

How do I create a SQL table under a different schema

how to create a schema and how to apply schema.
CREATE SCHEMA SchemaName;

or go to expand the database and goto security folder then expand and create the schema.
 it will create under the schema.

- here if we create any database it will create under dbo.
we want to create under our created schema
create a table and add primary key and auto-increment
then right-click on properties and change schema. that's it njoy...

Monday, March 16, 2020

newtonsoft.json 11.0.2' package requires nuget client version '2.12' or above

Solution: 
Update your NuGet Package Manager extension. Go toTools->Extensions and Updates and selectUpdates->Visual Studio Gallery. Update the NuGet Package Manager extension. Then try to install the package after Visual Studio gets restarted.

Tuesday, March 10, 2020

Verbatim string c#

string path = @"AppData\Example1"; 

C# supports two forms of string literals: regular string literals and verbatim string literals. A verbatim string literal consists of an @ character followed by a double-quote character, zero or more characters, and a closing double-quote character. A simple example is @"asp net MVC".

Friday, March 6, 2020

using itextsharp form fill issue with checkbox in C#

First of all open pdf escape website. upload your pdf to pdf escape and click upload.
After upload selects the particular checkbox and right-clicks and unlocks form field.
Again click the checkbox and right-click you will get the "object properties".
Click "object properties".
Next, You will get pop like "form field properties".
Here you will get "Export Value" - for example, Yes or 1 or 0

In your code use, this "export value" you will get output. 

Thursday, March 5, 2020

datatable filter rows or where condition in datatable in c#

DataRow[] dr = dtDepaet.Select("Id= " + deptId); // where clase in datatable. here id is a column name 
string name = dr[0]["Name"].ToString(); 

Sunday, March 1, 2020

How to clear previous search history in the immediate window

 type >cls in immediate window and Enter.

Friday, February 28, 2020

based on number get alphabets in c#


public string GetAlphabets(int number)
{
   string strAlpha = "";
   try
   {
     strAlpha = ((char)number).ToString();
   }
   catch (Exception e)
   {
     string message = e.Message;
     throw;
   }
   return strAlpha;
}