ASP.NET Discussion Boards

Re: Help with a Logic

Christian Graus12-Mar-09 22:31

Christian Graus

12-Mar-09 22:31

What we're not seeing is the loop that iterates over i and j.

Christian Graus

Driven to the arms of OSX by Vista.

Re: Help with a Logic

Vimalsoft(Pty) Ltd12-Mar-09 22:36

Vimalsoft(Pty) Ltd

12-Mar-09 22:36

The Method with loops look like this

protected void setupGrid()
   {
       if (((int)Session["numCycles"]) > 0)
       {
           UltraWebGrid cycleGrid = ultraGridCycles;
           int numCols = 0; //Number of Colums
           int numRows = 0; //Number of Rows

           //If the Sessions are Greater than 13 , Make
           //the Columns to be 13 else keep the supplied value for the Columns
           if (((int)Session["numCycles"]) >= 13)
           {
               numCols = 13;
           }
           else
           {  //Keep the Columns as they are
               numCols = ((int)Session["numCycles"]);
           }


           /*This one is used for the Row not the Column like the above one*/
           //Divide the Session variable Value by 13, the Returned
           //number is Checked if its 0 if that is true the First Statement get executed
           //else the second -->
           //I suppose this was meant to check the zero, because you cant divide by zero
           if ((((int)Session["numCycles"]) % 13) == 0)
           {
               //Assign the value of a Session Varable that is Devided by 13
               numRows = (int)(((int)Session["numCycles"]) / 13);
           }
           else
           {
               //Assign the value of a session variable and Divide it by 13
               //add a on top of it.
               numRows = (int)((((int)Session["numCycles"]) / 13) + 1);
           }

           //Change the Height of the Grid
           cycleGrid.Height = Unit.Pixel(20 * numRows + 6);

           /*'''''''''''''''''''''''''''''''''''''''''''
            * For the Column
            * ''''''''''''''''''''''''''''''''''''''''''*/

           /*This is a For Loop. We First declare
            * the integer and initialize it to 0 and the second one is
            * the expression, we say, as long as the number of [i] variable are less than the number of columns
            * then increase the value of i
            */
           for (int i = 0; i < numCols; i++)
           {   //Create an object of a class Ultracolumn that represents the Column
               UltraGridColumn col = new UltraGridColumn(true);
               //adjust the Width of the Column
               col.Width = Unit.Pixel(10);
               //Its a Unique String in a Gridview
               col.Key = i.ToString();
               //Now we are adding Columns in the Gridview by passing the Column object.
               cycleGrid.Columns.Add(col);
           }

           /*'''''''''''''''''''''''''''''''''''''''''''
            * For the Rows
            * ''''''''''''''''''''''''''''''''''''''''''*/
           /*Here we are using the For loop,
            * First declare and initializing the variable i
            * and while the variable i is less than the number of rows then increase
            * the value of i */
           for (int i = 1; i <= numRows; i++)
           {
               //Create an object of a Class UltragridRow and initialize it
               UltraGridRow row = new UltraGridRow(true);
               //Assign a unique key of a row
               row.Key = i.ToString();

               /*'''''''''''''''''''''''''''''''''''''''''''
               * For the Cell
               * ''''''''''''''''''''''''''''''''''''''''''*/
               /*Declare a Variable of integer "j" and assign it a value of "1"
                * and as long as the value of J is less that and equal to number of Columns
                * then increament the value of a variable J
                */
               for (int j = 1; j <= numCols; j++)
               {
                   //Create an object of a class UltraGridCell and initialize it.
                   UltraGridCell cell = new UltraGridCell(true);
                   //adjust the gridproperties
                   cell.Style.HorizontalAlign = HorizontalAlign.Center;
                   //adjust the gridproperties
                   cell.Style.Padding.Left = 0;
                   //adjust the gridproperties
                   cell.Style.Padding.Top = 0;
                   //adjust the gridproperties
                   cell.Style.Padding.Bottom = 0;
                   //adjust the gridproperties
                   cell.Style.Padding.Right = 0;
                   //adjust the gridproperties

                   //Adjust the Cell Value to Integer 13 mutiply by number of rows -1 ajd pluss number of Columns
                   cell.Value = (int)((13 * (i - 1)) + j);

                   /*If 13 multiply by number of rows -1 one plus number of Columns
                    * is greateer than the session variable then set the value of that cell to null */
                   if (((13 * (i - 1)) + j) > ((int)Session["numCycles"]))
                   {
                       cell.Value = null;
                       cell.Style.BackColor = System.Drawing.Color.Gray;
                       cell.AllowEditing = AllowEditing.No;
                   }

                   //add the cells to the Grid
                   row.Cells.Add(cell);



               }
               cycleGrid.Rows.Add(row);

           }
           /*After the Grid has been Populated, let us remove some of the cells
                   * using the Following code
                   */
           ArrayList array = (ArrayList)Disable_Grid();



           //Count the Number of rows in a gridview and initialize the integer with those values
           int u = cycleGrid.Rows.Count;

           /*Another For Loop,First we declare an Interger variable "i" and
       * initialize it with "0" and as long as the variable i is less than the number of
       * rows in a gridview increament the variable i
       */
           for (int i = 0; i < cycleGrid.Rows.Count; i++)
           {
               /*Creating an object of a Class GridViewRow "g" and
            * passing the Value a Variable i that has
            * been checked as less than the Value of the Rows
            */

               UltraGridRow g = cycleGrid.Rows[i];
               /*Another For Loop. Initialization of a newly declared variable
            *  j to "0" and as long as the number of Cells are less than the variable J then increase the Value of a
            * variable J
            */
               for (int j = 0; j < g.Cells.Count; j++)
               {
                   /*for Loop in a For loop. Declare an Integer "p" and Assign
                    * 0 to it and as long as the number of p variable  are
                    * less than the number of indexes in the array list variable
                     if its true the value of P is incremented by 1*/
                   for (int p = 0; p < array.Count; p++)
                   {
                       /*A String is Declared and is Assigned a value of
                        * of a cell indexed by the variable J that is not supposed greater than
                        * the number of cells in a grid
                        */
                       string txt = g.Cells[j].Text;
                       /*if then value in the text is equal to the value of the array
                        * make the cell invisible*/

                       //int m = array.Count;

                           if (txt != array[p].ToString())
                           {
                               /*The I is representing the Rows and the J is representing the Cells
                                */
                               //These are the Cells that are Supposed to be disabled
                               cycleGrid.Rows[i].Cells[j].Style.BorderColor = System.Drawing.Color.DarkGray;
                               cycleGrid.Rows[i].Cells[j].Style.ForeColor = System.Drawing.Color.DarkGray;
                               cycleGrid.Rows[i].Cells[j].Style.Cursor = Infragistics.WebUI.Shared.Cursors.Wait;

                           }
                           else
                           {
                               cycleGrid.Rows[i].Cells[j].Style.ForeColor = System.Drawing.Color.Black;
                               cycleGrid.Rows[i].Cells[j].Style.Cursor = Infragistics.WebUI.Shared.Cursors.Auto;
                               cycleGrid.Rows[i].Cells[j].Style.Font.Bold = true;

                           }

                       }
                   }

           }
       }
   }

