Wrap long line that has a string

Question

Hello:

I have a long line that has a string in it. How can I wrap the line to multiple lines? The line I have is below. I tried the '_' but it will not take it for the string.
string querystring = "Driver={Microsoft Text Driver (*.txt; *.csv)};defaultdir=C:\\IceCorp;driverid=27;fil=text;filedsn=C:\\IceCorp\\IP_Login.csv;maxbuffersize=2048;maxscanrows=8;pagetimeout=5;safetransactions=0;threads=3;uid=admin;usercommitsync=Yes";

kiran kumar · Answer

hello giorgioi have written a sample code for youcheck this i am uploading the files here mark the answer if it helps you

Sam Hobbs · Answer

Note that it really helps when you check the  Do you like this Answer  checkbox for replies that do help but if your question is not answered then it might be better to not check that box. Only one reply per thread can have that checkbox checked. Of course you can always check a different reply when you get one that does help but note that if a thread has the checkbox checked then other people that might be able to help might not look at the question since you have checked the checkbox. You can put long strings into the Settings for the program. Do you know how to do that? In the solutions explorer expand the Properties node and then open the Settings.Settings node. You should see a grid with columnss for name type scope and value. You can put strings in there. For strings that are not changed by the user the scope should be application. Then in your program use something such as the following to get the string: Properties.Settings.Default.ConnectionString The reason why _ does not work is because that is VB syntax; it is not recognized by other languages.

Sam Hobbs · Answer

Yes you did check the checkbox indicating that the reply is the answer but if the reply does not answer your question then you might not get an answer if you have indicated the question is answered by checking the checkbox. People get points for providing help that answers questions and the person trying to help gets points when you check the checkbox. You can check only one reply in each thread (question). I am sorry for being picky but I want you to understand. The person that submitted a suggestion is the one that gets points when the checkbox for the reply is checked.

Gustavo · Answer

Sam: ??? I did check  Do you like this Answer  for this post. It does not show? I knwo I have one other post that I have not really gotten an good answer. Now I have to figure out how to set the Properties.Settings.Default.ConnectionString. Thanks

Gustavo · Answer

Kiran: i got your problem?so you pre defined your columns in grid..after data binding data comes after the pre defined columns so you dont want that pre defined columns in the grid.right? I just want to force the data to start in column 1. I found some setting like HDR=No; and F irstRowHasNames=0; but it does not work. Is it that the ODBC must have the header?

kiran kumar · Answer

i got your problem? you pre defined columns in the grid..after data bindingdata comes after the pre defined columnsso you dont want that pre defined columns in the grid.right?

Gustavo · Answer

Kiran: The dataGridView1.ColumnHeadersVisible = false; is not what I am looking for. I read some stuff like to set: HDR=No. But I cant get it to work. I just want the first column in the file to load into the first colum of the grid.

kiran kumar · Answer

if you dont want to display column headers just put the below line in your code dataGridView1.ColumnHeadersVisible = false; mark the answer if it helps you

Gustavo · Answer

Kiran: I do want column names but I already set them up in the program by using 'Edit Columns' on the grid. Because I use the 'column names' to find stuff. I just want the data loading to start with column 1. It seems because the grid already has defined column names it adds the new column names at the end so my data starts at like comlumn 8. LOL... Did I confuse it more?

kiran kumar · Answer

you dont want to have column names to be displayed in the grid?else like the one above i specified you want to change the column name. no problem mani feel very happy to help you

Gustavo · Answer

Kiran: ??? That would set the colum name to hello correct? What I wanted is when the code below loads the data it automatically loads the 1t like as the column name. I would like it to supress the loading of the column names. Maybe I am asking too much? Is there a Heder suppress option? string querystring = Driver={Microsoft Text Driver (*.txt; *.csv)}; + defaultdir=C:\IceCorp; + driverid=27; + fil=text; + filedsn=C:\IceCorp\IP_Login.csv; + maxbuffersize=2048;maxscanrows=8; + pagetimeout=5; + safetransactions=0; + threads=3; + uid=admin; + usercommitsync=Yes ; OdbcConnection con = new OdbcConnection (querystring); OdbcDataAdapter da = new OdbcDataAdapter ( select * from IP_Login.csv  con); DataTable dt = new DataTable (); da.Fill(dt);

kiran kumar · Answer

hello giorgio try this line of code ds.Tables[0].Columns[0].ColumnName =hello; //ds refers to dataset object mark the answer if it helps you

Gustavo · Answer

Kiran: I figured it out. I was hoping to use the '_' to continue the line but I guess it does not work for a string. So I did this: string querystring = Driver={Microsoft Text Driver (*.txt; *.csv)}; + defaultdir=C:\IceCorp; + driverid=27; + fil=text;filedsn=C:\IceCorp\IP_Login.csv; + maxbuffersize=2048;maxscanrows=8; + pagetimeout=5; + safetransactions=0; + threads=3; + uid=admin; + usercommitsync=Yes ;

Gustavo · Answer

Kitar: BTW: In the dataGrid issue. I already have the hearder defined in the program. Is there a way when it loads the data suppress the hearder that are in the file. Seems its appends the data and hearder as columns.

kiran kumar · Answer

if the above code helped youmark the answer

Gustavo · Answer

Kiran: Sorry... I ment in the code. So it does not go past the window. But this is a good sample. I can use it later.

Gustavo · Answer

Kiran: I dont understand? I typed 'querystring.split' the help does not see any. I tried Splitter and SplitContainer... it does not work. I am probably doing something wrong.

kiran kumar · Answer

hello giorgio try like this string[]words=querystring.split(';'); hope it resolves your problem mark the answer if it helps you