add assembly reference

Ahamed Althaf

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar6y ago
@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 Hawaldar6y ago
Since your inserting data to database you have to use ExecuteNonQuery() not ExecuteReader();
Jignesh Kumar6y ago
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 Hawaldar6y ago
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 Hawaldar6y ago
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.
Sachin Singh6y ago
Its should be ExecuteReader() not ExecutiveReader()
MyReader2=MyCommand.ExecuteReader();