Hi, I've been trying to view blob images from sql but when i select the colom it states System.byte[] I think this where my problem is? Please can you assist? Thanks, Monde

By sample you mean the fileds that is going to the app? If so here is the data. Day Visitors Sunday, May 3, 2009 1,245 The app reads the Visitors Colomn.

Hi All, I have an application that reads .csv data. My problem is that the is a value that is not read, it will read the number before the comma, but this is one number. How do i make the app read the full number, e.g.: 1,093? if (_lineItem == 12) { // the rows that will be added into the // specified columns dt.Rows.Add(new object[] { _dateParse, _casinoname, _line[3].Replace("\"", "").Replace("," , "")}); } _lineItem++; Thank you,

Hi All, I have a CSV file with two Columns, the first Column has quotes and in between those quotes there is a comma, how do I make my application not read the comma in between the quotes but read the second data in the second column? Please can you assist me please!! Regards, Ndeza

Hi All, Please can you assist me with this? I got this app the imports data from a csv file to the database. The format has changed to Day,Visitors "October 21, 2008",312 at the day column this the data that goes with this col "October 21, 2008" now i want the app to read whats after the " i want it to read 312. Please can you assist me on this one? Thank You Ndeza,

How about now

Hi All, I've got an application that opens a csv file and save the data in the file to a Database. When the app reads the file it only reads the second column my problem is, the format of the date in the file has changed the date use to be like, 20081019 now it has changed to "October 26, 2008",. The file is like Day,Visitors "October 26, 2008",356 where day is the date. Now the app reads year 2008 when i want it to read the Visitors 356. Please can you help me:):) Regards, Ndeza

modified on Tuesday, October 28, 2008 4:52 AM

Heya Sebastian, Wow you were right the Dictionary works perfect, but the only thing is that I have allot of exchange rates to update and insert and it only inserts for one where as I'm trying to insert in one go. Please can you assist if you can? Oh the second option is quite complicated as you will need to convert a string to an INT32. But I prefer the First Option much easier and more understandable. Regards, Ndeza /// create the dictionary Dictionary<TextBox, int> dictBoxes = new Dictionary<TextBox, int>(); /// than put the id in it dictBoxes.Add(txt0, 0); dictBoxes.Add(txt3, 3); dictBoxes.Add(txt5, 5); dictBoxes.Add(txt55, 55); dictBoxes.Add(txt6, 6); dictBoxes.Add(txt61, 61); dictBoxes.Add(txt76, 76); dictBoxes.Add(txt77, 77); dictBoxes.Add(txt81, 81); dictBoxes.Add(txt9, 9); //All the parameters that will be added to the database //also all the from the app cmd.Parameters.Add("@PlayerTypeID", SqlDbType.Int, 20); cmd.Parameters.Add("@DateYear", SqlDbType.Int, 40); cmd.Parameters.Add("@DateMonth", SqlDbType.Int, 4); cmd.Parameters.Add("@FXR", SqlDbType.Float); //Assigning the Values to the parameters cmd.Parameters["@PlayerTypeID"].Value = txt0.Text; cmd.Parameters["@PlayerTypeID"].Value = txt3.Text; cmd.Parameters["@PlayerTypeID"].Value = txt5.Text; cmd.Parameters["@DateYear"].Value = cbmYear.SelectedItem; cmd.Parameters["@DateMonth"].Value = cmbMonth.SelectedItem; cmd.Parameters["@FXR"].Value = txt0.Text; cmd.Parameters["@FXR"].Value = txt3.Text; cmd.Parameters["@FXR"].Value = txt5.Text; cmd.Parameters["@FXR"].Value = txt6.Text; cmd.Parameters["@FXR"].Value = txt9.Text; cmd.Parameters["@FXR"].Value = txt55.Text; cmd.Parameters["@FXR"].Value = txt61.Text; cmd.Parameters["@FXR"].Value = txt76.Text; cmd.Parameters["@FXR"].Value = txt77.Text; cmd.Parameters["@FXR"].Value = txt81.Text;

Ok, For each currency there is an ID, what I'm trying to do is make the Text box that I will also enter the new exchange rate into, the text box will correspond with the ID(PlayerTypeID). Basically, I’m trying to make the text box be an Id identifier and also an input text that will update the @FXR. What I mean by link; I want the text box to identify the id in which it will enter the new exchange rate. Thank you, Ndeza

Hi Sebastian, I've got a Foreign Exchange app that I'm trying to create, and the table is stored in the database. This table has an ID where it links to the different currencies. Now what I want to do is I want to link the text boxes of all the different currencies to the currencies in the table. I haven't done much with this but I've created a stored proc that updates, and inserts. cmd.Parameters.Add("@PlayerTypeID", SqlDbType.Int, 20); cmd.Parameters["@PlayerTypeID"].Value = txt0.Text; -- this is what I’ve been trying and it’s not working out. cmd.Parameters.Add("@DateYear", SqlDbType.Int, 40); cmd.Parameters["@DateYear"].Value = cbmYear.SelectedItem; cmd.Parameters.Add("@DateMonth", SqlDbType.Int, 4); cmd.Parameters["@DateMonth"].Value = cmbMonth.SelectedItem; cmd.Parameters.Add("@FXR", SqlDbType.Float); cmd.Parameters["@FXR"].Value = txt0.Text; cmd.Parameters["@FXR"].Value = txt3.Text; cmd.Parameters["@FXR"].Value = txt5.Text; cmd.Parameters["@FXR"].Value = txt6.Text; cmd.Parameters["@FXR"].Value = txt9.Text; cmd.Parameters["@FXR"].Value = txt55.Text; cmd.Parameters["@FXR"].Value = txt61.Text; cmd.Parameters["@FXR"].Value = txt76.Text; cmd.Parameters["@FXR"].Value = txt77.Text; cmd.Parameters["@FXR"].Value = txt81.Text; But now my problem is that I just cant get the PlayerTypeID being the ID link to the text box. Please can you assist with an example of some kind. Thank you, Ndeza

Hi All, I'm still new to development, I'm trying to link a text box to an ID in a table. This text box will be an identfier and it will insert the text to the table when it has linked to the id. Is this possible or should i look into something else. Regards, Ndeza