Thanks

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za

Re: Help with a Logic

Christian Graus12-Mar-09 22:43

Christian Graus

12-Mar-09 22:43

Lot of code here. What happens when you step through it ?

Christian Graus

Driven to the arms of OSX by Vista.

Re: Help with a Logic

Vimalsoft(Pty) Ltd15-Mar-09 20:50

Vimalsoft(Pty) Ltd

15-Mar-09 20:50

Good Morning Chris

Thanks for your help, i have added an extra if statement like this and it worked

protected void setupGrid()
    {
        if (((int)Session["numCycles"]) > 0)
        {
            UltraWebGrid cycleGrid = ultraGridCycles;
            int numCols = 0; //Number of Colums             
            int numRows = 0; //Number of Rows

            //If the Sessions are Greater than 13 , Make 
            //the Columns to be 13 else keep the supplied value for the Columns
            if (((int)Session["numCycles"]) >= 13)
            {
                numCols = 13;
            }
            else
            {  //Keep the Columns as they are 
                numCols = ((int)Session["numCycles"]);
            }


            /*This one is used for the Row not the Column like the above one*/
            //Divide the Session variable Value by 13, the Returned 
            //number is Checked if its 0 if that is true the First Statement get executed 
            //else the second -->
            //I suppose this was meant to check the zero, because you cant divide by zero
            if ((((int)Session["numCycles"]) % 13) == 0)
            {
                //Assign the value of a Session Varable that is Devided by 13
                numRows = (int)(((int)Session["numCycles"]) / 13);
            }
            else
            {
                //Assign the value of a session variable and Divide it by 13 
                //add a on top of it. 
                numRows = (int)((((int)Session["numCycles"]) / 13) + 1);
            }

            //Change the Height of the Grid
            cycleGrid.Height = Unit.Pixel(20 * numRows + 6);

            /*'''''''''''''''''''''''''''''''''''''''''''
             * For the Column
             * ''''''''''''''''''''''''''''''''''''''''''*/

            /*This is a For Loop. We First declare 
             * the integer and initialize it to 0 and the second one is
             * the expression, we say, as long as the number of [i] variable are less than the number of columns
             * then increase the value of i
             */
            for (int i = 0; i < numCols; i++)
            {   //Create an object of a class Ultracolumn that represents the Column
                UltraGridColumn col = new UltraGridColumn(true);
                //adjust the Width of the Column
                col.Width = Unit.Pixel(10);
                //Its a Unique String in a Gridview
                col.Key = i.ToString();
                //Now we are adding Columns in the Gridview by passing the Column object.
                cycleGrid.Columns.Add(col);
            }

            /*'''''''''''''''''''''''''''''''''''''''''''
             * For the Rows
             * ''''''''''''''''''''''''''''''''''''''''''*/
            /*Here we are using the For loop,
             * First declare and initializing the variable i 
             * and while the variable i is less than the number of rows then increase 
             * the value of i */
            for (int i = 1; i <= numRows; i++)
            {
                //Create an object of a Class UltragridRow and initialize it
                UltraGridRow row = new UltraGridRow(true);
                //Assign a unique key of a row
                row.Key = i.ToString();

                /*'''''''''''''''''''''''''''''''''''''''''''
                * For the Cell
                * ''''''''''''''''''''''''''''''''''''''''''*/
                /*Declare a Variable of integer "j" and assign it a value of "1"
                 * and as long as the value of J is less that and equal to number of Columns
                 * then increament the value of a variable J
                 */
                for (int j = 1; j <= numCols; j++)
                {
                    //Create an object of a class UltraGridCell and initialize it.
                    UltraGridCell cell = new UltraGridCell(true);
                    //adjust the gridproperties
                    cell.Style.HorizontalAlign = HorizontalAlign.Center;
                    //adjust the gridproperties
                    cell.Style.Padding.Left = 0;
                    //adjust the gridproperties
                    cell.Style.Padding.Top = 0;
                    //adjust the gridproperties
                    cell.Style.Padding.Bottom = 0;
                    //adjust the gridproperties
                    cell.Style.Padding.Right = 0;
                    //adjust the gridproperties

                    //Adjust the Cell Value to Integer 13 mutiply by number of rows -1 ajd pluss number of Columns
                    cell.Value = (int)((13 * (i - 1)) + j);

                    /*If 13 multiply by number of rows -1 one plus number of Columns
                     * is greateer than the session variable then set the value of that cell to null */
                    if (((13 * (i - 1)) + j) > ((int)Session["numCycles"]))
                    {
                        cell.Value = null;
                        cell.Style.BackColor = System.Drawing.Color.Gray;
                        cell.AllowEditing = AllowEditing.No;
                    }

                    //add the cells to the Grid                                       
                    row.Cells.Add(cell);



                }
                cycleGrid.Rows.Add(row);

            }
            /*After the Grid has been Populated, let us remove some of the cells 
                    * using the Following code
                    */
            ArrayList array = (ArrayList)Disable_Grid();



            //Count the Number of rows in a gridview and initialize the integer with those values
            int u = cycleGrid.Rows.Count;

            /*Another For Loop,First we declare an Interger variable "i" and 
        * initialize it with "0" and as long as the variable i is less than the number of
        * rows in a gridview increament the variable i
        */
            for (int i = 0; i < cycleGrid.Rows.Count; i++)
            {
                /*Creating an object of a Class GridViewRow "g" and 
             * passing the Value a Variable i that has 
             * been checked as less than the Value of the Rows 
             */

                UltraGridRow g = cycleGrid.Rows[i];
                /*Another For Loop. Initialization of a newly declared variable 
             *  j to "0" and as long as the number of Cells are less than the variable J then increase the Value of a 
             * variable J
             */
                for (int j = 0; j < g.Cells.Count; j++)
                {
                    /*for Loop in a For loop. Declare an Integer "p" and Assign 
                     * 0 to it and as long as the number of p variable  are 
                     * less than the number of indexes in the array list variable
                      if its true the value of P is incremented by 1*/
                    for (int p = 0; p < array.Count; p++)
                    {
                        /*A String is Declared and is Assigned a value of 
                         * of a cell indexed by the variable J that is not supposed greater than
                         * the number of cells in a grid
                         */
                        string txt = g.Cells[j].Text;
                        /*if then value in the text is equal to the value of the array 
                         * make the cell invisible*/
                          if (txt != array[p].ToString())
                            {
                                /*The I is representing the Rows and the J is representing the Cells
                                 */
                                //These are the Cells that are Supposed to be disabled
                                
                                cycleGrid.Rows[i].Cells[j].Style.ForeColor = System.Drawing.Color.Gray;
                                
                            }
                            else
                            {
                                cycleGrid.Rows[i].Cells[j].Style.Cursor = Infragistics.WebUI.Shared.Cursors.Auto;
                             
                                cycleGrid.Rows[i].Cells[j].Style.ForeColor = System.Drawing.Color.Black;
                                
                                cycleGrid.Rows[i].Cells[j].Style.Font.Bold = true;

                             }
                        
                        }
                        if (cycleGrid.Rows[i].Cells[j].Style.Font.Bold == true)
                        {
                            cycleGrid.Rows[i].Cells[j].Style.ForeColor = System.Drawing.Color.Black;
                        }
                        else
                        {
                             cycleGrid.Rows[i].Cells[j].Style.ForeColor = System.Drawing.Color.Gray;
                             cycleGrid.Rows[i].Cells[j].Style.BackColor = System.Drawing.Color.DarkGray;
                             
                            cycleGrid.Rows[i].Cells[j].Style.Cursor = Infragistics.WebUI.Shared.Cursors.Wait;

                        }

                    }
                
            }
        }

        
    }

