I have a dropdownlist within my editable gridview.The datasource of the gridview is a datatable method which accepts as a parameter the text of the lable of one of the columns in the gridview.I'm using the code below to try this task but it is not working. protected void gvServices_DataBinding(object sender, GridViewRowEventArgs e) {//gvServices is a gridview name if (e.Row.RowType == DataControlRowType.DataRow) { DropDownList ddl = (DropDownList)e.Row.Cells[3].FindControl("DDLServType"); Label lbl = (Label)e.Row.Cells[2].FindControl("lblServiceName"); string servicename= lbl.Text; ddl.DataSource = st.getServiceTypes(servicename); ddl.DataBind(); } }

ML Lingwati

I have to create a statement for each client from my application.I have a stored procedure that filters the transactions data for each client using say the client ID.Linking or executing the stored procedure is a method in my data access layer through to my business layer returning a datatable.I want my crystal report to be populated using this methods, so i can pass the client ID as a parameter. Please help.

ML Lingwati

I'm using a cascading dropdownlist using three tables. the code below works fine if my primary keys are numeric(integer) but my business rules want the primary keys to be alphernumeric(string). [WebMethod] public CascadingDropDownNameValue[] GetColors(string knownCategoryValues, string category) { StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues); int colorId; if (!kv.ContainsKey("Model") || !Int32.TryParse(kv["Model"],out colorId)) { return null; } dsModelColorsTableAdapters.ModelColorsTableAdapter adapter = new dsModelColorsTableAdapters.ModelColorsTableAdapter(); dsModelColors.ModelColorsDataTable colors = adapter.GetColorsByModelId(colorId); List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); foreach (DataRow dr in colors) { values.Add(new CascadingDropDownNameValue((string)dr["ColorName"], dr["ColorID"].ToString())); } return values.ToArray(); } How do I use my string primary key using the above code? Please help an ajax technology adict.

ML Lingwati

I'm using a cascading dropdownlist using three tables. the code below works fine if my primary keys are numeric(integer) but my business rules want the primary keys to be alphernumeric(string). [WebMethod] public CascadingDropDownNameValue[] GetColors(string knownCategoryValues, string category) { StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues); int colorId; if (!kv.ContainsKey("Model") || !Int32.TryParse(kv["Model"],out colorId)) { return null; } dsModelColorsTableAdapters.ModelColorsTableAdapter adapter = new dsModelColorsTableAdapters.ModelColorsTableAdapter(); dsModelColors.ModelColorsDataTable colors = adapter.GetColorsByModelId(colorId); List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); foreach (DataRow dr in colors) { values.Add(new CascadingDropDownNameValue((string)dr["ColorName"], dr["ColorID"].ToString())); } return values.ToArray(); } How do I use my string primary key using the above code? Please help an ajax technology adict.

ML Lingwati

I'm using a cascading dropdownlist using three tables. the code below works fine if my primary keys are numeric(integer) but my business rules want the primary keys to be alphernumeric(string). [WebMethod] public CascadingDropDownNameValue[] GetColors(string knownCategoryValues, string category) { StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues); int colorId; if (!kv.ContainsKey("Model") || !Int32.TryParse(kv["Model"],out colorId)) { return null; } dsModelColorsTableAdapters.ModelColorsTableAdapter adapter = new dsModelColorsTableAdapters.ModelColorsTableAdapter(); dsModelColors.ModelColorsDataTable colors = adapter.GetColorsByModelId(colorId); List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); foreach (DataRow dr in colors) { values.Add(new CascadingDropDownNameValue((string)dr["ColorName"], dr["ColorID"].ToString())); } return values.ToArray(); } How do I use my string primary key using the above code? Please help an ajax technology adict.

ML Lingwati

I have a stored proc that inserts data into four tables and the stored proc executes perfectly fine when executed in sql server.To execute the stored procedure from my data access layer I chose a method which call the method in class that connects to my database, but now when trying to run the whole application, it comes back to me with the "StackOverflowExeption" any idea what might be causing that? because the error occurs right on my connection string.

ML Lingwati

I'm using a stored procedure to populate a crystal report, But I get repeatative(duplicated) information on my report- something like 66 pages instead of atleast 2. I want to produce a transactions statement for a particular user, using the crystal report, with the stored procedure getting data from multiple tables, accepting as a parameter the name of a particular client(user). Am I using the crystal report for good purpose or may be the stored procedure isn't just a way of doing it?

