|
Hello every body
I need to copy data from my dataset to an sql 2000 table with keeping the values of the identity column, so that the values of the identy column of the dataset will be coppied as it is to the Sql table that has an identity(1000,1)
I'm using C# .net 2005
please I need a help soon...
|
|
|
|
|
Use the commands set identity_insert mytable off and set identity_insert mytable on to disable and enable an identity constraint respectively.
Paul Marfleet
|
|
|
|
|
thx for u reply
but I'm using this in a command in my C# code before and after I use the datadapter.update (myDasate) but it still not working ant the ID in the sql table are generated automaticly according to the increment seed of the table
|
|
|
|
|
Use the SET IDENTITY_INSERT mytable ON statement to insert explicit values into an IDENTITY column on a particular table.
Paul Marfleet
|
|
|
|
|
Ok I got a counter going for my tabs. I have it so when ever the user creates a new tab it will count the pages in a integer. Then that number will get placed in the name at the end of the of that rich text's name. So how can I retrieve the name of the rich text box when the user clicks on the it? Then will be placed in a string, so it can be reused when a user clicks a another rich text box.
private void OnClickOfRTB(object sender, EventArgs e)
{
string WorkingOn = newRtb[_pageNumber].Name;
}
private void Paste(object sender, EventArgs e)
{
newRtb.WorkingOn.ToString.Paste();
}
So all I am asking is how can I combine a winform name into a hole string so it can be used in things like paste then convert it the string like if it was a form object.
I know this mite not be the best way to handle it, but that is all I can think of.
So if you can please help or if you need to understand my question more please ask me. My Mind keeps going back and forth on this question on how this should work.
Thanks Aj.
-- modified at 3:19 Tuesday 23rd October, 2007
|
|
|
|
|
How can i check the compressed drive or folder programmitically
naveen
|
|
|
|
|
You have asked the very same question here yesterday permalink[^] and you have got the answer there too so don't double post
|
|
|
|
|
First you are posting same queries again, following is the link of your post made yesterday, which was replied by Guffa-
Previous Post[^]
Second-
You posted your issue and when one user asked you to clarify the point, you made another post, you should have replied on the same post, this is your First Post[^] which you made today about the same issue.
I can not understand why are you doing this.
-Dave.
Dave Traister,
ComponentOne LLC.
www.componentone.com
|
|
|
|
|
I am going to making a control to chart the data from sensor,which run in wince.net.But I don’t know how to began ,so help me 
JACOBI
|
|
|
|
|
|
code to check the compressed drive
naveen
|
|
|
|
|
tnaveen wrote: code to check the compressed drive
What about the code? Be more specific about your problem. Don't expect anyone here to read your thoughts and see what you really want.
There are 10 kinds of people: those who understand binary and those who don't
|
|
|
|
|
when db updated i want to inform the relevent machine that it has got new record in the db .
ex:when db.table 'complaint'updated by a new complaint from a customer ('connection too slow') the hardware dept computer should be informed .
how can i do this or could you please send me some links.
in my project i'm using c#.
|
|
|
|
|
Pay attention to forum guideline no. 3
Paul Marfleet
|
|
|
|
|
Hi all,
Is there any way to export datatable to powerpoint?Is it possible?If so can you send me a sample?
ayyp
|
|
|
|
|
|
how can show the drives with memory and to install an application in particular drive
naveen
|
|
|
|
|
You may check free space of any drive by using an object of System.IO.DriveInfo class.
Therefore following line will provide you free disk space provided on c drive-
System.IO.DriveInfo dr= new System.IO.DriveInfo("C:\\");
long FreeSpace= dr.AvailableFreeSpace;
In case if you need to know about all logical drives available on a system, you may use Environment.GetLogicalDrives() method. This will return you a string array containing all logical drives available on a system.
Such as –
string[] drives = Environment.GetLogicalDrives();
I hope this helps.
-Dave.
Dave Traister,
ComponentOne LLC.
www.componentone.com
|
|
|
|
|
Hello,
I need to change a string array to string object. Can somebody please tell me how to do that?
Thank you.
|
|
|
|
|
What are you trying to accomplish? Everything in .NET is already implicitly an object. An array is, by definition, a collection of like values. You can't convert a string array to a string object, but you can access individual elements inside of the array.
|
|
|
|
|
//String array
string[] stringArray={"a","b","c"};
//Get a string value at a certain position
string first = stringArray.GetValue(0).ToString();
string second = stringArray.GetValue(1).ToString();
string third = stringArray.GetValue(2).ToString();
//enumerate through the array and get objects
foreach(string s in stringArray)
{
Console.WriteLine(s);
}
Hope this helps.
|
|
|
|
|
string[] myStringArray = new string[]{"foo","bar","due"};<br />
string myStringObject = String.Join(",",myStringArray);<br />
|
|
|
|
|
You can to that in few ways 
string[] strArray={"one","two","three"};
// Using foreach
string result = String.Empty;
foreach(string str in strArray)
{
result += str + "\n";
}
//Using ArrayList
StringBuilder sb = new StringBuilder();
foreach(string str in strArray)
{
sb.AppendLine(str);
}
// then for example
Console.Write(sb.ToString());
DEV36 Dominik Goss
|
|
|
|
|
Why would you do either with a perfectly usable String.Join method?
Both your examples are just equivalent to String.Join("\n",strArray)
|
|
|
|
|
Yes, you're right. You code is much more Object-oriented , and shorter
DEV36 Dominik Goss
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