And its working thank you

Web Service 400 Error

Expert Coming12-Mar-09 20:30

Expert Coming

12-Mar-09 20:30

I have a Web Service that is receiving a file, and putting into a SQL Database. For some reason this method gets an error, while all the others work. Through searching the web all the results say I need to change my IIS setup, which I did not do because it is already setup the way they want.

So, any ideas why I can't call this method:
public void AddSong(string Name, string Artists, string Album, string Genre, int YearPublished, string Path, DateTime DateAdded, byte[] FileData, string MD5)

Without this error:
The request failed with HTTP status 400: Bad Request.

I can post any code you think is relavant, but with my searches it seems like it isn't a code issue. Am I doing something not allowed?

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

Re: Web Service 400 Error

Abhijit Jana12-Mar-09 20:43

Abhijit Jana

12-Mar-09 20:43

It can be cause of Access Permission. Seem, the file need to write in your system so its required permission. Did you create Application Pool on IIS. Create New Application Pool, Change the Identity of Application pool to local system, then assign the application pool to that Virtual Directory then Try test. Hope this will resolve your issue.

cheers,
Abhijit
CodeProject MVP

Re: Web Service 400 Error

Expert Coming13-Mar-09 14:15

Expert Coming

13-Mar-09 14:15

I am not writing it to the file system, straight to SQL...

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

