|
hi all
I have a database with multiple tables
I want to fill my DataSet.
must I use DataAdapter for each table in my database ?
is this the best way ?
|
|
|
|
|
Click[^]
My failometer is detecting vast quantities of FAIL!
"Its SQL - hardly programming..." (Caslen)
|
|
|
|
|
Best not to use DataSets and DataAdapters at all.
|
|
|
|
|
|
Take a copy of where the inside rectangle should go. That'll give you the image in the centre. Draw the outside rectangle with the fill colour. Draw the copy of the image at the original co-ordinates of the inside rectangle. I don't really know how to explain this better without going into a fairly terse explanation, but that's the basic idea
|
|
|
|
|
or fill four rectangles, one for each side of the overall rectangle.
or paint one rectangular outline with a wide pen.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
hi every one
how can i implementation sql server profiler in a win application ?
Thanks
|
|
|
|
|
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.
|
|
|
|
|