User Profile

speranza · Jan 5 '10, 02:26 PM

cant pass null value to sp via linq

this is my sp code
IF @Param1 IS NOT NULL
BEGIN
SET @Param1=@Param1
END
ELSE
BEGIN
SET @Param1=' IS NULL'
END

and this my cs code

mmsDataContext mms = new mmsDataContext( );
RadGrid1.DataSo urce = mms.SON(Country .SelectedItem.V alue);
RadGrid1.DataBi nd();

speranza · Jun 11 '09, 08:15 AM

i have multiple checkboxes on my form.i am trying to add them with stored procedure but it gives me Procedure or function konut_ekle has too many arguments specified

Code:

protected void Button1_Click1(object sender, EventArgs e)
    {

        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString);
        SqlCommand cmd;

...

speranza · Nov 15 '08, 02:14 PM

Hi,
İ dont know how to assign sql command query value to a gridview..i am trying like this..it dosnt work can you help me?

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

...

User Profile

Profile Sidebar

sending null parameter from combox to sp via linq

Procedure or function ... has too many arguments specified.

Gridview Datasource