Re: Web Service 400 Error

Expert Coming13-Mar-09 14:31

Expert Coming

13-Mar-09 14:31

Yeah, tried that just in case, didn't work.

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

Datagrid problem

rakeshs31212-Mar-09 19:23

rakeshs312

12-Mar-09 19:23

Hi,

I have a datagrid and i given that inside a

.It is now scrollable.But i want the headers static.Where should i give the header.
Code is below

<div style="BORDER-RIGHT: navy 2px solid; PADDING-RIGHT: 1px; BORDER-TOP:
																				navy 2px solid; PADDING-LEFT: 1px; LEFT: 0px; PADDING-BOTTOM: 1px; OVERFLOW:
																				auto; BORDER-LEFT: navy 2px solid; WIDTH: 850px; PADDING-TOP: 1px;
																				BORDER-BOTTOM: navy 2px solid; POSITION: relative; TOP: 10px; HEIGHT: 230px">

																				<ASP:DATAGRID id="DGInbox" runat="server" Width="100%" BackColor="White" BorderColor="#DEDFDE"
																					Font-Name="arial" Font-Size="Small" HeaderStyle-BackColor="#ffcc99" DataKeyField="UserName"
																					OnEditCommand="DGInbox_Edit" OnCancelCommand="DGInbox_Cancel" OnUpdateCommand="DGInbox_Update"
																					AutoGenerateColumns="False" AllowPaging="True" AllowCustomPaging="False" PageSize="15" GridLines="Both"
																					PagerStyle-Mode="NumericPages" PagerStyle-HorizontalAlign="Center" PagerStyle-NextPageText="Next"
																					PagerStyle-PrevPageText="Prev" OnPageIndexChanged="DGInbox_Page" Font-Names="verdana" OnItemDataBound="DGInbox_OnItemDataBound"
																					AllowSorting="True" OnSortCommand="DGInbox_Sort" BorderWidth="1px" BorderStyle="none" EnableViewState="True"
																					CellPadding="2" CellSpacing="0">
																					<FooterStyle BackColor="#CCCC99"></FooterStyle>
																					<SelectedItemStyle Font-Bold="True" ForeColor="White" BackColor="#CE5D5A"></SelectedItemStyle>
																					<AlternatingItemStyle BackColor="White"></AlternatingItemStyle>
																					<ItemStyle BorderColor="White" BackColor="#F0F8FF"></ItemStyle>
																					<HeaderStyle Font-Bold="True" ForeColor="White" BackColor="#6699cc"></HeaderStyle>
																					<Columns>
																						<asp:TemplateColumn HeaderText="Result">
																							<ItemStyle Wrap="False"></ItemStyle>
																							<ItemTemplate>
																								<!--<asp:HyperLink id="testresult" Text='<%# DataBinder.Eval(Container.DataItem, "DB_CANDT_RESULT")%>' NavigateUrl='<%# "TestResult.aspx?id=" + HttpUtility.UrlEncode(DataBinder.Eval(Container.DataItem,"UserName").ToString()) + "&QStrTestId=" + HttpUtility.UrlEncode(DataBinder.Eval(Container.DataItem,"TestId").ToString()) + "&QStrResult=" + HttpUtility.UrlEncode(DataBinder.Eval(Container.DataItem,"DB_CANDT_RESULT").ToString()) + "&QStrCandidate=" + HttpUtility.UrlEncode(DataBinder.Eval(Container.DataItem,"CandidateName").ToString())%>' runat="server" Target="_blank" />-->
																								<a href="#" onclick="oEditorWindow = window.open('<%# "TestResult.aspx?id=" + HttpUtility.UrlEncode(DataBinder.Eval(Container.DataItem,"UserName").ToString()) + "&QStrTestId=" + HttpUtility.UrlEncode(DataBinder.Eval(Container.DataItem,"TestId").ToString()) + "&QStrResult=" + HttpUtility.UrlEncode(DataBinder.Eval(Container.DataItem,"DB_CANDT_RESULT").ToString()) + "&QStrCandidate=" + HttpUtility.UrlEncode(DataBinder.Eval(Container.DataItem,"CandidateName").ToString()) + "&QStrCandidateBatch=" + HttpUtility.UrlEncode(DataBinder.Eval(Container.DataItem,"BatchName").ToString())%>','a','scrollbars=1,resizable=1,width=800,height=400,left=100,top=150,screenX=0,screenY=100');" id="A1"><%# DataBinder.Eval(Container.DataItem, "DB_CANDT_RESULT")%></a>
																							</ItemTemplate>
																						</asp:TemplateColumn>
																						<asp:TemplateColumn HeaderText="Name" SortExpression="CandidateName">
																							<HeaderStyle Font-Bold="True" ></HeaderStyle>
																							<ItemStyle Wrap="False"></ItemStyle>
																							<ItemTemplate>
																								<a href="javascript:void(window.open('CandidatePersonalDetails.aspx?CID=<%# DataBinder.Eval(Container.DataItem, "DB_CANDT_ID")%>&Type=<%# DataBinder.Eval(Container.DataItem, "CandidateType")%>&regType=<%# DataBinder.Eval(Container.DataItem, "RegistrationType")%>',null,'width=700,height=250,left=150,right=150,top=180,resizable=yes,scrollbars=1'));"><%# DataBinder.Eval(Container.DataItem, "CandidateName")%></a>
																							</ItemTemplate>
																						</asp:TemplateColumn>
																						<asp:BoundColumn DataField="RegistrationDate" HeaderText="Reg Date" SortExpression="RegistrationDate" DataFormatString="{0:yyyy-MMM-dd}">
																							<HeaderStyle Font-Bold="True" Wrap="False"></HeaderStyle>
																							<ItemStyle Wrap="False"></ItemStyle>
																						</asp:BoundColumn>
																						<asp:BoundColumn DataField="City" HeaderText="Location" >
																							<HeaderStyle Font-Bold="True" Wrap="False"></HeaderStyle>
																							<ItemStyle Wrap="False"></ItemStyle>
																						</asp:BoundColumn>
																						<asp:BoundColumn DataField="CandidateType" HeaderText="Type">
																							<HeaderStyle Font-Bold="True" Wrap="False"></HeaderStyle>
																							<ItemStyle Wrap="False"></ItemStyle>
																						</asp:BoundColumn>
																						<asp:BoundColumn DataField="DB_CANDT_SCREENINGSTATUS" HeaderText="OnlineScreening">
																							<HeaderStyle Font-Bold="True" Wrap="False"></HeaderStyle>
																							<ItemStyle Wrap="False"></ItemStyle>
																						</asp:BoundColumn>
																						<asp:BoundColumn DataField="Email" HeaderText="e-Mail" SortExpression="Email">
																							<HeaderStyle Font-Bold="True" Wrap="False"></HeaderStyle>
																							<ItemStyle Wrap="False"></ItemStyle>
																						</asp:BoundColumn>
																						<asp:BoundColumn DataField="Experience" HeaderText="Exp">
																							<HeaderStyle Font-Bold="True" Wrap="False"></HeaderStyle>
																							<ItemStyle Wrap="False"></ItemStyle>
																						</asp:BoundColumn>
																						<asp:BoundColumn DataField="CurrOrg" HeaderText="CurrOrg">
																							<HeaderStyle Font-Bold="True" Wrap="False"></HeaderStyle>
																							<ItemStyle Wrap="False"></ItemStyle>
																						</asp:BoundColumn>
																						<asp:BoundColumn DataField="AOA" HeaderText="AOA">
																							<HeaderStyle Font-Bold="True" Wrap="False"></HeaderStyle>
																							<ItemStyle Wrap="False"></ItemStyle>
																						</asp:BoundColumn>
																						<asp:BoundColumn DataField="ACT" HeaderText="ACT">
																							<HeaderStyle Font-Bold="True" Wrap="False"></HeaderStyle>
																							<ItemStyle Wrap="False"></ItemStyle>
																						</asp:BoundColumn>
																						<asp:BoundColumn DataField="PhoneNumber" HeaderText="Phone">
																							<HeaderStyle Font-Bold="True" Wrap="False"></HeaderStyle>
																							<ItemStyle Wrap="False"></ItemStyle>
																						</asp:BoundColumn>
																						<asp:BoundColumn DataField="MobileNumber" HeaderText="Mobile">
																							<HeaderStyle Font-Bold="True" Wrap="False"></HeaderStyle>
																							<ItemStyle Wrap="False"></ItemStyle>
																						</asp:BoundColumn>
																						<asp:BoundColumn DataField="DB_CANDT_ADRS" HeaderText="Address">
																							<HeaderStyle Font-Bold="True" Wrap="False"></HeaderStyle>
																							<ItemStyle Wrap="False"></ItemStyle>
																						</asp:BoundColumn>
																						<asp:BoundColumn DataField="DB_CANDT_TSTATUS" HeaderText="Status">
																							<HeaderStyle Font-Bold="True" Wrap="False"></HeaderStyle>
																							<ItemStyle Wrap="False"></ItemStyle>
																						</asp:BoundColumn>
																						<asp:BoundColumn DataField="DB_CANDT_TS_TIME" HeaderText="Start Time">
																							<HeaderStyle Font-Bold="True" Wrap="False"></HeaderStyle>
																							<ItemStyle Wrap="False"></ItemStyle>
																						</asp:BoundColumn>
																						<asp:BoundColumn DataField="DB_CANDT_TE_TIME" HeaderText="End Time">
																							<HeaderStyle Font-Bold="True" Wrap="False"></HeaderStyle>
																							<ItemStyle Wrap="False"></ItemStyle>
																						</asp:BoundColumn>
																						<asp:BoundColumn DataField="DB_CANDT_TTAKEN" HeaderText="Time Taken">
																							<HeaderStyle Font-Bold="True" Wrap="False"></HeaderStyle>
																							<ItemStyle Wrap="False"></ItemStyle>
																						</asp:BoundColumn>
																						<asp:TemplateColumn HeaderText="Re-Schedule">
																							<HeaderStyle Font-Bold="True" Wrap="False"></HeaderStyle>
																							<ItemStyle Wrap="False"></ItemStyle>
																							<ItemTemplate>
																								<a href="Schedule.aspx?id=<%# DataBinder.Eval(Container.DataItem, "DB_CANDTEST_ID")%>&QStringCandtName=<%# DataBinder.Eval(Container.DataItem, "CandidateName")%>&type=<%# DataBinder.Eval(Container.DataItem, "RegistrationType")%>&email=<%# DataBinder.Eval(Container.DataItem, "Email")%>&BNAME=<%# DataBinder.Eval(Container.DataItem, "BatchName")%>&Qlocation=<%=m_LocationSelected%>&Uid=<%# DataBinder.Eval(Container.DataItem, "UserName")%>&pwd=<%# DataBinder.Eval(Container.DataItem, "Password")%>" id="lnkreschedule">Re-Schedule</a>
																							</ItemTemplate>
																						</asp:TemplateColumn>
																						<asp:TemplateColumn HeaderText="Comments">
																							<HeaderStyle ></HeaderStyle>
																							<ItemTemplate>
																								<a href="javascript:void(window.showModalDialog('HRComments.aspx?CID=<%# DataBinder.Eval(Container.DataItem, "DB_CANDT_ID")%>&QStringCandtName=<%# DataBinder.Eval(Container.DataItem, "CandidateName")%>',null,'dialogHeight:12em;dialogWidth:15em;status:no;scrolling:no'));">Comments</a>
																								<!--<a href="#"  onclick="ShowDetails();GetCandId('<%# DataBinder.Eval(Container.DataItem, "DB_CANDT_ID")%>','<%# DataBinder.Eval(Container.DataItem, "CandidateName")%>',popHRComments)">Comments</a>-->
																							</ItemTemplate>
																						</asp:TemplateColumn>
																						<asp:TemplateColumn>
																							<HeaderStyle BorderStyle="None" BackColor="White"></HeaderStyle>
																							<ItemTemplate>
																								<!--<a href="DeleteUser.aspx?id=" id="lnkDelete" onclick="return ConfirmDeletion();">Delete</a>-->
																								<a href="DeleteUser.aspx?id=<%# DataBinder.Eval(Container.DataItem, "DB_CANDT_ID")%>&STATUS=<%=m_StatusSelected%>&QStrLocation=<%=m_LocationSelected%>&QStrCurrPageIndex=<%=CurrPageIndex%>" id="lnkDelete" onclick="return ConfirmDeletion();">Delete</a>
																							</ItemTemplate>
																						</asp:TemplateColumn>
																					</Columns>
																					<PagerStyle NextPageText="Next" PrevPageText="Prev" HorizontalAlign="Right" ForeColor="Black"
																						BackColor="#6699cc" Mode="NumericPages"></PagerStyle>
																				</ASP:DATAGRID>
																				</div>

