|
By hooking into SQL Server events.
|
|
|
|
|
thanks
may be explain more about this
|
|
|
|
|
when i'm trying to insert data into a sql server database
it shows the following error :
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
//My Code
SqlConnection savecon = new SqlConnection();
savecon.ConnectionString ="Data Source=localhost; Initial Catalog=Iqdata";
savecon.Open();
string a = TextBox1.Text;
string b = TextBox2.Text;
string c = TextBox3.Text;
string d = TextBox4.Text;
SqlCommand savecom = new SqlCommand("insert into User values (15,a,b,c,d)", savecon);
int rows = savecom.ExecuteNonQuery();
savecon.Close();
|
|
|
|
|
You need to learn about parameters.
|
|
|
|
|
i know about parameters and i used it already , but the error has no relation with parameters
|
|
|
|
|
|
values (15,'"+a+"','"+b+"','"+c+"','"+d+"')
|
|
|
|
|
EmZan wrote: this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections
Have you verified this? You need allow remote connections. Tons of results for this on google[^]
|
|
|
|
|
hii i have a datagrid in c# I m taking table names from database , and table names show in datagrid so far no problem and
now I want to show when table name clicking write textbox select update and insert queries in textbox how can i do this?
|
|
|
|
|
coderneww wrote: hii i have a datagrid in c#
Yes, with you.
coderneww wrote: I m taking table names from database
Uh huh...
coderneww wrote: and table names show in datagrid
Good, good...
coderneww wrote: so far no problem
Excellent!
coderneww wrote: now I want to show when table name clicking write textbox select update and insert queries in textbox
Now, you see, this bit I don't understand.
What are you trying do exactly? What have you tried?
coderneww wrote: how can i do this?
Yes, fine, back to English, understand you without problems.
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
To recap:
"I want to show when table name clicking write textbox select update and insert queries in textbox"
This is an intriguing sentence and was just sitting here sipping my coffee trying to figure it out.
One theory is that you looking to be able to specify a query on the database by clicking on the table name, inserting the query in a textbox, then outputting the results to a second textbox after selecting "Update".
Is this in the ballpark?
Jeff
|
|
|
|
|
Hello,
I am using DataGridViewComboBoxColumn as a column of DataGridView.
I have assigned data source as a List<myobject> and i am able to see all values in dropdown.
Now, for any Key Press it always select and display first element of list and but the selected value disappear as focus is taken away from the cell.
For e.g the comboBox list contains A, B, C & D. Now user presses key 'B' then it display 'B' as expected but if user presses 'E' then it display 'A' as selected and very strangely the selection disappears as focus looses from the cell.
What should i do not to display any selected value if it not in list?
|
|
|
|
|
Hi ...
my string is : ""AAR"/"KKK"/"MMR""
i want result in following format:
k1=AAR
K2=KKK
k3=MMR
each substring into different variable;
Please Help!!
|
|
|
|
|
|
i tried it but split string into 2 parts.....i dont know how to use same for my result,please tell me.
|
|
|
|
|
string []substrings = yourstring.Split(new char[] { '/' });
string k1 = substrings[0];
string k2 = substrings[1];
|
|
|
|
|
Hey my k1 shows all string instead of 1st substring.n giving out of range error for k2.
|
|
|
|
|
|
Doesn't work...giving error as above msg.
|
|
|
|
|
KIDYA wrote: ""AAR"/"KKK"/"MMR""
Do you not see anything wrong with that? "AAR/KKK/MMR" would work.
Do you want to escape the speech marks? Use \".
My failometer is detecting vast quantities of FAIL!
"Its SQL - hardly programming..." (Caslen)
|
|
|
|
|
It works....Thanx... 
|
|
|
|
|
hello
what's the diff between lock(Employees.SyncRoot) and lock(Employees)?
(Employees can be any ICollection, ArrayList, Hashtable what not .. don't matter)
Thanks
dev
|
|
|
|
|
The SyncRoot property is used when you create synchronized collections using the .Synchronized() method. All operations on the synchronized collection lock on the object returned by the SyncRoot property. Creating synchronized collections using Synchronized() is not recommended though, because just making individual operations threadsafe usually isn't enough.
Other than that, it doesn't really matter.
|
|
|
|
|
|
yeah thanks saw that seems like it's just a long way of saying "yes it's pretty useless"
dev
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