ML Lingwati

Hemant Thaker wrote:

Which are these columns.... Means r u getting same columns twice??

No I mean, It includes columns returned by other datatables

ML Lingwati

I have a data gridview on which I want to display data from a datatable. For some unknown reasons, the datatable returns the expected columns plus other unexpected columns with no values in them.I've checked all of my stored procedures and methods that return the datatable and they seem to be fine. How do I limit the gridview to columns I need to see and restrict the other useless columns from displaying in my grid view? Forgive me if I'm in a wrong forum.

ML Lingwati

I am developing an asp.net map control application to help people who cannot find their way to their destination when they go to events, any tips on how i can find something similar to google earth in order to make my application functional?

ML Lingwati

I want to know how to be able to interact with asp page controls like buttons and dropdown lists without the whole page refreshing and also be able to use the query string to update the content within the contols without the whole page refreshing itself. Thank you in advance

ML Lingwati

Sorry I didn't finish the thread. it got posted by mistake before I could finish. But my problem is when, the page is running, after clicking some option on the drop down list the page loads with the page load code, while I expect the results of the actions(code) that I placed under the drop down list Selected_Change event.How do solve this problem? hope i'm clear. please help.

ML Lingwati

I have a code on the form load of my page to populate the controls of my page with some data. I also have a dropdown list that when clicked must populate the page with some other data.

ML Lingwati

How to design asp.net popup screens

ML Lingwati

I'm using a querystring to pass values from a page to page. Now the thing is if you copy the URL, close the application, open IE and paste the URL, you get the same page. So, since I believe I'm passing sensitive information I think this is very much insecure. Please help me secure my information. Say if "the crook" pastes the URL, I want my application to prompt them to login first.

ML Lingwati

I want to use textbox value(text) in another asp.net page. eg. displaying txtName.Text from page1 in lblName in the next page OR use that value as a parameter passed to method calling under a button in the next page.

ML Lingwati

I am using the following stored procedure to insert into two tables and it works fine ALTER PROCEDURE createEmployee(@loginId VARCHAR (20), @username VARCHAR (25), @passwrd VARCHAR (25),@empId VARCHAR (20),@title varchar(5),@branchNo VARCHAR(20),@Fname VARCHAR(50),@idNo VARCHAR(13),@physicaladdress varchar(50),@province VARCHAR(50),@city VARCHAR(50),@telephone varchar(15),@cellNo VARCHAR(15),@Email VARCHAR(30),@employeetype varchar(15),@salary NUMERIC(11,2)) AS INSERT INTO LoginInfo VALUES(@loginId,@username,@passwrd) --SET @loginId=@@IDENTITY INSERT INTO EMPLOYEE VALUES(@empId,@loginId,@title,@branchNo,@Fname,@idNo,@physicaladdress,@province,@city,@telephone,@cellNo,@Email,@employeetype,@salary); But Note the @branchNo parameter to be inserted into the EMPLOYEE table. I need to get it from a table named BRANCH based on some criteria. Currently I have hard coded its(@branch parameter)its value.I've tried to use the column level Select subquery but it is not allowed. please give a junior developer some logic

ML Lingwati

How do I select the options of a multiple choice question, for the multiple choice question that I selected randomly. Remember, I can't select the options randomly because they have to match the question even though the questiion is selected randomly. The questions are from the Questions Table and the options are from the Options Table. I hope I'm clear please help.

ML Lingwati

I have a Questions table in my database where the quuestiions are selected randomly using the following code "public DataTable getQuestion(string concept,string questiontype) {//gives the user the question for the concept selected above string sql = ""; if (concept == "basic") { sql = "SELECT Question FROM Questions WHERE ConceptId LIKE 'BC%'AND QuestionType ='" + questiontype + "' Order by NewId()"; } else if (Concept == "programming") { sql = "SELECT Question FROM Questions WHERE ConceptId LIKE 'PC%'AND QuestionType ='" + questiontype + "'Order by NewId()"; } return dc.load(sql);//dc is an object of data connection class } Another question type is of multiple choice.And for this type of question there's an Options Table which I need to get the options of the question selected randomly using the code above. Any idea how I can do that? Please help.

ML Lingwati

kumar_k508 wrote:

Yes,it is possible... Exactly what do you want?

I want to display one question at a time from the Questions table in my database.

ML Lingwati