|
I have A query From Which I Want To Seperate Columns And Values
I Had Written Code For This.
My Query------
Insert Into DEPARTMENT_MASTER(DPM_ID,DPM_CM_COMP_ID,DPM_BM_ID,DPM_NAME)
values(-2147483614,'2','2','abc,xyz')
Code:--------
//// string StrQue Contains Above Query////////////////////////
string StrQue=Query.ToUpper();
String[] Arr1 = Regex.Split(StrQue.Trim(), "INTO");
String[] Arr2 = Arr1[1].ToString().Split('(');
String[] Arr3 = Arr2[1].ToString().Split(')');
String[] Arr4 = Arr2[2].ToString().Split(')');
String[] ArrCol = Arr3[0].ToString().Split(',');
String[] ArrVal = Arr4[0].Split(',');
But With Above Code Problem Is That In ArrCol I am Getting Correct 4 columns but
In ArrVal I am Getting 5 Values because it is Spliting coma(,) from last
value('abc,xyz') Thats whay I am getting 5 Values but I want 4 Values.
Can anyone give me solution. Its urgent
Thanks,
|
|
|
|
|
You need to parse the string manually.
Use a for loop to iterate down every character in the string. Keep a track of all the characters parsed so far. Every time you hit a , character, store the characters parsed so far in your array, clear and continue. Set a flag to false when you encounter a ' character, and then ignore all , characters until you pass another ' character, when you can set the flag back to true again.
Simon
|
|
|
|
|
Thanks For Reply.
But Simon,What If my insert query contains 70 columns and their values in that case it become time taking process to process that query charater by character.
|
|
|
|
|
Firstly, it's really not going to be time consuming to parse a few hundred characters. Unless your parsing 10's of thousands just don't worry.
Secondly. Use a Regex like Christian says.
(That's better than my suggestion anyway)
Simon
|
|
|
|
|
ArifShaikh wrote: Can anyone give me solution. Its urgent
I just checked, and it turned out it's not urgent at all. But, if it was, then you'd think you'd do what I already told you, to use a regex to parse this string.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
 Hi,
Sorry i am not having code.
i want to develop a web page. in this i am designing one page with some fields.this field will be entered by the user.and this full format should save in pdf file and again it should disply online. please can any one help me.
i want the code in C#.Net.
thanks in advance,
kavita![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
You need to get a PDF library to help you generate the PDF file. ItextSharp[^] is one example. There are others out there if you google.
So you take the user input, you use ItextSharp to generate your PDF file, then you return it to the client for display.
Simon
|
|
|
|
|
Hello,
while inserting arabic value into mydatabse , i have to put N before each field value to help sql to handle arabic language, is it any properties to give to the table in sql and help me to not put an N before fields.
best regards
dghdfghdfghdfghdgh
|
|
|
|
|
|
Why do you ask variations on the same question over and over ? Did you try a google to understand what the 'N' does ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi,
I have some data which has a state and a time stamp. I need to places this data in a list but have to be sure that items with the active state are all ontop sorted on the timestamp and when the status or timestamp is changed, it should be reordered accoring the new data.
Does any body knows a way to solve this?
greetings,
Rudy
|
|
|
|
|
I usually use a dataview to populate my data controls when I need sorting. You can then use and columns you wish in the sort string. When an item is changed refresh the dataview
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
But in a dataview I can't use an object with it's own intelligence ( own timer, properties etc)
|
|
|
|
|
How about using a SortedList, and when changing an item you remove it and insert it again?
|
|
|
|
|
I've thought about it, but I was more looking for a self ordering object/ list. The data can has something like a delay which will be handled by an internal timing function and when the timer expires the object state is changed and it should go up the list and get it's new place
|
|
|
|
|
It seems like a simple binary tree would satisfy your requirements.
|
|
|
|
|
Hi Friend's
Good Morning
I want Copy File Faster Than windows Explorer. it can be Possible Please Help me
Thanks
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
C:\> copy file.ext destination
xacc.ide - now with TabsToSpaces support IronScheme - 1.0 beta 1 - out now! ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))
|
|
|
|
|
I am not getting your Point Sir.
Basically i am using IO class for copy file but it equal to Explorer Copy.
i want copy fast than explorer copy.
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
Piyush Vardhan Singh wrote: I am not getting your Point Sir.
You were not very clear 
Piyush Vardhan Singh wrote: Basically i am using IO class for copy file but it equal to Explorer Copy.
Much better You could try reading the file into a (large) byte[] and copy it to it's new location, however, I doubt it will be much faster, if not slower. Best will be to try various combination's.
xacc.ide - now with TabsToSpaces support IronScheme - 1.0 beta 1 - out now! ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))
|
|
|
|
|
It would never occur to me that there is an alternative to using the IO class, except possibly a dos call. I have used a read/write scenario before but that is to clean up the file rather than move it.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
My experience had been that executing the CMD copy or xcopy commands can be much faster than using Explorer. Sometimes twice as fast!
|
|
|
|
|
All are Equal.....
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
If your application requires extremely fast file copies, you might consider storing your data in compressed form. This will use fewer bytes, thus speeding up your copies.
|
|
|
|
|
I am using vs 2003 with c#. I have a datagrid on my windows form. I want to display a checkbox with each record in datagrid how i can do this. second problem is that how I can recognize that which textbox in datagrid is checked and which or not.
Thanks in advance
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
