Hmmm ok

Im stiil trying to figure out how to set that up properly ... Teratrax Performance Agent > Server Configuration > SQL Server Instance name.

It might be MSSQLSERVER or SQLEXPRESS

It might be MSSQLSERVER or SQLEXPRESS

Hi, that program requires Oracle client and networking components! Why is that if im only using SQL Server

please select coding please currect

        private void button3_Click(object sender, EventArgs e)
    {
        String constr = "server=SYSTEM-1\\SQLEXPRESS;Initial Catalog=anbu;user id=sa;password=missoft";
        SqlConnection con = new SqlConnection(constr);
        con.Open();

        SqlCommand com = new SqlCommand("procemp_sel", con);
        //SqlDataAdapter sqlda = new SqlDataAdapter(com);
        //DataSet ds = new DataSet();

       //com.Parameters.Add("@Empcode", SqlDbType.Int).Value = textBox1.Text;
        com.Parameters.Add("@FName", SqlDbType.NVarChar).Value = textBox2.Text;
        com.Parameters.Add("@LName", SqlDbType.NVarChar).Value = textBox3.Text;
        com.CommandType = CommandType.StoredProcedure;

        //com.Parameters[0].Value = textBox1.Text ;
        com.Parameters[0].Value = textBox2.Text ;
        com.Parameters[1].Value = textBox3.Text ;

        SqlDataAdapter sqlda = new SqlDataAdapter(com);
        DataSet ds = new DataSet();
        sqlda.Fill(ds);
        con.Close();

        {
            sqlda.Fill(ds);
            con.Close();
        }


    }

please store procedure using c# coding please send me

Member Avatar

if the number of parameters are same then try to check their types. parameter types must be the same as in the table

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.