Click here to Skip to main content
15,883,901 members
Articles / Desktop Programming / Windows Forms

disconnected sql server when run stored procedure

Rate me:
Please Sign up or sign in to vote.
0.00/5 (No votes)
15 Nov 2012CPOL 4.3K  
Hi, disconnected sql server when run stored procedure.when i try to create or alter stored procedure it automatically disconnected dbserver.only for stored procedure create,alter.this error I am get it.A transport-level error has occurred when receiving results from the...

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

Please Sign up or sign in to vote.
14 Nov 2012sahabiswarup
Here is an example; put your code inside that conn.open() and conn.close().Hope it works.conn.Open();SqlCommand cmd = new SqlCommand(@"select _regno from _registration", conn);SqlDataAdapter ada = new SqlDataAdapter(cmd);dt = new DataTable();ada.Fill(dt);conn.Close();

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Web Developer
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
This is a Social Group (No members)


Comments and Discussions