update column in database

hasib budi

Hi, i have problem with update column in database. For right now i have a table name fileinfo, which contain csv file name,file size and number of row in csv. For first time the program run.It will save the csv file name and file size into fileinfo. The second time running. It will open csv file and save number of row in csv. The problem is if the fileinfo has two file. Both will have same value. for example, if csv file1 has 300row,csv file2 also will have 300row but in folder csv file2 only have 10 row. How can i do it ?

int row = list.Count;
Console.WriteLine("Number of row " + row);
var upd1 = "update fileinfo set row =@row;
var cmd5 = new NpgsqlCommand(upd1, conn);
cmd5.Parameters.AddWithValue("@row", Convert.ToDouble(row));

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

hasib budi6y ago
ok, i will post a new question.
Amit Gupta6y ago
error : "text =@text"

In your question, where you had put text column? Please clarify your issue a bit more so that we can figure out the solution
hasib budi6y ago
if I put where condition, it will display error text=@text. Before this, I put where condition.

update fileinfo set row=@row where filename =@filename

error : "text =@text"
Amit Gupta6y ago
I am surprized that your update command is missing WHERE condition, without this it will update the whole table