Comments by M.Thiyagaraja

M.Thiyagaraja 19-Jul-14 2:29am View

Suppose Org_id=1 means , the corresponding id details(such as Org Name, Address,Phone,Email) wants to retrieve vertically. in next cell, selected id (checkbox)details should be display as like Org_id=1.

M.Thiyagaraja 18-Jul-14 9:45am View

I want to grouped all the columns in the GridView, and then ,

I need to show the result as below

Organization
Address
Phone
Email

Consider i have 4 selected records, All the 4 records must want to display in the above manner(In Simple words as like DataList)

M.Thiyagaraja 18-Jul-14 9:38am View

It displays the result horizontally.
As like below.
Organization | Address | Phone | Email

M.Thiyagaraja 21-May-14 9:06am View

Thank you very much Phanindra Baddula.....

M.Thiyagaraja 25-Apr-14 10:37am View

There is no head section in the above page then how can i Add the reference of external JavaScript file into ASP.Net form

M.Thiyagaraja 23-Apr-14 2:10am View

thank you so much sir/madam.....It's working fine....

M.Thiyagaraja 10-Mar-13 15:47pm View

Thank u for responding Pallavi Waikar....
At a time either insert nor update alone will happen... During that time how to make a code, from my .cs file kindly help me...

M.Thiyagaraja 9-Mar-13 4:12am View

Thank you Davidduraisamy...
My Doubt is how to use this stored procedure in code behind file...
here is my .cs file
protected void btnsubmit_Click(object sender, EventArgs e)
{
string UserName = txtuser.Text;
string Password = txtpwd.Text;
string ConfirmPassword = txtcnmpwd.Text;
string FirstName = txtfname.Text;
string LastName = txtlname.Text;
string Email = txtEmail.Text;
string Phoneno = txtphone.Text;
string Location = txtlocation.Text;
string Created_By = txtuser.Text;
int count = 0;
SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=sample;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand("sp_userinformation", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserName", UserName);
cmd.Parameters.AddWithValue("@Password", Password);
cmd.Parameters.AddWithValue("@FirstName", FirstName);
cmd.Parameters.AddWithValue("@LastName", LastName);
cmd.Parameters.AddWithValue("@Email", Email);
cmd.Parameters.AddWithValue("@PhoneNo", Phoneno);
cmd.Parameters.AddWithValue("@Location", Location);
cmd.Parameters.AddWithValue("@Created_By", Created_By);
cmd.Parameters.Add("@ERROR", SqlDbType.Char, 500);
cmd.Parameters["@ERROR"].Direction = ParameterDirection.Output;
count = cmd.ExecuteNonQuery();
message = (string) cmd.Parameters["@ERROR"].Value;
con.Close();
Page.RegisterStartupScript("UserMsg", "<Script language='javascript'>alert('" + "The Values are inserted Successfully " + "');</script>")
lblErrorMsg.Text = message;
}

M.Thiyagaraja 8-Mar-13 0:38am View

how to declared output parameter in stored procedure....
Thank you in advance...

Comments by M.Thiyagaraja (Top 9 by date)