|
I tried to create a OleDbCommandBuilder but it still didn't work...
OleDbCommandBuilder cmdBld = new OleDbCommandBuilder(da1);
|
|
|
|
|
What did you do next?
da1.UpdateCommand = cmdBld.GetUpdateCommand();
?
Lester
http://www.lestersconyers.com
|
|
|
|
|
Nothing yet...
public void MergeTables(string connS1, string connS2)
{
string connString1 = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + connS1;
string connString2 = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + connS2;
OleDbConnection oleConn1 = new OleDbConnection(connString1);
OleDbConnection oleConn2 = new OleDbConnection(connString2);
string cmd1 = "SELECT *FROM db1_table1";
string cmd2 = "SELECT *FROM db2_table1";
da1 = new OleDbDataAdapter(cmd1, oleConn1);
da2 = new OleDbDataAdapter(cmd2, oleConn2);
ds1 = new DataSet();
da1.Fill(ds1, "db1_table1");
da2.Fill(ds1, "db2_table1");
ds1.Tables["db1_table1"].Merge(ds1.Tables["db2_table1"]);
OleDbCommandBuilder cmdBld = new OleDbCommandBuilder(da1);
da1.UpdateCommand = cmdBld.GetUpdateCommand();
@da1.Update(ds1, "db1_table1");
ds1.AcceptChanges();
}
|
|
|
|
|
Found it..
The problem was that after the Merge none of the rows in data table had the state RowState Changed or Added. The update methon had nothing to apply.
This peace of code made the whole class work as it should:
foreach (DataRow row in ds1.Tables["db2_table1"].Rows)<br />
row.SetAdded();
Thanks
|
|
|
|
|
hi
I am using a combobox to load items using datatable. i am using sqlserver2005.when i tried to load a count of 32500 rows in a combobox , my application hangs more than for 5 min.
Any body give me solution.
Below is my code:
<br />
private void _popItemCombo()
{<br />
clsGrpObj = new clsGroupManip();<br />
clsDataAccObj = new clsGloDataAcces();<br />
dtItem = new DataTable();
dtItem = clsGrpObj._selItem_Assembly();<br />
for (int i = 0; i < dtItem.Rows.Count - 1; i++)<br />
{<br />
string item = dtItem.Rows[i]["ItemCode"].ToString();<br />
cmbItemCode.Items.Add(item);
}<br />
<br />
}<br />
help me,
Thank u
kssk
|
|
|
|
|
You should use cmbItemCode.DateSource = dtItem and set the DisplayMember and ValueMember instead.
Any auto search on the combobox? I would have to scroll 30000 rows on 8 items drop down to select a customer.... 
|
|
|
|
|
hi darkelv
just i tried that , it also takes exactly 6 seconds. If i ignore that
i am experiencing the same trouble in DataGridview combobox column. Can u tell me how to overcome that .
Thank u for ur quick response
kssk
senthil
|
|
|
|
|
Loading 30,000 items into a combo box is plainly not the right thing to do. A combo box is used to select from, with this many items it will be, to all intents, unusable.
You need to rethink what you are trying to achieve. Can you filter your list in some way?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Like Ashfield said, there's no way around it. You just have to load less data. The problem will be worse if you do it in the DataGridViewComboboxColumn.
You can subclass the combobox, let use enter the beginning letter of the item, and handle the text change or something. Once the control detected that use entered something, populate the combobox with the data beginning with the letter user entered, etc.
Or use a picker dialog.
|
|
|
|
|
I have a table and I want to store the whole database into a string array..
How do I do it?
Say I have a table with 10 fields and suppose the table contains 1000 entries.
I want to store each value of a field delimited by a character '|' and so there should be 1000 entries like this in the string array..
Som
|
|
|
|
|
make a loop that will read all rows and write in a string variable, you can also use string.Join() for this purpose
eg.
string line="";
for(int a = 0;a< DT.Rows.Count;a++)
{
string[] row = DT.Rows[a].ItemsArray;
line += string.Join("|", row) +"\n";
}
code is not tested, hope it will help
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
What is DT here..
Cant we use a SQL query to query the whole table from the database and then build up the string array?
If this is possible then please advice on this logic..
Som
|
|
|
|
|
DT is DataTable, assign a SQLDataReader to DataTable, it will read all the data from sql table or use DataSet
for more info use google
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
Hello friends i am developing an application in which there is printing option...
The printing option is working well but the problem is when the printdialog shows and by default the numbers of copies is 1 and if i increase the numbers of copies 2 or 3 then its only print one copy only why number of copies option is not working....
CODE
int count = Application.OpenForms.Count;<br />
for (int i = 1; i < count; i++)<br />
{<br />
PrintDialog myPrintDialog = new PrintDialog();<br />
memoryImage = new System.Drawing.Bitmap(panel1.Width, panel1.Height);<br />
panel1.DrawToBitmap(memoryImage, panel1.ClientRectangle);<br />
if (myPrintDialog.ShowDialog() == DialogResult.OK)<br />
{ <br />
myPrintDialog.Document = printDocument1; <br />
printDocument1.PrintController = new StandardPrintController();<br />
printDocument1.Print();<br />
}<br />
printDocument1.Dispose();<br />
}
|
|
|
|
|
this function will not work automatically, you have to do this dynamtically...
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
so how can i do this dynamically...............
|
|
|
|
|
put a int to count, call the PrintDocument_Print() event until you counter reach to 0. Do this work when your all pages finished, or if you do not want Collate, then call and decrease counter on every print but this time you will need to set again the actual value to counter
hope it will help
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
How do you add two hex values in c# to give a resulting hex value?
|
|
|
|
|
There is no such thing as a 'hex value'. There's just a number. If you have the number as a string, you need to convert it to an int. Once you add them, you need to convert to a string in order to force a format, be it hex, or whatever.
http://www.codeproject.com/KB/recipes/hexencoding.aspx[^] is a good place to start.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
when converted the value to a string its "27486520736169642c646f20796f752077616e7420746f20706179202431303f27".
I then tried converting it to an Integer, but i get an error saying that "the value is too big or too smaill to convert to Int64"
|
|
|
|
|
ONeil Tomlinson wrote: I then tried converting it to an Integer, but i get an error saying that "the value is too big or too smaill to convert to Int64"
Since this "value" is a 264 bit number, it's MUCH larger than a 32-bit Integer or a 64-bit Integer can hold. The only data type that can represent this number is the Decimal type. But, there's a problem. The Convert methods won't convert a hexadecimal string this large to a any data types that can hold it.
You'll need a large number processing library to do this, such as this one[^], found right here on CP.
|
|
|
|
|
Hello!
Is it possible to get the SID of the user last wrote to a file?
I am able to get the owner of a file, but I can't find how to get the
user that last wrote to it.
Does anyone know how I can do it?
Thanks in advance!
Have a nice day!
|
|
|
|
|
Does the file system even store that info ?
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I don't know... That's a good question.
I will check it first. Thanks!
Have a nice day!
|
|
|
|
|
I have a data grid view in my C# windows application wherein I want the user to click on the particular data grid view cell and then on right clicking it should show a customized menu and on clicking a particular option it should change the color of the data grid view column.
I am trying by using context menu strip but unable to do it? Plz help me in this regards.
Anshul Madan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
