No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
[U]users table[/U] userid PK + autoincrement name surname i wrote a procedure [ICODE]ALTER PROCEDURE insertUser @userid int, @name varchar(50), @surname varchar(50), AS SET NOCOUNT ON insert into users (userid,name,surname) values (@userid,@name,@surname,)[/ICODE] in aspx file i write [ICODE] cmd.Parameters.AddWithValue("@userid", ????????); cmd.Parameters.AddWithValue("@name", TextBox2.Text); cmd.Parameters.AddWithValue("@surname", TextBox3.Text);[/ICODE] what can i assign for userid column … |
|
i have multiple checkboxes on my form.i am trying to add them with stored procedure but it gives me [I]Procedure or function konut_ekle has too many arguments specified [/I] [CODE] protected void Button1_Click1(object sender, EventArgs e) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString); SqlCommand cmd; con.Open(); string cmdstr = "konut_ekle"; cmd … |
|
can you help me assign sql query to gridview..i am trying like this but it doesnt work. [CODE] Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Dim con As New SqlConnection("Data Source=SPERANZA\SQLEXPRESS;initial catalog=master;integrated security=true") Dim cmd As New SqlCommand Dim dr As SqlDataReader cmd.Connection = con con.Open() cmd.CommandText … |