[2005] Insert Row using SqlDataSource

[Green Africa]

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

[mendhak]

Show some code that you're using to attempt insertion. Why aren't you using stored procedures? Are you really from Africa?

[RobDog888]

You should be executing a stored procedure instead of unprepared sql statements. The sp can be written to accept parameters.

[Green Africa]

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.

[mendhak]

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