Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jwrz200t

  1. jwrz200t

    problem with gridview

    Iam new to asp.net and Iam trying to bring my LDAP values on to a grid view. When I run my application iam not able to see the grid (the page turns up empty) what could be the possible reason?? public DataSet Userlogin(string sFilter, string[] columns, string path, bool useCached) {...
  2. jwrz200t

    handling sql exception

    Iam trying to give access to users who are in a database table the code is working fine if i type in the right username and password. But when i type incorrect username or password iam getting an error: index out of range exception was not handled by user code. There is no row at position 0.Blow...
  3. jwrz200t

    SQL command

    private void SortGridView(string sortExpression, string direction) { DataTable dt = GetData().Tables[0]; DataView dv = new DataView(dt); dv.Sort = sortExpression + " " + direction; GridView1.DataSource = dv; GridView1.DataBind(); }
  4. jwrz200t

    SQL command

    here is my code which loads the grid private DataSet GetData() { string strUlid = Session["id"].ToString(); string strDdlValue = ""; if (ddlSeach.SelectedValue == "ID") { strDdlValue = "ID"; } else if (ddlSeach.SelectedValue ==...
  5. jwrz200t

    SQL command

    its a gridview control. Now most of the things are working fine but there is still a small problem. When i click on the headers to sort the column of the grid the dataset is getting refreshed. And when i move on to the next page the sort order is not maintained. So how do i stop the dataset from...
  6. jwrz200t

    SQL command

    can you please be more clear because iam really new to all these stuff.This is what i have <asp:BoundField DataField="DATE_ENTERED" HeaderText="Date Entered" SortExpression = "DATE_ENTERED" /> what should i do now??
  7. jwrz200t

    SQL command

    thanx benson i got the sorting to work properly now, i just changed the datatype from varchar to datetime. now can i any means just dispaly only the date??? and also when i sort a perticular field and move on to the next page the sorting is lost how can i overcome these problems ???
  8. jwrz200t

    SQL command

    Its still not working. I have a form with the date and time fields which are drop down boxes and the code is as follows: private void ddlTimeDataBinding() { string[] strHourList = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12" }; ddlHrentered.DataSource =...
  9. jwrz200t

    SQL command

    ur command works perfectly but i want to change the DATE_REPORTED column to a datetime, but in ur command we are creating an alias column mydate. how can i get it right???
  10. jwrz200t

    SQL command

    i have a date field in the database which was declared as a varchar datatype. Because of that iam having problems sorting this date field inside the grid. Can anyone give me a SQL command to convert the varchar data type to a datetime data type??
  11. jwrz200t

    The server tag is not well formed.

    Error 1 C:\Inetpub\wwwroot\accident\admin\Default.aspx: ASP.NET runtime error: A call to Bind must be assigned to a property of a control inside a template. C:\Inetpub\wwwroot\accident\admin\Default.aspx 88. This error is occouring at line 88 which is <asp:Label ID="Label3" runat="server"...
  12. jwrz200t

    The server tag is not well formed.

    I want to sort a date column in a grid view and iam using the following code. Iam getting an error The server tag is not well formed. <asp:TemplateField HeaderText ="Date Injured"> <EditItemTemplate> <asp:Label ID="Label3" runat="server" Text=‘<%# Eval("DATE"...
  13. jwrz200t

    strange problem with grid view sorting

    this is my second post and iam using MS sql database
  14. jwrz200t

    strange problem with grid view sorting

    can u please give me the sql command to covert to datetime while querying???
  15. jwrz200t

    strange problem with grid view sorting

    its a varchar data type

Part and Inventory Search

Back
Top