add assembly reference

Question

i upload image below. My problem is i can't add the System.Data.SqlClient.dll assembly. So it si possible to add in nwpf(framework) interface. If it is possible how can i add it

Sachin Singh · Answer

Its should be ExecuteReader() not ExecutiveReader() MyReader2=MyCommand.ExecuteReader();

Rajanikant Hawaldar · Answer

@Jignesh Kumar, he is trying to access ExecuteReader on string MyConnection not on connection class, and he inserting data then what is purpose of using ExecuteReader() ?

Rajanikant Hawaldar · Answer

Since your inserting data to database you have to use ExecuteNonQuery() not ExecuteReader();

Jignesh Kumar · Answer

Hi, You are doing bit wrong there. You are trying to use ExecuteReader() on connection string object. it should be apply on command. Please change you error code line, apart from this all looks good. @rajnikant, You are right, First need to insert then retrive data via reader. First need to be. Myreader2 = Mycommand. ExecuteNonQuery () once data is posted in database table need to retrive using reader, Myreader2 = Mycommand.ExecuteReader()

Rajanikant Hawaldar · Answer

if System.Data assembly avaialable then there must be System.Data.SqlClient.dll is there may your unable to add due to compilation errors so fix these first then check afterthat also not available you can add it through nuget.

Rajanikant Hawaldar · Answer

Hello Ahamed, tell me what your trying to do post your code here, i see lot of mistakes in your code explain and post code what you have done so far.