Comments by Member 9376025 (Top 30 by date)

i used the above code but the secondpage data is displaying upto 10..and on clicking 3rd page all the records is displaying..

ya i used ExecuteReader(),
but not coming..
is there any changes in code..

not by letters like stars it can display..

thanks..

I solved my problem..
in the above code
insted of this two lines
TextBox txtcity = (TextBox)row.FindControl("lbleditcity");
TextBox txtDesignation = (TextBox)row.FindControl("lbleditdesignation");

replace this lines
TextBox txtcity = (TextBox)row.FindControl("txteditcity");
TextBox txtDesignation = (TextBox)row.FindControl("txteditdesignation");

Thanks alot TR..

i changed the code as above but the same error is coming....
"Object reference not set to an instance of an object."
Can u help me...

there is no null value for id,text,designation

ya in gvdetails_rowUpdating the error line is
SqlCommand cmd=new SqlCommand("update from GridDetails set City='"+txtcity.Text+"',Designation='"+txtDesignation.Text+"' where Userid="+userid,con);

i changed there bindgridview();
then clicking on update button the error is occured "Object reference not set to an instance of an object."

no by cliking edit button all table desapear..

thanks prasad

both...

i did same code .but i want to display here image in gridview

this is all my pages..what i have used as with database admin page: As source page ie.,aspx <tr> <td> Select Type </td> <td> : </td> <td width="150"> <asp:DropDownList ID="ddltype" AppendDataBoundItems="true" runat="server" SkinID="DDListNormalRequired" Width="170px"> <asp:ListItem Value="-1">Select <asp:ListItem >Family <asp:ListItem>Friends <asp:ListItem>others </td> </tr> <tr> <td>Enter Name</td> <td> : </td> <td> <asp:TextBox ID="txtName" runat="server" Width="170px"> </td> </tr> <tr> <td>SelectImage</td> <td> : </td> <td> <asp:FileUpload ID="FileUpload1" runat="server" /> </td> </tr> <tr> <td> <asp:Button ID="btnInsert" runat="server" Text="Insert" Width="100" onclick="btnInsert_Click"/> </td> </tr> now aspx.cs page SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["sss"].ConnectionString); protected void Page_Load(object sender, EventArgs e) { } protected void btnInsert_Click(object sender, EventArgs e) { try { string s = FileUpload1.PostedFile.FileName; string a = Server.MapPath(".")+"//images//"; FileUpload1.SaveAs(a + s); string imagepath = "Admin/images/" + s; SqlCommand cmd = new SqlCommand("type", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@selecttype", ddltype.Text); cmd.Parameters.AddWithValue("@entername ", txtName.Text); cmd.Parameters.Add("@imagepath ", imagepath); con.Open(); cmd.ExecuteNonQuery(); con.Close(); //Response.Redirect("~Default2.aspx"); } catch(Exception ex) { throw ex; } second page <div> <asp:DataList ID="DataList1" runat="server"> <asp:HyperLink ID="family" runat="server" Navigateurl='<%#"Default2.aspx?Id="+DataBinder.Eval(Container.DataItem,"id").ToString()+""%>' Text='<%#Eval("names") %>'> </div> aspx.cs page protected void Page_Load(object sender, EventArgs e) { fillgroups(); } private void fillgroups() { string s = "select * from groups "; SqlDataAdapter da = new SqlDataAdapter(s, con); DataSet ds = new DataSet(); da.Fill(ds,"groups"); DataList1.DataSource = ds.Tables[0]; DataList1.DataBind(); } thrid page <td> <asp:CheckBox ID="CheckBox2" runat="server" Text="Family" Width="170px" /> </td> </tr> <tr> <td> <asp:CheckBox ID="CheckBox1" runat="server" Text="Friends" Width="170px" Height="21px"/> </td> </tr> <tr> <td> <asp:CheckBox ID="CheckBox3" runat="server" Text="Others" Width="170px"/> </td> </tr> <tr> <td> <asp:Button ID="btnDelete" runat="server" Text="Delete" onclick="btnDelete_Click" /> </td> </tr> for thrid page i want C# code the database table is Family varchar(50) Checked Friends varchar(50) Checked Others varchar(50) Checked id int Checked name varbinary(50) Checked names varchar(MAX) Checked Selecttype varchar(50) Checked SelectName varchar(50) Checked SelectImage image Checked imagepath varchar(MAX) Checked Stored procedure code ALTER procedure [dbo].[details] @Family varchar(50), @Friends varchar(50), @Others varchar(50) as

can i post here my code...
can u help

this is all my pages..what i have used as with database
admin page:
As source page ie.,aspx
<tr>
<td>
Select Type
</td>
<td>
:
</td>
<td width="150">
<asp:DropDownList ID="ddltype" AppendDataBoundItems="true" runat="server" SkinID="DDListNormalRequired" Width="170px">
<asp:ListItem Value="-1">Select
<asp:ListItem >Family
<asp:ListItem>Friends
<asp:ListItem>others

</td>
</tr>
<tr>
<td>Enter Name</td>
<td>
:
</td>
<td>
<asp:TextBox ID="txtName" runat="server" Width="170px">
</td>
</tr>
<tr>
<td>SelectImage</td>
<td>
:
</td>
<td>
<asp:FileUpload ID="FileUpload1" runat="server" />
</td>

</tr>
<tr>
<td>
<asp:Button ID="btnInsert" runat="server" Text="Insert" Width="100"
onclick="btnInsert_Click"/>
</td>
</tr>
now aspx.cs page
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["sss"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{


}
protected void btnInsert_Click(object sender, EventArgs e)
{
try
{

string s = FileUpload1.PostedFile.FileName;
string a = Server.MapPath(".")+"//images//";
FileUpload1.SaveAs(a + s);
string imagepath = "Admin/images/" + s;

SqlCommand cmd = new SqlCommand("type", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@selecttype", ddltype.Text);
cmd.Parameters.AddWithValue("@entername ", txtName.Text);

cmd.Parameters.Add("@imagepath ", imagepath);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
//Response.Redirect("~Default2.aspx");

}
catch(Exception ex)
{
throw ex;

}
second page
<div>
<asp:DataList ID="DataList1" runat="server">
<itemtemplate>
<asp:HyperLink ID="family" runat="server" Navigateurl='<%#"Default2.aspx?Id="+DataBinder.Eval(Container.DataItem,"id").ToString()+""%>' Text='<%#Eval("names") %>'>


</div>
aspx.cs page
protected void Page_Load(object sender, EventArgs e)
{


fillgroups();





}
private void fillgroups()
{
string s = "select * from groups ";
SqlDataAdapter da = new SqlDataAdapter(s, con);
DataSet ds = new DataSet();
da.Fill(ds,"groups");
DataList1.DataSource = ds.Tables[0];
DataList1.DataBind();
}
thrid page
<td>
<asp:CheckBox ID="CheckBox2" runat="server" Text="Family" Width="170px" />

</td>
</tr>
<tr>
<td>
<asp:CheckBox ID="CheckBox1" runat="server" Text="Friends" Width="170px"
Height="21px"/>
</td>
</tr>
<tr>
<td>
<asp:CheckBox ID="CheckBox3" runat="server" Text="Others" Width="170px"/>
</td>
</tr>

<tr>
<td>
<asp:Button ID="btnDelete" runat="server" Text="Delete"
onclick="btnDelete_Click" />
</td>
</tr>
for thrid page i want C# code

the database table is
Family varchar(50) Checked
Friends varchar(50) Checked
Others varchar(50) Checked

id int Checked
name varbinary(50) Checked
names varchar(MAX) Checked

Selecttype varchar(50) Checked
SelectName varchar(50) Checked
SelectImage image Checked
imagepath varchar(MAX) Checked

Stored procedure code
ALTER procedure [dbo].[details]
@Family varchar(50),
@Friends varchar(50),
@Others varchar(50)
as

i want with out gridview

not using gridview

hii
iam using the above site by that geting error i gridview as last line..

i want just for values..for this iwant source code and C# code can u

thanku

thanx

connection.close()