Hi, please help
I am trying to populate a table in a SQL Sever DB, but I am having trouble assigning the InsertParameters. I am using normal textboxes and a SqlDataSource.
Thanks
Printable View
Hi, please help
I am trying to populate a table in a SQL Sever DB, but I am having trouble assigning the InsertParameters. I am using normal textboxes and a SqlDataSource.
Thanks
Show some code that you're using to attempt insertion. Why aren't you using stored procedures? Are you really from Africa?
You should be executing a stored procedure instead of unprepared sql statements. The sp can be written to accept parameters.
Thanks, I can see that a SP will be the better option, I am coming from a VB6 environment and are realy not used to the asp \ web way of doing things.
Like how does data binding work if you are not using a data control and want to populate just normal text boxes...
and Mendhak yes I am from South-Africa.
There are many ways to do it, you could even bind a textbox to a dataset, but common practice is that you retrieve the value into a dataset and directly assign the value...
Textbox1.text = ds.tables[0].Rows[4].Columns["suppliername"].ToString();
Seth Africa? That's not really Africa. That's Europe :P