doing updating from grid to sql server with stored procedure sql 2000 
Author Message
 doing updating from grid to sql server with stored procedure sql 2000

hello!

i have a grid on my form that i populate from the following
(non-helpful code removed)

Dim sSQL As String = "select state_id, state_rate from
dbo.tax_table_state"
Dim daGetStates As New SqlDataAdapter(sSQL, sConnectionString)
Dim dsStates As New DataSet()

daGetStates.Fill(dsStates, "States")
dgTaxInfo.DataSource = dsStates.Tables("States")

this shows the user some states and a tax rate for each state.  I want
the user to be able to update the tax rates for any states they want
(as many as they want too, 0, 1, 2, or 50).  i will have a update
button that writes the changes to the sql database.  i will write a
stored procedure to update one state (by the id) at a time.  so what I
need to do is have the update button only submit each changed rate one
at a time to the stored procedure.  it will not call the stored
procedure where the user didnt change the rate.  makes sense?

how do i do this?  i am new to .net

thanks
AP!



Tue, 12 Jul 2005 04:51:43 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Calling a SQL Server 2000 store procedure from MS-Access

2. VB.NET,SQL SERVER 2000 STORED PROCEDURE PARAMETERS, CRYSTAL REPORTS

3. Crystal Reports 8.5, SQL Server 2000, and Stored Procedures

4. Type Name is Invalid error -- Windows 2000/98 application with SQL Server/stored procedure problem

5. SQL Server 2000 stored procedure not returning rows

6. Logging SQL Server 2000 Stored Procedure Output

7. Help Retrieve Result From Store Procedure (SQL Server 2000)

8. SQL Server 2000 stored procedure not returning rows

9. Executing MS SQL Server 2000 stored procs via MS Access 2000

10. VB6 application using SQL Server 2000 migrating db to SQL Server 2

11. Access 2000 VBA - SQL stored procedure question

12. Crystal Reports/SQL 2000 - Reporting from a Stored Procedure with multiple selects (for a sub-report)

 

 
Powered by phpBB® Forum Software