Click here to Skip to main content
15,888,802 members
Home / Discussions / C#
   

C#

 
GeneralRe: Best way to store user pref's Pin
Drew Stainton21-Jun-05 18:57
Drew Stainton21-Jun-05 18:57 
GeneralPDF images to Tif Pin
robia21-Jun-05 2:05
robia21-Jun-05 2:05 
GeneralRe: PDF images to Tif Pin
Drew Stainton21-Jun-05 19:02
Drew Stainton21-Jun-05 19:02 
GeneralTreeview control Pin
Anonymous21-Jun-05 1:19
Anonymous21-Jun-05 1:19 
GeneralRe: Treeview control Pin
mav.northwind21-Jun-05 2:08
mav.northwind21-Jun-05 2:08 
GeneralRe: Treeview control Pin
Anonymous21-Jun-05 2:33
Anonymous21-Jun-05 2:33 
GeneralRe: Treeview control Pin
mav.northwind21-Jun-05 3:35
mav.northwind21-Jun-05 3:35 
Generalprogram Pin
mhmo21-Jun-05 1:15
mhmo21-Jun-05 1:15 
Hi all

I am writting a C# program that reads lines from a file. And then store each line in one record in more than one field.

But at the middle of the proccessing a message said that "v\cant open more tables"
here is the pic:
http://www.javadevs.com/problem.bmp[^]
copy the link and paste it in the browser...

And here is my code:

for (int i = 1; i<= Int32.Parse(numNumber.Value.ToString().Trim()); i++ ) {

string cha = answers.Substring(i-1,1);

string anCommand = "UPDATE information SET " + i + "='" + cha + "' WHERE id = '" + id+ "';";
try
{
com = new OdbcCommand(anCommand, dbConn);
com.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show( anCommand + "\r\nInserting answers\r\n" + ex.ToString());
stsGrade.Text = "Error!...";
return;
}
finally
{

}
}

It worked for the first 3 lines, but in the fourth line the problem appeared!!
All the lines has the same structure.
I am using MS Access database.
What is the problem?
GeneralRe: program Pin
mav.northwind21-Jun-05 2:02
mav.northwind21-Jun-05 2:02 
GeneralRe: program Pin
mhmo21-Jun-05 2:53
mhmo21-Jun-05 2:53 
GeneralRe: program Pin
J4amieC21-Jun-05 2:08
J4amieC21-Jun-05 2:08 
GeneralIn Depth Knowledge required Pin
Member 186032521-Jun-05 1:13
Member 186032521-Jun-05 1:13 
GeneralRe: In Depth Knowledge required Pin
Marc Clifton21-Jun-05 2:27
mvaMarc Clifton21-Jun-05 2:27 
GeneralC# Text file to PDF Pin
cyberhound21-Jun-05 1:09
cyberhound21-Jun-05 1:09 
GeneralRe: C# Text file to PDF Pin
occcy21-Jun-05 4:15
occcy21-Jun-05 4:15 
GeneralDynamic Forms Pin
Alper Camel21-Jun-05 1:05
Alper Camel21-Jun-05 1:05 
GeneralRe: Dynamic Forms Pin
mav.northwind21-Jun-05 2:07
mav.northwind21-Jun-05 2:07 
GeneralRe: Dynamic Forms Pin
Alper Camel21-Jun-05 23:00
Alper Camel21-Jun-05 23:00 
GeneralRe: Dynamic Forms Pin
Michael P Butler21-Jun-05 4:22
Michael P Butler21-Jun-05 4:22 
GeneralRe: Dynamic Forms Pin
Alper Camel21-Jun-05 23:05
Alper Camel21-Jun-05 23:05 
GeneralC# to VB.NET Pin
utsav_verma21-Jun-05 0:35
utsav_verma21-Jun-05 0:35 
GeneralRe: C# to VB.NET Pin
Dave Kreskowiak21-Jun-05 5:46
mveDave Kreskowiak21-Jun-05 5:46 
GeneralRe: C# to VB.NET Pin
Dave Doknjas21-Jun-05 15:33
Dave Doknjas21-Jun-05 15:33 
QuestionC#.NET - How to interact with another form? Pin
OhMyGoat20-Jun-05 22:02
OhMyGoat20-Jun-05 22:02 
AnswerRe: C#.NET - How to interact with another form? Pin
Corinna John20-Jun-05 23:18
Corinna John20-Jun-05 23:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.