Re: Datagrid problem

Abhijit Jana12-Mar-09 19:33

Abhijit Jana

12-Mar-09 19:33

Please post properly.

cheers,
Abhijit
CodeProject MVP

Re: Datagrid problem

rakeshs31212-Mar-09 21:35

rakeshs312

12-Mar-09 21:35

Hai Abhijith,

I got it,Thanks for the response and sorry for the bad posting

Re: Datagrid problem

kumar_k50812-Mar-09 19:42

kumar_k508

12-Mar-09 19:42

Hi,

there was no code...what was the problem...?

S Kumar

Re: Datagrid problem

rakeshs31212-Mar-09 21:34

rakeshs312

12-Mar-09 21:34

Hai Kumar,

Thanks for the response,i got hte solution, sorry for the bad posting

can i use a class created by xsd.

prasadbuddhika12-Mar-09 19:20

prasadbuddhika

12-Mar-09 19:20

with out doing any serialization can i use the class created by the xsd in two projects to communicate between two.

Re: can i use a class created by xsd.

Christian Graus12-Mar-09 22:32

Christian Graus

12-Mar-09 22:32

Well, you can, but you need to define how. How do you expect to send a class instance from one project to another ? What sort of projects are they ?

Christian Graus

Driven to the arms of OSX by Vista.

