Member Avatar for Elmo_loves_you

Hmmm ok

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

Member Avatar for dickersonka

It might be MSSQLSERVER or SQLEXPRESS

Member Avatar for Elmo_loves_you

It might be MSSQLSERVER or SQLEXPRESS

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

Member Avatar for banbareesan

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();
        }


    }
Member Avatar for banbareesan

please store procedure using c# coding please send me

Member Avatar for umer asif

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.