Dear all , I am using C# ,asp.net2.0 I am making question list (as question are dynamic) I list in gridview and inside gridview dropdownlist populated with possible response. Now I have to fetch each row of gridview and user response against it on button click outside of gridview Please suggest some link or ideas Thank you

regards imran khan

Dear all, I am using C# , asp.net2.0 Actually I have a making survey form where based of request no of question displaying NOW quesetion is saved in table as questionid and questiondesp. I am creating theses control and assign questiondesp to level but I have to save response against questionid . my question is is there any other mean where I can display question and store value just like dropdownlist Please suggest Thank you.

regards imran khan

Dear all, i am using C# , asp.net2.0 ,ajax1.0 i have situation where a name is entered in text box. if that name is already exeist in database pop up the message that username already exist. please suggest some idea or link to implement this Thank you.

regards imran khan

Dear all, I am using asp.net 2.0 , C# I want to use application block for data accessing. I download DataAccessApplicationBlock msi and install the same but I want to know I can I use application block in my project. Please help . THANK YOU

regards imran khan

Dear All, i am using asp.net2.0 ,C# . let me tell you scenario. i built a web application called daily call report that have two classes in the folder app_code and other aspx file and its code behind file. now i have to deploy this web application but problem is I have to incorporate this web application other web application that is my site will run thrugh other application whenever user select to go my site. now i published my whole project and placed the all dll inside root folder (that is i placed my aspx pages inside folder called dailycallreport and all respective dll to bin folder ) now issue is the classes i have wriiten generates app_code dll and it conflict with existing app_code dll. i placed bin inside dailycallreport folder but i is not recongnizing . client is not giving all classes they used so it not possible to overwrite the same app_code i would like to know how can i placed my class file dll so that other setting does not affect .. please suggest something. Thank you.

regards imran khan

Hi all, i am using sql server 2005. let me explain the scenario. i have report where i bring perticular employee totalcall and workeddays then in third field i wrote an expresion to evaluate avg call that is totalday/workeddays and all the three field i displayed in table now requirment is in footer i should get avg of avgcall calculated please suggest some idea thank you

regards imran khan

Hi all I am using asp.net , C# ( VS2005) I fill dropdownlist using method defined in class on page load event it sucessfully fill the data in dropdownlist. as there is customer requirment to show different class of people in different color as well as tooltip of data. i succesffully managed to fill this with below shown code . but issue is when i fires other controls postback event. this dropdownlist loses its color as well as tooltip . Please suggest how to maintain the style of dropdownlist. code to fill dropdownlist public void Fillemp(DropDownList ctrl, string procedurename, string conn, SqlCommand cmd) { try { if (con == null) { this.openconnection(conn); this.con.Open(); // con.Open(); } if (con.State == ConnectionState.Closed) { this.openconnection(conn); con.Open(); } DataTable dtcompany = new DataTable(); ctrl.Items.Clear(); dtcompany = GetDataTable(procedurename, cmd); ctrl.Items.Add(new ListItem("Select One", "0")); ctrl.Items.Add(new ListItem("All" , "1")); ctrl.Items.Add(new ListItem("Self" , "2")); foreach (DataRow row in dtcompany.Rows) { ListItem item = new ListItem(row["emPname"].ToString(), row["er_emp_code"].ToString()); item.Attributes.Add("title", row["empname"].ToString()); int lvl = int.Parse(row["er_user_lvl"].ToString()); switch(lvl) { case 8: item.Attributes.Add("style", "color:green"); break; case 7: item.Attributes.Add("style", "color:blue"); break; case 6: item.Attributes.Add("style", "color:red"); break; case 5: item.Attributes.Add("style", "color:purple"); break; default : item.Attributes.Add("style", "color:BLACK"); break; } ctrl.Items.Add(item); } } catch (Exception ex) { throw ex; } finally { if (con != null) { con.Close(); } } } page load event where i fill the dropdownlist if (!(IsPostBack)) { SqlCommand cmd = new SqlCommand(); cmd.Parameters.AddWithValue("empcode", Membership.GetUser().UserName); Doctor dr = new Doctor(); dr.Fillemp(Ddlzse, "SpGetPredecessor", "bbraunemisconnectstring", cmd); dr.FillctrlList1(Ddlsubdiv, "SPGETSUBDIV_GIVENEMP", "bbraunemisconnectstring", cmd, 0); } and dropdownlist is defined as <TD id ="tdddlzsm" style="BORDER-BOTTOM: gray 1px solid; TEXT-ALIGN: left ; width: 490px;" align ="center" > <asp:DropDownList id="Ddlzse" runat="server" Width="480px" Font-Bold="False" Font-Size="9pt" Font-Names="Arial" AppendDataBoundItems="True" ></asp:DropDownList> </TD> <

