|
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
|
|
|
|
|
Hello Experts......
i have problem in my dataset has a table which i retrieve from a file,now i want to copy values from dataset to table.i used SQLBULKCOPY but cant work.
Help me!!
My Code:-
<pre>
DataTable dt= ds.Tables["MyNewTable"]; // This is a table i have in my dataset
using (SqlBulkCopy bc = new SqlBulkCopy(conn))
{
conn.Open();
bc.DestinationTableName = "dbo.XYZ"; // This is a table wid same schema as MyNewTable.
// Starts the bulk copy.
DataTable dt1=new DataTable("MyNewTable");
bc.WriteToServer(dt); ;
// Closes the SqlBulkCopy instance
bc.Close();
}
|
|
|
|
|
Hi there,
What kind of error you are getting ?! if no exception then did you make sure that the source datatable has data? and is the connection string correct to be for the destination database ?!
Sincerely Samer Abu Rabie
Imagination is more important than knowledge !
|
|
|
|
|
i am retriving d values in dataset from text file and i want to copy dataset values in d table,.n there was no any error in above code.
|
|
|
|