hi how to populate radiobuttonlist from the backend I am using C#,Asp.net I f i am using data relations of two /three tables. can anyone give me clue or website dealing with this topic thanks :rolleyes: kal2na2

:rolleyes:C# code behind private void Page_Load(object sender, System.EventArgs e) { if(!Page.IsPostBack) { SqlConnection con=new SqlConnection("server=KHWA73R;database=NorthWind;user id=sa;password=sa"); try { SqlCommand cmd=new SqlCommand("SELECT Customers.CustomerID,Orders.OrderID,Customers.CompanyName,Products.ProductName FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID INNER JOIN Products ON [Order Details].ProductID = Products.ProductID where Customers.CustomerID='VINET'",con); //SqlCommand cmd=new SqlCommand("SELECT Customers.CustomerID,Orders.OrderID,[Order Details].OrderID AS Expr1,[Order Details].ProductID,Products.Customers.CompanyName,Orders.OrderDate,[Order Details].Quantity,Products.ProductName FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID INNER JOIN Products ON [Order Details].ProductID = Products.ProductID where Customers.CustomerID='VINET'",con); SqlDataAdapter adapter=new SqlDataAdapter(cmd); SqlDataReader reader=cmd.ExecuteReader(); //SqlDataAdapter adapter=new SqlDataAdapter("SELECT Customers.CustomerID,Orders.OrderID,[Order Details].ProductID,Customers.CompanyName,Orders.OrderDate,[Order Details].Quantity,Products.ProductName FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID INNER JOIN Products ON [Order Details].ProductID = Products.ProductID where Customers.CustomerID='VINET'",con); DataSet custDS=new DataSet(); con.Open(); adapter.Fill(custDS); DataRelation custOrderRel = custDS.Relations.Add("CustOrders", custDS.Tables["Customers"].Columns["CustomerID"], custDS.Tables["Orders"].Columns["CustomerID"]); DataRelation orderDetailRel = custDS.Relations.Add("OrderDetail", custDS.Tables["Orders"].Columns["OrderID"], custDS.Tables["OrderDetails"].Columns["OrderID"], false); DataRelation orderProductRel = custDS.Relations.Add("OrderProducts", custDS.Tables["Products"].Columns["ProductID"], custDS.Tables["OrderDetails"].Columns["ProductID"]); foreach (DataRow custRow in custDS.Tables["Customers"].Rows) { Console.WriteLine("Customer ID: " + custRow["CustomerID"]); foreach (DataRow orderRow in custRow.GetChildRows(custOrderR

:~ hi in my project both datagrid and radiobuttonlist are missing i am posting the code please let me know what is wromg i am unable to find it out.only button is showing asp.net-html form

kal2na2 -- modified at 7:17 Monday 5th December, 2005

hi its sqlConnection2.Open() not sqlConnection1.Open() string selectCommand="select Date,Start1_Code ,Start2_Code from Dates where Start1_Code='SMP' and Start2_Code='SAD' Order By Date"; but still same thing persits is something wong in my stored procedure kal2na2

hi here i am posting my code lbs and lbd are listbox names sqlConnection1.Open(); string selectCommand="select Date,Start1_Code ,Start2_Code from Dates where Start1_Code='SMTP' and Start2_Code='SAD' Order By Date"; SqlDataAdapter myCommand=new SqlDataAdapter(selectCommand,sqlConnection2); myCommand.SelectCommand.Parameters.Add(new SqlParameter("@Start1_Code",SqlDbType.NChar,3)); myCommand.SelectCommand.Parameters["@Start1_Code"].Value=txtMsg.Text; ; myCommand.SelectCommand.Parameters.Add(new SqlParameter("@Start2_Code",SqlDbType.NChar,3)); myCommand.SelectCommand.Parameters["@Start2_Code"].Value =Start2_Station_Code; DataSet dataset=new DataSet(); myCommand.Fill(dataset,"Dates"); lbs.DataSource=dataset.Tables["Dates"].DefaultView; lbs.DataBind(); lbd.DataSource =dataset.Tables["Dates"].DefaultView; lbd.DataBind(); sqlConnection2.Close(); kal2na2

:((hi System.Data.SqlClient.SqlException: Prepared statement '(@Start_Code nchar(3),@Start1_Code nchar(3))select ' expects parameter @Start1_Code, which was not supplied. I am getting such error in my project asp.net with code behind C#.net any idea how to resolve it kal2na2 -- modified at 6:12 Friday 2nd December, 2005

:wtf:hi I have written this code for creating radiobutton in the datagrid in asp.net codebehind C#.I am getting error crating control in the design view .Please any one of u check n tell me what is wrong I am unable to figure it out <%@ Page language="c#" Codebehind="WebForm4.aspx.cs" AutoEventWireup="false" Inherits="Railways.WebForm4" %> <%@ Register TagPrefix="vs" Namespace="Vladsm.Web.UI.WebControls" Assembly="GroupRadioButton" %> WebForm4

kal2na2 -- modified at 1:00 Wednesday 23rd November, 2005

I need a code for the project in asp.net with C# as codebehind where i have selected datagrid ,created template column and called radio button in it.Now i want to select a radio button and click a submit button to call an other page .The data in the datagrid gets populated the moment the page is called . I gave the radio button as groupname="SelectPlace" which gives an error code in the design view .If I use radio button without using datagrid if then else statement if(RadioButton1.Checked="Place") { Label.Text="place :"+RadioButton1.Text;} else if(RadioButton2.Checked="Place") { Label.Text="place :"+RadioButton2.Text;} else if(RadioButton3.Checked="Place") {Label.Text="place :"+RadioButton3.Text;} I get error near Place and when i try to bind with these radio buttons with dataview it gives me missing assembly line ? Can any one solve this problem for me At present I dont know what i am supposed to do . kal2na2

:~ hi I am having problem in procedure i am getting error as 'Scope_Identity' is not a recognized function name.I read an article that @@IDENTITY should be used is it helpful.The procedure is for the inserting the details. thanks kal2na2

:confused:hi in my project of asp.net codebehind C#.net I am calling three tables for that i have created data relations of parent child relationship . Iam not using datgrid simple textbox and radio button and creating dataview for the radio buttons for selection when I compile it point to defaultview and ask for using assembly code or reference code.Can anyone help me out. Sorry its not dataview its defaultview.:~ kal2na2 -- modified at 2:11 Monday 14th November, 2005

:~ hi I have a problem in my project-I am using asp.net and code-behind is C#.net so in Calendar control I want to restrict the month and the date should gets stored in the database for that I am using Dayrender event and customising the control while running the date gets displayed but there is no restiction in the months and the date is not getting stored at the backend If I put any condition in DayRender event if(e.Day.IsWeekEnd >9 Or e.Day.Date.Year >2100) { e.Day.IsSelectedDate=false; } it shows error in the ".",">","Or" Symbols I dont know how to deal with this .Please as soon as possible kal2na2