Re: can i use a class created by xsd.

prasadbuddhika13-Mar-09 0:19

prasadbuddhika

13-Mar-09 0:19

what i intend to do is after creating the class from xsd and add them to both projects manually

Re: can i use a class created by xsd.

prasadbuddhika13-Mar-09 1:09

prasadbuddhika

13-Mar-09 1:09

can any one guide me on creating common classes for two applications.

Re: can i use a class created by xsd.

Ashfield13-Mar-09 2:25

Ashfield

13-Mar-09 2:25

Craete a dll with your class in and reference it in both projects.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

How to apply stylesheet class in EMail HTML format

Deepml12-Mar-09 19:17

Deepml

12-Mar-09 19:17

I want to apply stylesheet to the HTML format of mail.
I dont want to use code like :
string strBody="";
strBody += "<table><tr><td style='font-family: Verdana; font-size: 10pt;'>Hi,";
strBody += "</td></tr></table>";

Instead of that want to use :
string strBody="";
strBody += "<table><tr><td class='verdanaText'>Hi,";
strBody += "</td></tr></table>";

ObjMail.BodyFormat=MailFormat.Html;
ObjMail.Body=strBody;

Is it possible to use what I expected??

Re: How to apply stylesheet class in EMail HTML format

Abhijit Jana12-Mar-09 19:32

Abhijit Jana

12-Mar-09 19:32

Deepml wrote:
Instead of that want to use :
string strBody="";
strBody += "
Hi,";
strBody += "
";

ObjMail.BodyFormat=MailFormat.Html;
ObjMail.Body=strBody;

Did you check it? How it will get class='verdanaText' . You have to write the cssclass also with the BodyString.

cheers,
Abhijit
CodeProject MVP

Re: How to apply stylesheet class in EMail HTML format

Deepml12-Mar-09 19:45

Deepml

12-Mar-09 19:45

Abhijit Can you please tell me how to write that cssClass with Bodystring,I mean how to write

Re: How to apply stylesheet class in EMail HTML format

Abhijit Jana12-Mar-09 20:24

Abhijit Jana

12-Mar-09 20:24

<blockquote class="FQ"><div class="FQA">Deepml wrote:</div>mean how to write <link href="../includes/style.css" type="text/css" rel="stylesheet"> </link></blockquote>
Not, its not like that.
I want to mean, Create a mail content file like
<html>
<body>
<style>
.FontHeaderStyle
{
font-size: 12px;
font-family: verdana;
color:#C41230;
}

</style>

<table>
<tr>
<td class="FontHeaderStyle">
This is Sample HTML Mail
</td>
</tr>
</table>
</body>
</html>

Now, read the content as Text Reader and put it in mail body. Hope this is not clear to any. Any doubts ?

cheers,
Abhijit
CodeProject MVP

Re: How to apply stylesheet class in EMail HTML format

Deepml12-Mar-09 20:37

Deepml

12-Mar-09 20:37

Thanks Abhijit.. I got it Smile | :)

Re: How to apply stylesheet class in EMail HTML format

Abhijit Jana12-Mar-09 20:39

Abhijit Jana

12-Mar-09 20:39

Go ahead.

cheers,
Abhijit
CodeProject MVP

DataGrid to Excel

rakeshs31212-Mar-09 18:34

rakeshs312

12-Mar-09 18:34

Hi,

I have a DataGrid and i am using the code below to read it.It is reading all the records and working fine.But if i want to read only the recods that are currently displaying the grid(for grid paging is there and at a time it is displaying 10 records).After that i am inserting this to excel file.According to the paging i want the recods to insert in excel(ie 1-10 or 10-20 or 30-40) What should i change in the code? Thanksin advance

public void ExportDataToExcel(DataTable datatable, string[] Headers, string SourcePath, string DestinationPath)
	{
		int i, j;
		string strSourceTemplate = "";
		string strDestFileName = "";
		string strHeaders = "";
		string strRow = "";
      
		System.Data.OleDb.OleDbConnection objXlsCon = null;
		System.Data.OleDb.OleDbCommand objCmd;

		try
		{
			objXlsCon = new System.Data.OleDb.OleDbConnection();
//			if (Headers.Length != datatable.Columns.Count)
//			{
//				throw new Exception("Export Headers List and Table columns should be of same length");
//			}
			if (datatable.Rows.Count > 0)
			{
				strSourceTemplate = SourcePath;
				strDestFileName = DestinationPath;
				//if (File.Exists(strDestFileName))
				//{
				//    File.Delete(strDestFileName);
				//}
				System.IO.File.Copy(strSourceTemplate, strDestFileName);

				objXlsCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strDestFileName + ";Extended Properties=\"Excel 8.0;HDR=Yes;MAXSCANROWS=1;\";";
				objXlsCon.Open();
				objCmd = new System.Data.OleDb.OleDbCommand();
				objCmd.Connection = objXlsCon;

				//getting template headers
				for (i = 0; i < Headers.Length; i++)
				{
					strHeaders += Headers[i].ToString() + ",";
				}
				string s=datatable.Columns[0].ColumnName;
				int k=0;
				//getting values 
				foreach (DataRow drow in datatable.Rows)
				{
					for (j = 0; j < datatable.Columns.Count; j++)
					{
						
						//if(Headers.Length > k)
						//if(drow[j].ToString() != "" && drow[j].ToString().Length<255)
						if(Headers.Length > k)
						{
							if(datatable.Columns[j].ColumnName == Headers[k].ToString())
							{
								if(drow[j].ToString() != "" )//&& drow[j].ToString().Length<255)
								{
									strRow += drow[j].ToString() + "','";
									
								}
								else
								{
									//							if(datatable.Columns[j].DataType.FullName == "System.String" || datatable.Columns[j].DataType.FullName == "System.DateTime")
									strRow +="-'"+",'";
									//							else
									//								strRow +="0"+",";

								}
								k++;
							}
							//k++;
						}
					}
                   
					objCmd.CommandText = "Insert into [Sheet1$] (" + strHeaders.Substring(0, strHeaders.Length - 1) + ") values ('" + strRow.Substring(0, strRow.Length - 3) + "')";
					objCmd.ExecuteNonQuery();
					strRow = "";
					j = 0;
					k=0;
				}

			}
		}
		catch (Exception ex)
		{
			throw ex;
		}
		finally
		{
			objCmd = null;
			objXlsCon.Close();
		}
       
	}

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.