User Profile

Collapse

Profile Sidebar

Collapse
rogerford
rogerford
Last Activity: Jul 28 '08, 03:27 PM
Joined: Feb 12 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • rogerford
    started a topic Grid view Edit Item Template column not visible.
    in .NET

    Grid view Edit Item Template column not visible.

    I have a grid which i bind with values from Database. I have events to edit and update the grid. I am not using SqlDatasource to connect to DB. Rather i am doing the updating of the grid Programmaticall y.

    I have 3 columns, LID(item template column) ,LVal (Edit Item template column) and Edit link

    My Question:
    1) My EditITemTemplat e column has a textbox txt_Lval which does not show up on the page load. But if click...
    See more | Go to post
    Last edited by Curtis Rutland; Jul 28 '08, 03:38 PM. Reason: Added Code Tags - Please use the # button

  • rogerford
    started a topic Named Ranges Find and Update
    in .NET

    Named Ranges Find and Update

    1) I have a Namedrange which is named Company in sheet 2.
    Sheet 1 cell A2 has a list created via data validation referencing to this sheet 2 Column A values.
    2) If i go to Name Manager (by doing a Ctrl+f3) on the name manager window the formula will be =Sheet2!$A$2:$A $6
    3) I am using Microsoft.Offic e.Interop.Excel component.
    4) Now on my .net application i want to find a namerange in sheet 1 with a particular name like...
    See more | Go to post

  • rogerford
    replied to Sql Inner Join/Union
    I got the answer for my Question.
    I declared a temp table. Inserted into temp table DDLName from tbl_dropdownlis t and ordered them. Inserted into temp table LValue from tbl_ListValues and ordered them. Select * from "temp table name"....
    See more | Go to post

    Leave a comment:


  • rogerford
    started a topic Sql Inner Join/Union

    Sql Inner Join/Union

    I have two tables tbl_Dropdownlis t and tbl_ListbValues

    tbl_Dropdownlis t has fol. Columns.
    DDLid -PK
    DDLName


    tbl_ListValues has fol. columns.
    ListValueId
    DDlid – FK
    LValue


    On my result set I need DDLname from tbl_Dropdownlis t & LValue associated with DDLName in tbl_ListValues.

    if try a inner join query like "select tbl_Dropdownlis t.DDLName,ListV alues.LValue...
    See more | Go to post

  • rogerford
    started a topic Handling output Sqlparameter
    in .NET

    Handling output Sqlparameter

    Hi,
    I am trying to retrieve a value from database, based on that value I want to insert records into DB.Let’s say I am retrieving tsmid which serves as the output parameter in the stored procedure.

    .net/C# code is
    Code:
    public void getTSmid()
            {
                int tsid=0;
               tsid = System.Convert.ToInt32(SqlHelper.ExecuteReader(SqlHelper.tConnectionString,
                CommandType.StoredProcedure,
    ...
    See more | Go to post
    Last edited by Plater; Feb 14 '08, 06:33 PM. Reason: added [CODE] tags
No activity results to display
Show More
Working...