首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >从存储过程检索数据/向存储过程添加数据

问从存储过程检索数据/向存储过程添加数据
EN

Stack Overflow用户
提问于 2014-02-20 17:33:29
回答 1查看 117关注 0票数 0

好的,我有一个我必须创建的网页,它有3个页面和一个母版页。现在基本上所有的工作,除了事实,我似乎不能获得数据进入网页时,通过一个检索按钮,它也不会更新或添加数据到SQL表。现在,在我的查询页面中,当我放入Select * From Customer时,它会传回表中的数据,以便该部分正常工作。根据我在pdf中提供的内容,他们希望我使用

代码语言:javascript
复制
TextBox1.Text = table.Rows(0).Field<string>("TextBox1")  
TextBox1.DataBind()

为了从sql中检索数据,现在出现了一个错误Overload resolution failed because no accessible 'Field' accepts this number of arguments。

这是我的客户页面

代码语言:javascript
复制
Imports System.Data
Imports System.Configuration
Imports System.Data.SqlClient
Imports System.Data.DataRowCollection

Public Class Customer
Inherits System.Web.UI.Page

Dim conn As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("dbConnection1").ConnectionString)
Shadows adapter As SqlDataAdapter = New SqlDataAdapter()
// Tells me to use Shadows because variable adapter conflicts with property 'adapter'
Dim table As DataTable = New DataTable()
Dim command As SqlCommand = New SqlCommand()

Protected Sub btnAdd_Click(sender As Object, e As EventArgs) Handles btnAdd.Click
    Try
        conn = New SqlConnection(ConfigurationManager.ConnectionStrings("dbConnection1").ConnectionString)
        Dim command As SqlCommand = New SqlCommand()
        command.Connection = conn
        command.CommandType = CommandType.Text
        command.CommandText = "INSERT INTO Acme_Customer VALUES(" & txtCustID.Text & ",'" & txtFirstname.Text & "',  '" & txtSurname.Text & "', " & txtGender.Text & ",  " + txtAge.Text & ", " & txtAddress1.Text & ", " & txtAddress2.Text & ", " & txtCity.Text & ", " + txtPhone.Text & ", " + txtMobile.Text & ", " & txtEmail.Text & ")"
        command.Connection.Open()
        adapter.InsertCommand = command
        adapter.InsertCommand.ExecuteNonQuery()
        command.Connection.Close()
        Clear()
        lblMessage.Text = "You have been successfully added into our records"
    Catch ex As Exception
        lblMessage.Text = "Something has gone wrong with adding you to our records, please double check everything as we want you to become a member."
    End Try
End Sub


 Protected Sub btnRetrieve_Click(sender As Object, e As EventArgs) Handles btnRetrieve.Click

    Try
        command.Connection = conn
        command.CommandType = CommandType.StoredProcedure
        command.CommandText = "GetCustomer"
        command.Connection.Open()
        Dim param As SqlParameter = New SqlParameter()
        param.ParameterName = "@ID"
        param.SqlDbType = SqlDbType.Int
        param.Direction = ParameterDirection.Input
        param.Value = txtCustID.Text
        command.Parameters.Add(param)

        adapter.SelectCommand = command
        adapter.Fill(table)

    txtFirstname.Text = table.Rows(0).Field<string>("Firstname")
        txtFirstname.DataBind()
    txtSurname.Text = table.Rows(0).Field<string>("Surname")
        txtSurname.DataBind()
    txtGender.Text = table.Rows(0).Field<String>("Gender")
        txtGender.DataBind()
    txtAge.Text = table.Rows(0).Field<Integer>("Age")
        txtAge.DataBind()
    txtAddress1.Text = table.Rows(0).Field<String>("Address1")
        txtAddress1.DataBind()
    txtAddress2.Text = table.Rows(0).Field<String>("Address2")
        txtAddress2.DataBind()
    txtCity.Text = table.Rows(0).Field<String>("City")
        txtCity.DataBind()
    txtPhone.Text = table.Rows(0).Field<Integer>("Phone Number")
        txtPhone.DataBind()
    txtMobile.Text = table.Rows(0).Field<Integer>("Mobile Number")
        txtMobile.DataBind()
    txtEmail.Text = table.Rows(0).Field<String>("Email")
        txtEmail.DataBind()
   Catch ex As Exception
        lblMessage.Text = "The ID you have entered doesn't exist."
    End Try

End Sub

所以我想知道我写错了什么,或者我是否应该使用其他代码而不是我这里的代码,我知道我应该使用C#,但我只是掌握了C#的诀窍,所以,希望我可以在这个项目结束后开始使用vb。

EN

回答 1

Stack Overflow用户

发布于 2014-02-20 17:42:50

代码语言:javascript
复制
Protected Sub btnRetrieve_Click(sender As Object, e As EventArgs) Handles btnRetrieve.Click
Try
    command.Connection = conn
    command.CommandType = CommandType.StoredProcedure
    command.CommandText = "GetCustomer"
    command.Connection.Open()
    Dim param As SqlParameter = New SqlParameter()
    param.ParameterName = "@ID"
    param.SqlDbType = SqlDbType.Int
    param.Direction = ParameterDirection.Input
    param.Value = txtCustID.Text
    command.Parameters.Add(param)

    adapter.SelectCommand = command
    adapter.Fill(table)
    dim objDV as dataview = table.defaultview

txtFirstname.Text = objDV(0)("Firstname").tostring
txtSurname.Text = objDV(0)("Surname").tostring
' Fill all other text boxes following above lines

   Catch ex As Exception
        lblMessage.Text = "The ID you have entered doesn't exist."
    End Try

End Sub
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/21903644

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档