Results 1 to 3 of 3

Thread: gridview help me pls

  1. #1
    Junior Member
    Join Date
    May 2008
    Answers
    1

    gridview help me pls

    i wana use gridview on my page which i select the table name on dropdownlist then gridview show that table and i wanna use delete and update buttons on gridview help me pls


  2. #2
    Contributing Member
    Join Date
    Jun 2007
    Answers
    65

    Re: gridview help me pls

    Quote Originally Posted by sharpnet View Post
    i wana use gridview on my page which i select the table name on dropdownlist then gridview show that table
    For this follow steps below
    1. create a function BindGrid with input param tableName as string
    2. In function BindGrid create a SqlDataAdapter with sql query "Select * from "+ tableName +""
    3. Create a DataTable object and fill it with SqlDataAdapater
    4. Pass it as DataSource to DataGrid
    5. On SelectedIndexChange of DropDownList call function BindGrid and pass DropDownList.SelectedItem as param into it


    Quote Originally Posted by sharpnet View Post
    i wanna use delete and update buttons on gridview help me pls
    For this u can set properties of grid to have update and delete buttons

    Hope this help u. If still have some problem then pls ask.

    ---V V---
    Vikas Vaidya

    Please mark this post as Thank if u found it useful


  3. #3
    Junior Member
    Join Date
    Jul 2008
    Answers
    7

    Re: gridview help me pls

    HI I AM TAKING HERE 2 text boxes(1 for id ,2 for name) and one button , if u enter any thing in those text boxes and press button then data will display in grid

    <asp:datagrid id="DataGrid1" style="Z-INDEX: 103; LEFT: 88px; POSITION: absolute; TOP: 224px"
    runat="server" BackColor="MistyRose" Width="368px" AutoGenerateColumns="False" BorderColor="Blue">
    <AlternatingItemStyle BackColor="#FFC0C0"></AlternatingItemStyle>
    <HeaderStyle Font-Bold="True" ForeColor="Black" BackColor="#8080FF"></HeaderStyle>
    <Columns>
    <asp:ButtonColumn Text="Select" HeaderText="Select Custid" CommandName="Select"></asp:ButtonColumn>
    <asp:BoundColumn DataField="id" HeaderText="Location Code">
    <HeaderStyle Font-Bold="False" ForeColor="Black"></HeaderStyle>
    <ItemStyle Font-Bold="False" ForeColor="Black"></ItemStyle>
    </asp:BoundColumn>
    <asp:BoundColumn DataField="address" HeaderText="Business Location">
    <HeaderStyle Font-Bold="False" ForeColor="Black"></HeaderStyle>
    <ItemStyle Font-Bold="False" ForeColor="Black"></ItemStyle>
    </asp:BoundColumn>
    <asp:EditCommandColumn ButtonType="PushButton" UpdateText="Update" HeaderText="Edit" CancelText="Cancel"
    EditText="Edit"></asp:EditCommandColumn>
    <asp:ButtonColumn Text="Delete" HeaderText="Deleting Custid" CommandName="Delete"></asp:ButtonColumn>
    </Columns>
    </asp:datagrid>

    private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
    {
    if(e.CommandName=="Select")
    {
    string item1 = e.Item.Cells[1].Text;
    string item2 = e.Item.Cells[2].Text;
    Page.RegisterClientScriptBlock("_close","<script>window.opener.setvalue1('" + item1 +"','" +item2 + "'); window.close(); </script>");
    }
    if(e.CommandName=="Delete")
    {
    string item1 = e.Item.Cells[1].Text;
    string item2 = e.Item.Cells[2].Text;
    SqlConnection con=new SqlConnection("server=*******;Database=*******;uid=*******;pwd=*******");
    con.Open();
    SqlCommand cmd=new SqlCommand("Delete gfgf where id='"+item1+"' and address='"+item2+"'",con);
    cmd.ExecuteNonQuery();
    Page.RegisterStartupScript("MyScript","<script>alert('Your data has been successfully deleted')</script>");
    binddatas();

    }
    }
    private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
    {
    DataGrid1.EditItemIndex=e.Item.ItemIndex;
    binddatas();
    }
    private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
    {
    DataGrid1.EditItemIndex = -1;
    binddatas();
    }
    private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
    {
    DataGrid1.EditItemIndex = -1;
    TextBox qtyText = (TextBox)e.Item.Cells[1].Controls[0];
    TextBox priceText = (TextBox)e.Item.Cells[2].Controls[0];
    String id = qtyText.Text;
    String address = priceText.Text;
    DataSet ds=new DataSet();
    SqlConnection con=new SqlConnection("server=*******;Database=*******;uid=*******;pwd=*******");
    con.Open();
    SqlCommand cmd=new SqlCommand("update ******* set address ='"+address+"' where id='"+id+"'",con);
    cmd.ExecuteNonQuery();
    DataGrid1.DataBind();
    binddatas();

    }
    private void Button1_Click(object sender, System.EventArgs e)
    {

    binddatas();

    }

    private void binddatas()
    {
    string s=txtbusinesslocation.Text;
    string s1=s+"%";
    string p=txtlocationcode.Text;
    string p1=p+"%";
    if(s1!="%")
    {
    DataSet ds=new DataSet();
    SqlConnection con=new SqlConnection("server=*******;Database=*******;uid=*******;pwd=*******");
    con.Open();
    SqlDataAdapter da=new SqlDataAdapter("select * from ******* where address like'"+s1+"'",con);
    da.Fill(ds);
    DataGrid1.DataSource=ds.Tables[0].DefaultView;
    DataGrid1.DataBind();
    }
    else if(p1!="%")
    {
    DataSet ds=new DataSet();
    SqlConnection con=new SqlConnection("server=*******;Database=*******;uid=*******;pwd=*******");
    con.Open();
    SqlDataAdapter da=new SqlDataAdapter("select * from ******* where id like'"+p1+"'",con);
    da.Fill(ds);
    DataGrid1.DataSource=ds.Tables[0].DefaultView;
    DataGrid1.DataBind();
    }
    }


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact