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.