User Profile

Collapse

Profile Sidebar

Collapse
PetroTiburcio
PetroTiburcio
Last Activity: Jun 22 '13, 01:49 PM
Joined: May 17 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • String was not recognized as a valid DateTime

    I am getting this error whenever I leave my drop down lists blank: "String was not recognized as a valid DateTime". My code is below:

    aspx:

    Code:
    <asp:DropDownList ID="cboDay" runat="server" Width="55px" Height="32px" AppendDataBoundItems="true">
                    <asp:ListItem></asp:ListItem></asp:DropDownList >
        <asp:DropDownList
    ...
    See more | Go to post
    Last edited by Rabbit; Jun 10 '13, 03:33 PM. Reason: Please use code tags when posting code.

  • PetroTiburcio
    started a topic Show/hide sitemap if user is logged in

    Show/hide sitemap if user is logged in

    I have a log in page, code behind is below:

    Code:
    protected void btnLog_Click(object sender, EventArgs e)
    {
    
        SqlConnection conn1 = new SqlConnection("Data Source=GATE-PC\\SQLEXPRESS;Initial Catalog=dbUsers;Integrated Security=True");
        conn1.Open();
    
        SqlCommand cmdd = new SqlCommand("select * from Users where UserName = @user AND Password = @pass", conn1);
    
        SqlParameter
    ...
    See more | Go to post
    Last edited by Frinavale; Jun 12 '13, 05:26 PM.

  • Populates GridView2 based on selected row from GridView1

    Greetings! Help with gridviews. I have 2 gridview on my page: on GridView1 I have a column with select link, Id and Name which looks like this:

    Select | Id | Name
    select | 101 | Jack
    select | 102 | Cath

    Now, what I am trying to do is let's say, i clicked the select from the first row which is Jack, now my GridView2 will display the products ordered by Jack which looks like this:

    Id | ProductID...
    See more | Go to post

  • Hello Frinavale, thanks for replying. I have tried your code suggestion. But it is just validating the reg no, the user id is not validating, it is saving even id is already exists
    See more | Go to post

    Leave a comment:


  • PetroTiburcio
    started a topic checking if id and reg already exists

    checking if id and reg already exists

    I have this table Profile which has fields with user_Id and regNo and I want to check first if id and email are already exists before proceed to inserting datas. In my codes, I am able to validate only one row (either id or reg number), but if I am going to validate the two of them, it gives me an error, saying "Must declare the scalar variable @userid". I dont know if it is with my select that is wrong or something in my codes
    ...
    See more | Go to post

  • PetroTiburcio
    started a topic Delete rows in Gridview

    Delete rows in Gridview

    hi, I am having a problem with deleting gridview rows. I am populating my gridview by selecting value in a dropdownlist then by clicking the add button, value will be added in my gridview, here is my code:

    in my aspx:

    Code:
    <asp:GridView ID="GridView1" runat="server" 
                    CssClass="mGrid" EmptyDataText = "There are no records to display">
                    <Columns>
    ...
    See more | Go to post

  • Saving multiple rows of gridview into database

    Hi there, i have a gridview which populated via selected item on my drop down list which I don't have any problem with that. My problem is I am trying to save multiple rows on my gridview into my database, for example I have added 3 items on my gridview which looks like this:

    Id | Name
    111 | Jack
    222 | Nicole
    333 | John

    Now, I want all that under column Id which is 111, 222 and 333 will be save on...
    See more | Go to post

  • passing the value of dropdownlist into gridview

    Greetings everyone, I have a dropdownlist populated by my database, below is my code:
    Code:
    <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="dsNames" 
                    DataTextField="Name" DataValueField="Id">
                </asp:DropDownList>
                <asp:SqlDataSource ID="dsNames" runat="server" 
                    ConnectionString="<%$
    ...
    See more | Go to post

  • PetroTiburcio
    started a topic QueryString to Textbox

    QueryString to Textbox

    Hi, I have a table tblProfile, which contains fields with Id, Name, Address. I have 2 aspx page, which are Home.aspx and Here.aspx. On my Home.aspx I have used this code to pass the Id in my Here.aspx:
    Code:
    <asp:HyperLink ID="link" runat="server" NavigateUrl="Here.aspx?id={0}" 
                    Font-Names="Times New Roman" Font-Size="Medium" >Click here</asp:HyperLink>
    ...
    See more | Go to post

  • Passing selected row from gridview to dropdown

    Kindly help me passing selected row in gridview to my dropdown. I have 1 gridview, 1 textbox and 1 dropdown list box. My dropdown is populated by SqlDataSource from my table Country. On my gridview, I have 3 columns, which are SELECT, NAME and COUNTRY. Under SELECT column, I have my hyperlinked Select, every time I clicked on a certain row NAME will pass in textbox (no problem with that), but in my dropdown it does not populates the COUNTRY that...
    See more | Go to post
    Last edited by Rabbit; May 17 '13, 03:51 PM. Reason: Please use code tags when posting code.
No activity results to display
Show More
Working...