|
I have alredy added a DataSet name Publications where I have add three tables.
Table(0) is Query_Volume_VolumeLessons
Table(1) is Query_Volume_Sectos
Table(2) is Query_Volume_Themes
Also put data on Table(0) from SQL SERVER DataBase
Now I need to put data to Table(1) from DataSet Table(0) using a sql query.
Question is?
Do I need any connectionStrings? or should I put the query Insert INTO Table(0) from Table(1) if yes how can I execuite this command in VS code.
Please help me Im suffering a lot
Thanks
Sarfarj Ahmed
|
|
|
|
|
i think if u want to fill table with sql query then it will require connection string,because u can execute query through command object which require connection string.
rahul
|
|
|
|
|
Is their any other way that I can put data from DataSet.Tables(0) to DataSet.Tables.(1)
Sarfarj Ahmed
|
|
|
|
|
Hi,
I need to know who is the splitContainer which contains a determined panel.
Imagine that i create a event that is triggered when i click a panel1 or panel2 of a splitContainer.
How can i know, who is the splitContainer from the Panel click?
Thx,
Nuno
|
|
|
|
|
Try the Parent property.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
Hi,
The SplitterPanel doesnt have a Parent propertie.
|
|
|
|
|
According to MSDN its there (SplitterPanel.Parent Property[^]) and should return what you want. I do not know why it is not intended to be used directly from code, but probably that's why it is not shown to you.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
It does. Intellisense sometimes goes a bit astray, so don't rely on it 100%.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Yeap, that's right!
Thank you very much!
Nuno
|
|
|
|
|
You're welcome. Glad I could help
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi,
I am using a DataSet with DataTable which will be populated dynamically.
I am not using DataBase.Just a DataTable defined inside a DataSet.
I want to diplay a part of the columns of DataTable in DataGridView.
where should i place the query in datagridview While execution.
With Thanks,
sakthi.
|
|
|
|
|
Set the DataSource of the DataGridView to use the DataTable.
DataTable dataTable = dsDataSet.Tables[0];
dgView.DataSource = dataTable;
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi,
I have added the Datatable as DataSource to the DataGridView.
But i want to add columns at run time.
With Thanks
Sakthi
|
|
|
|
|
I'm a beginner. I want to insert, update a record into a MS Access database. I tryed to do it using using OleDb Managed Provider, but don't seccess. If you have a sample project is written Visual C#.NET 2005, pleased share with me.
Thank you!
|
|
|
|
|
This is oledb and its works for me:
<br />
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + databaseURL);<br />
Reading:
OleDbDataAdapter resAdapter = new OleDbDataAdapter("SELECT * FROM <table>", con);<br />
OleDbCommandBuilder resCmdBuilder = new OleDbCommandBuilder(resAdapter);<br />
DataSet myDataSet = new DataSet();<br />
resAdapter.Fill(myDataSet, <any name ,need not correspond with <table>);
Inserting
con.Open();<br />
OleDbCommand cmd = con.CreateCommand();<br />
cmd.CommandText = "INSERT INTO <Table> (colname1,colname2....) VALUES(coresponding values)<br />
cmd.ExecuteNonQuery();<br />
con.Close();
Deleting and updating is the same thing , use an UPDATE or DELETE query in CommandText;
CommandText = "UPDATE table_name SET column_name = new_value WHERE column_name = some_value"<br />
CommandText = "DELETE FROM table_name WHERE column_name = some_value";
This should help you with the SQL statements:
http://www.w3schools.com/sql/default.asp[^]
Gideon
|
|
|
|
|
hi every one,
well I'm havig a strange bug here.. I made a form in C# 2.0 Windows application. Its a simple form based on one table named
Manufacturer (manID PK, ManName, logo, Discription)
I made it by binding the data with the binding source and apprantly its working fine but when I try to save changes by clicking on save Button on the binding Navigator it gives an error as
System.Data.SqlCLient.Sqlexception: length of text, ntext or image data (129712) to be replicated exceeds configured maximum 65536
thanks in advance
Rocky
|
|
|
|
|
Are you using replication?
If yes, check this[^].
|
|
|
|
|
yes i'm using replication. I think u might have solved my problem...
|
|
|
|
|
yes it worked, thanks alot man, ur brilliant
|
|
|
|
|
I googled it. I have never encountered such problem before. But thanks, anyway.
|
|
|
|
|
Please i need this answer asap..
if i want to do a function that accepts INTEGERS number... then i wanna the sum of these integers.. for example
if i entered 123.. the answer should be 6.
Thanks in advance
Regards
Estarta
|
|
|
|
|
Sounds like homework. Why don't you make an attempt and then we'll help you with that?
|
|
|
|
|
Thanks for ur reply, And its not a homework, and i tried so many time i couldn't do it ~
i just wanted to know
thanks
Estarta
|
|
|
|
|
Almost certainly no one here will write the whole thing for you. Show us what you got so far, say concretely where you got stuck and we'll help you.
By the way, the specification of your function is quite lousy. It is not really clear what the input is; integers, an array of integers or maybe a string with integers? From your example it seams to be the latter. If so, do you want to sum up the digits or how should the function know where to break up the string into integers?
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
Well its only INTEGERS not array any intergers.
and yesterday i had this work interview and they asked me this question and it bothers me
Estarta
|
|
|
|