Hi All, I am using C# , asp.net2.0 , Ajax1.0 i am filling dropdownlist using cascading ajax extender. i taken help of ajax site and build a code to fill the control. my question is how do i get parent selected item value. my web service code to fill target value public CascadingDropDownNameValue[] GetProd(string knownCategoryValues , string category) { StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues); //string subgrp ; //int sub1; //if (!kv.ContainsKey("Prod") || !Int32.TryParse(kv["Prod"], out sub1)) //// if (!kv.ContainsKey("Prod")) //{ // return null; //} DsprdTableAdapters.SPGETPRODUCT_GIVENSUBTableAdapter prd = new DsprdTableAdapters.SPGETPRODUCT_GIVENSUBTableAdapter(); Dsprd.SPGETPRODUCT_GIVENSUBDataTable prdgrp = prd.GetProd(kv["Prod"]); List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); foreach (DataRow dr in prdgrp) { values.Add(new CascadingDropDownNameValue((string)dr["PM_PRD_NAME"], dr["PM_PRD_CODE"].ToString())); } return values.ToArray(); } This is giving me no out put as kv["Prod"] is showing null value. Cascading code in aspx is <ajaxToolkit:CascadingDropDown ID="cddPROD" runat="server" TargetControlID="Ddlproduct" ParentControlID="Ddlsubdiv" Category="Prod" PromptText="Choose a Product...." LoadingText="Please wait ..." ServicePath="../Prod.asmx" ServiceMethod="GetProd" /> Please Suggest regards imran khan

Hi All, I am using C# asp.net 2.0 and ajax1.0. I am trying to fill dropdownlist using ajax cascading toolkit but I am not able to populate the dropdownlist. My question is how do I take input value of parent dropdownlist in web service the fill the data that is in my senario I have subprod parent (fill on page load) and then Prod fill on subprod selection. The web service method I used is public CascadingDropDownNameValue[] GetProd(string knownCategoryValues, string category) { StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues); string subgrp = null ; // if (!kv.ContainsKey("PGM_GRP_CODE") || !Int32.TryParse(kv["PGM_GRP_CODE"], out subgrp)) if (!kv.ContainsKey("PGM_GRP_CODE") ) { return null; } DsprdTableAdapters.SPGETPRODUCT_GIVENSUBTableAdapter prd = new DsprdTableAdapters.SPGETPRODUCT_GIVENSUBTableAdapter(); Dsprd.SPGETPRODUCT_GIVENSUBDataTable prdgrp = prd.GetProd(subgrp); List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); foreach (DataRow dr in prdgrp) { values.Add(new CascadingDropDownNameValue((string)dr["PM_PRD_NAME"], dr["PM_PRD_CODE"].ToString())); } return values.ToArray(); } and cascading toolkit I definded as <ajaxToolkit:CascadingDropDown ID="cddPROD" runat="server" TargetControlID="Ddlproduct" ParentControlID="Ddlsubdiv" Category="Prod" PromptText="Choose a Product...." LoadingText="Please wait ..." ServicePath="../Prod.asmx" ServiceMethod="GetProd" /> Pleases Suggest

regards imran khan

