Hi, I just install Visual Studio 2005 in my System.I tries to create Web application but i am not gatting Local IIS in Location drop down. My system already install VS 2002 and i want to continue with both the version. Help me to get Local IIS option in my VS 2005. Need Help!!!

Session varable stored on server memory their is no performance issue but using number of session variable is depend upon the server configarion and volume of user in appication. Dinuraj

how does cookieless = true work.What is the advantage. Can anyone help me

T-SQL transaction vs ADO.NET transactions What is the better to use between them? waiting for prompt reply

Hi, I am trying to bulk update database using dataset.I think so i have to pass update sql statement but i dont have idea. Can anyone hepl me... i am sending aspa page code as well code behind.. Please send me code not description.... <%@ Page language="c#" Codebehind="DataSetTest.aspx.cs" AutoEventWireup="false" Inherits="RnD.DataSetTest" %> DataSetTest

Code Behind:-- using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using Sy

Hi, I am developing a web appication using asp.net with c#. I am updating Dataset using datgrid EditItemTemplate and storing in cache. finally i want to update my table using SqlAdaptor Update mathod but i am gatting error.Please help me.. This is my Dataset Update mathod: public void grdEmployee_Update(Object o,DataGridCommandEventArgs e) { int id = (int)grdEmployee.DataKeys[e.Item.ItemIndex]; TextBox txtName,txtDesignation,txtSex,txtAge,txtSalary; txtName =(TextBox)e.Item.Cells[0].Controls[0]; txtDesignation =(TextBox)e.Item.Cells[1].Controls[0]; txtSex =(TextBox)e.Item.Cells[2].Controls[0]; txtAge =(TextBox)e.Item.Cells[3].Controls[0]; txtSalary =(TextBox)e.Item.Cells[4].Controls[0]; if (Cache["EMPCACHE"]!=null) { DataSet dsUpdate= (DataSet)Cache["EMPCACHE"]; dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["NAME"]=txtName.Text; dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["DESIGNATION"]=txtDesignation.Text; dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["SEX"]=txtSex.Text; dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["AGE"]=Convert.ToInt32(txtAge.Text); dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["SALARY"]=Convert.ToSingle(txtSalary.Text); dsUpdate.AcceptChanges(); Cache["EMPCACHE"]=dsUpdate; grdEmployee.EditItemIndex = -1 ; grdEmployee.DataSource = dsUpdate; grdEmployee.DataBind(); }} Finally i am going to update on Database using this code private void btnDatabaseUpdate_Click(object sender, System.EventArgs e) { try { string strConnection= System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString"); SqlConnection con = new SqlConnection(); con.ConnectionString = strConnection; SqlDataAdapter sda = new SqlDataAdapter("select ID,NAME,DESIGNATION,SEX,AGE,SALARY from EMPLOYEEDETAILS",con); SqlCommandBuilder scb = new SqlCommandBuilder(sda); sda.Fill(dsObj,"EMPLOYEEDETAILS"); DataSet dsUpdate = (DataSet)Cache["EMPCACHE"]; dsObj = dsUpdate.Copy(); int success=sda.Update(dsObj,"EMPLOYEEDETAILS"); dsObj.AcceptChanges(); grdEmployee.DataSource = dsObj; grdEmployee.DataBind(); } catch (Exception ex) { Response.Write(" " + ex.Message.ToString()); } } I am gatting this error: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information. waiting for promp reply

try this TextBox2.Text = DropDownList1.SelectedIndex.Text;

Hi, I am developing a web appication using asp.net with c#. I am updating Dataset using datgrid EditItemTemplate and storing in cache. finally i want to update my table using SqlAdaptor Update mathod but i am gatting error.Please help me.. This is my Dataset Update mathod: public void grdEmployee_Update(Object o,DataGridCommandEventArgs e) { int id = (int)grdEmployee.DataKeys[e.Item.ItemIndex]; TextBox txtName,txtDesignation,txtSex,txtAge,txtSalary; txtName =(TextBox)e.Item.Cells[0].Controls[0]; txtDesignation =(TextBox)e.Item.Cells[1].Controls[0]; txtSex =(TextBox)e.Item.Cells[2].Controls[0]; txtAge =(TextBox)e.Item.Cells[3].Controls[0]; txtSalary =(TextBox)e.Item.Cells[4].Controls[0]; if (Cache["EMPCACHE"]!=null) { DataSet dsUpdate= (DataSet)Cache["EMPCACHE"]; dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["NAME"]=txtName.Text; dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["DESIGNATION"]=txtDesignation.Text; dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["SEX"]=txtSex.Text; dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["AGE"]=Convert.ToInt32(txtAge.Text); dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["SALARY"]=Convert.ToSingle(txtSalary.Text); dsUpdate.AcceptChanges(); Cache["EMPCACHE"]=dsUpdate; grdEmployee.EditItemIndex = -1 ; grdEmployee.DataSource = dsUpdate; grdEmployee.DataBind(); }} Finally i am going to update on Database using this code private void btnDatabaseUpdate_Click(object sender, System.EventArgs e) { try { string strConnection= System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString"); SqlConnection con = new SqlConnection(); con.ConnectionString = strConnection; SqlDataAdapter sda = new SqlDataAdapter("select ID,NAME,DESIGNATION,SEX,AGE,SALARY from EMPLOYEEDETAILS",con); SqlCommandBuilder scb = new SqlCommandBuilder(sda); sda.Fill(dsObj,"EMPLOYEEDETAILS"); DataSet dsUpdate = (DataSet)Cache["EMPCACHE"]; dsObj = dsUpdate.Copy(); int success=sda.Update(dsObj,"EMPLOYEEDETAILS"); dsObj.AcceptChanges(); grdEmployee.DataSource = dsObj; grdEmployee.DataBind(); } catch (Exception ex) { Response.Write("
" + ex.Message.ToString()); } } I am gatting this error: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information. waiting for promp reply