I'm trying to do a nested Repeater where I have two tables, one is my region and second is the projects table. There's a foreign key in the projects table for region. I am doing an inner join in my stored procedure and I need the data to be displayed like this: Region 1 strDate strTitle strContent strDate strTitle strContent strDate strTitle strContent Region 2 strDate strTitle strContent strDate strTitle strContent strDate strTitle strContent Region 3 strDate strTitle strContent strDate strTitle strContent strDate strTitle strContent Not like this: Region 1 strDate strTitle strContent Region 1 strDate strTitle strContent Region 1 strDate strTitle strContent Region 2 strDate strTitle strContent Region 2 strDate strTitle strContent Region 2 strDate strTitle strContent The problem is that all the samples build the relation in the code behind, where as mine is done in the stored procedure doing a inner join. If someone could show me how to do this I would really appreciate it!!! Thanks, Jaime

I'm trying to do a nested Repeater where I have two tables, one is my region and second is the projects table. There's a foreign key in the projects table for region. I am doing an inner join in my stored procedure and I need the data to be displayed like this: Region 1 strDate strTitle strContent strDate strTitle strContent strDate strTitle strContent Region 2 strDate strTitle strContent strDate strTitle strContent strDate strTitle strContent Region 3 strDate strTitle strContent strDate strTitle strContent strDate strTitle strContent Not like this: Region 1 strDate strTitle strContent Region 1 strDate strTitle strContent Region 1 strDate strTitle strContent Region 2 strDate strTitle strContent Region 2 strDate strTitle strContent Region 2 strDate strTitle strContent The problem is that all the samples build the relation in the code behind, where as mine is done in the stored procedure doing a inner join. If someone could show me how to do this I would really appreciate it!!! Thanks, Jaime

I've got three records in my database in MS Sql Server 2000 and when I query the records the 1st and last records show up in my xml. Is there any reason why the 2nd record is not showing up? Here's my code: 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 System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using System.Xml; namespace web_test_net.for_xml_auto { /// /// Summary description for xml. /// public class xml : System.Web.UI.Page { protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1; protected System.Data.SqlClient.SqlCommand sqlSelectCommand1; protected System.Data.SqlClient.SqlCommand sqlInsertCommand1; protected System.Data.SqlClient.SqlCommand sqlUpdateCommand1; protected System.Data.SqlClient.SqlCommand sqlDeleteCommand1; protected System.Data.SqlClient.SqlConnection sqlConnection1; protected string xmlstring; protected XmlReader xmlreader; private void Page_Load(object sender, System.EventArgs e) { sqlConnection1.Open(); xmlreader = sqlDataAdapter1.SelectCommand.ExecuteXmlReader(); while (xmlreader.Read()) { xmlstring += xmlreader.ReadOuterXml(); } //Response.ContentType = "text/xml"; //Response.Write("" + xmlstring + ""); Response.Write("test="+xmlstring); sqlConnection1.Close(); } and my sql command is: select * from test for xml auto If anyone can I would be much appreciated. Thanks in advance!

I'm trying to write a function in a class .cs file that loads web user controls into a placeholder that's located on my main.aspx page. Does anyone know how to do that? I am new to asp.net, so an example would be really helpful! Thanks in advance! Jaime

I'm using page tracing method and instead of writing it over and over, I wanted to write a function in a .cs page and just call the function from my other pages. Here is my code: public void pageTracing() { if (Request["trace"] == "trace") { Trace.isEnabled = true; } } It's giving me these errors: The name 'Request' does not exist in the class or namespace 'web_isotope.functions.clsFunctions' The type or namespace name 'Trace' could not be found (are you missing a using directive or an assembly reference?) If you please could, give me an example of the correct way to do this, I'm just beginning, thanks in advance!

Hey Heath, The function that I created on the main.aspx.cs page can be accessed from user.ascx.cs page, I don't have any problem with that. In traditional .asp pages I could just create a variable called pageStatus = "main" on the main.asp page and the user.ascs page would be an include file which would hold my flash application that have status = <%pageStatus%>, so if I went to home.asp page, the home.asp page would have pageStatus="home" and the services.asp page would have pageStatus="services". So in my flash application anytime you would go a page it would display the value of that page accordingly. Sorry, if I sound frustrated, doing some of the simpliest things in asp is a little more difficult in asp.net. I wrote this function out of frustration, I know there is a simpler way to do it. Thanks a lot in advance! public string pageStatus() { string strURL = Request.ServerVariables["URL"]; StringBuilder replaceFunc = new StringBuilder(strURL); strURL = replaceFunc.Replace("/web_isotope/","").ToString(); strURL = replaceFunc.Replace(".aspx","").ToString(); return strURL; } Also can I inheret the class from my main.aspx.cs page in the user.ascs.cs page. Thanks again. Jaime

I'm trying to pass variables from my main.aspx page to the web user control page. I have a flash application that reads the variables and based on that displays a certain item that's embedded in the web user control page. The variable that I created needs to be on the main.aspx page, so when flash opens up it can tell which page it's on. It looks something like this: This is on the control.ascx page, the problem with this is that it has to be on the same aspx page. This is on the main.aspx.cs page public string pageStatus() { return "home"; } I have also accomplished my goal by using session variables, but I don't want to use them. Is there is any way to inheret the function that's on the main.aspx or pass somekind of global variable to where it can be accessed anywhere. Remember that the variable needs to be in the main.aspx page, it can't be in a class library or component. Thanks, Jaime C