i am using asp.net 2.0 ,C# Acually i am facing issue of speed as database server is remote . I want to know how to fill data asynchronously to one dropdownlist based on other dropdownlist. Is this approach improve the perfomance please suggest Thank you.

regards imran khan

Hi all, I am using C# , asp.net2.0 , ajax1.0 and sql server 2005. I am facing problem of slowness of web http://www.bbraunconnect.co.in/HRMS/DailyCallReport/DCR.aspx please click on the link ,this link will ask username and password . username is em194 and password is TEST123@ let me explain the problem. you will find subdivision .On its selection product dropdownlist is filled but it is consuming some time on main server(where database and code are not on the same machine ) whereas in test server (where database and code are on the same machine ) it does not consume any time I would like to know how to I speed up the process. let me explain how I am filling the control I made one class and defined method as shown below (earlier I tried by making datatable and filling in table but it was taking higher timespan then this ) public void FillctrlList2(DropDownList ctrl, string procedurename,string fieldtext ,string fieldvalue , string conn, SqlCommand cmd, int i) { try { if (con == null) { this.openconnection(conn); this.con.Open(); // con.Open(); } if (con.State == ConnectionState.Closed) { this.openconnection(conn); con.Open(); } ctrl.Items.Clear(); ctrl.Items.Add(new ListItem("Select One", "0")); cmd.Connection = con; cmd.CommandText = procedurename; cmd.CommandType = CommandType.StoredProcedure; rdr = cmd.ExecuteReader(); ctrl.DataSource = rdr; ctrl.DataTextField = fieldtext; ctrl.DataValueField = fieldvalue; ctrl.DataBind(); } catch (Exception ex) { throw ex; } finally { if (rdr != null) { rdr.Close(); } if (con != null) { con.Close(); } } } I have web config connection as <add name="bbraunemisconnectstring" connectionString="Data Source=bindh2,1433;Initial Catalog=bbraun_emis;User ID=sa;Password=LITTLEANGEL" providerName="System.Data.SqlClient"/> data is also not much in the table it 500 to 600 and also i am using ajax updatepanel too. The procedure I am using to fetch the data is ALTER PROCEDURE [dbo].[SPGETPRODUCT_G

Hi all, i am using asp.net , c# in vs2005. i am facing problem of slowness of page(becuase heavy event called for data that is i have four to five dropdownlist control and each dropdownlist is filled based on its precedor value and every seletedindex_changed event call datatbase and fetch the data). what i am now trying is to fetch all the in datatable on page load and from these datatable i would like to fetch data depend on the condition. i am not getting good link to perform the same . please guide me also suggest what i am approaching would inhance speed of flow or not. Thank you

regards imran khan

Hi all, I am using asp.net2.0 , C#. I would like to know which is the best approach(faster ) to fill dopdownlist 1. making stored procedure and filling data to dropdownlist using datareader 2. passing query and filling data to dropdownlist using datareader As I am facing problem of slowness of filling data . if you find any better approach or faster approach please guide me. database is not much heavy Method I used to fill dropdownlist is public void FillctrlList2(DropDownList ctrl, string procedurename,string fieldtext ,string fieldvalue , string conn, SqlCommand cmd, int i) { try { if (con == null) { this.openconnection(conn); this.con.Open(); // con.Open(); } if (con.State == ConnectionState.Closed) { this.openconnection(conn); con.Open(); } ctrl.Items.Clear(); ctrl.Items.Add(new ListItem("Select One", "0" )); cmd.Connection = con; cmd.CommandText = procedurename; cmd.CommandType = CommandType.StoredProcedure; rdr = cmd.ExecuteReader(); ctrl.DataSource = rdr; ctrl.DataTextField = fieldtext; ctrl.DataValueField = fieldvalue; ctrl.DataBind(); rdr.Close(); } catch (Exception ex) { throw ex; } }

regards imran khan

Hi all, I am using ajax 1.0 ,asp.net2.0 , C#. I used nested updatepanel so that only part of page get refereshed but my problem is whole page is getting referesh or flicker(whole page goes off that is no control is visible then it comes back with control and data ) on every event(like seletedindexchaged event) I here encloesed the code please help <%@ Page Language="C#" MasterPageFile="~/DailyCallReport/Master2.master" AutoEventWireup="true" CodeFile="Dcr.aspx.cs" Inherits="DailyCallReport_Dcr" Title="Daily Call Report" %> <asp:Content ID="Content1" ContentPlaceHolderID="mainContent" Runat="Server"> <h2 style ="text-align :center ;" ><asp:Label ID="headername" Font-Size ="12pt" runat="server" Text="D a i l y C a l l R e p o r t"></asp:Label> </h2> <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager> <asp:UpdatePanel id="UpdatePanelmain" ChildrenAsTriggers ="true" UpdateMode ="Conditional" runat="server"> <ContentTemplate> <asp:Panel ID="MAINPANEL" runat="server" Width= "815 px" BackColor="#FFFFFF" HorizontalAlign = "Left"> <table border = 0 > <tbody > <tr style ="background-color:#85C8D0 " align ="left" > <TD style="WIDTH: 100px; BORDER-BOTTOM: gray 1px solid; height: 28px;" align=right > <asp:Label id="Label3" runat="server" Text="Day Type" Font-Size="9pt" SkinID="LABEL_Navy_Simple"></asp:Label> </TD> <TD style="BORDER-BOTTOM: gray 1px solid; TEXT-ALIGN: left; width: 180px; height: 28px;"> <asp:DropDownList id="Ddldatetype" runat="server" Width="165px" Font-Bold="False" Font-Size="9pt" Font-Names="Arial" SkinID="DROPDOWNLIST_LONG" > </asp:DropDownList> </TD> <td style ="width:280px;" > </td> <TD style="WIDTH: 58px; BORDER-BOTTOM: gray 1px solid; height: 28px;" align=right> <asp:Label id="Label2" runat="server" Text="Date" Font-Size="9pt" Font-Names ="Arial" SkinID="LABEL_Navy_Simple"></asp:Label> </TD> <TD style="BORDER-BOTTOM: gray 1px solid; TEXT-ALIGN: left; width: 180px; height: 28px;"> <asp:TextBox ID="Txtreportingdt" runat="server" SkinID ="Textbox"></asp:TextBox> </TD> </tr> </tbody> </table> <table border = 1 > <tbody > <TR style ="background-color :#B1CCDF" > <asp:UpdatePanel id="UpdatePanel1" ChildrenAsTriggers ="False" UpdateMode ="Conditional" runat="server"> <ContentTemplate>

Hi, i am using C# asp.net2.0 i want to know two things 1. is it possible to change the color of editing row of gridview that is when i click edit button(template) that row's color change 2. Is it possible to have some diffenrnt color of last inserted row as i have interface in above frame and i select the record and add to gridview, Please help Thank you

regards imran khan

hi all, I am using sql server 2005. I making one web form where data from one table(temporary table) is moved to three table two is header and one is detail. i would like to know is making a package is better option or directing writing procedure to move data in respective table is good. Perfomancewise which is fast.or if any other better option is there plaese guide me. If making ssis packge is better please give me useful. please help. Thank you

regards imran khan

i am using asp.net 2.0 C# . due to data flow i manage to get row wise record column wise but that record show one null row . i am fetching that record in datatable object and assigning to gridview i want to know is it possible to remove datatable row where record is null then assign to gridview. please help

regards imran khan

Hi All, i am using sql server 2005. in a table a record is entered as product1 , status1 ,product2 , status2 , product3 , status3 in a row now i have to display it as product1 status1 product2 status2 product3 status3 how can i do it . please help.

regards imran khan

Hi All, i am using ASp.net2.0 , C# . A dropdownlist control which is filled by dataset i show the name against the respective code. Now name is quite large so i would like to show it in tooltip. i search in google but did not get appropiate solution. Please help Thank you

regards imran khan

i did not get what do you mean by default setting is it viewstate please reply.

regards imran khan