GridView Problem.. - ASP.NET Discussion Boards

http://www.mattkruse.com/javascript/colorpicker/[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

found one!

http://www.codeproject.com/aspnet/ColorPicker.asp

Smile | :)

is there ay other way to execute the reports other then the crystal reports viewer way?

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....

Sonia Gupta wrote:
other way

You mean rendering? You have builtin ways to export as PDF right? Acrobat Reader or FoxIT is quite common tool of every desktop.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

if u please provide any link?

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....

http://www.c-sharpcorner.com/UploadFile/chriswong1/ExportCrystalReportInASPNET11092005010905AM/ExportCrystalReportInASPNET.aspx[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

hello dude,
There is other way it is using a report viewer control.By that we can generate reports.Plz search and reply again i want the details about that control....i think we can generate report using SQL REPORTING SERVICES CONFIGURATION...

ok byeee
Murali

Murali

Hi Everyone,

I have 4 columns GridView.. One is BoundField This column is binded to Sno field from my Access Datasource.. 2nd, 3rd & 4th columns are TemplateFields (PartNo, Manufacturer, Qunatity) .. In this Template Fields, I have textboxes./.

Now, Below this Gridview i hv a Button (btnSubmit). What I am trying to do is when user enters values in to textboxes & click on Submit button, all the values should get update in the database..

To achieve this, i have written the following code:
<asp:GridView ID="myGridView1" runat="server" Width="483px" CellPadding="4" ForeColor="#333333" AutoGenerateColumns="False" DataSourceID="AccessDataSource1" OnSelectedIndexChanged="myGridView1_SelectedIndexChanged">
<Columns>
<asp:BoundField DataField="Sno" HeaderText="SNo" SortExpression="Sno"/>

<asp:TemplateField HeaderText="PartNo">
<ItemTemplate>
<asp:TextBox runat="server" ID="txtPartNo">
</asp:TextBox>
</ItemTemplate>
</asp:TemplateField>

<asp:TemplateField HeaderText="Manufacturer">
<ItemTemplate>
<asp:TextBox runat="server" ID="txtMfg">
</asp:TextBox>
</ItemTemplate>
</asp:TemplateField>

<asp:TemplateField HeaderText="Quantity">
<ItemTemplate>
<asp:TextBox runat="server" ID="txtQty">
</asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />

</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/db1.mdb"
SelectCommand="SELECT [Sno] FROM [RfqInfo]" >

____________________________

protected void btnSubmit_Click(object sender, EventArgs e)
{
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Documents and Settings\\venki\\My Documents\\Visual Studio 2005\\WebSites\\RFQTest\\App_Data\\db1.mdb");
myConnection.Open();

string strQuery = string.Empty;

foreach(GridViewRow dgRow in myGridView1.Rows)
{
string str = ((TextBox)dgRow.FindControl("txtPartNo")).Text.ToString();
string str1 = ((TextBox)dgRow.FindControl("txtMfg")).Text.ToString();
string str2 = ((TextBox)dgRow.FindControl("txtQty")).Text.ToString();

strQuery = "UPDATE [RfqInfo] SET [Partno]= '" + str + "', [mfg] = '" + str1 + "', [qty] = '" + str2 + "'";
}

OleDbCommand cmd = new OleDbCommand(strQuery, myConnection);
cmd.ExecuteNonQuery();

myConnection.Close();
}

now, my problem is when i'm clicking on submit its updating the database with the values of last row in my gridview... Confused | :confused:

i'm really lost here.... Anyone please help me........ Is there any wrong with my code? I have searched throughout the google but couldn't fine one...

Any help would be appreciated........
Thanks in Advance.

Hi DKalepu,

I think ,
string str = ((TextBox)dgRow.FindControl("txtPartNo")).Text.ToString();
this line your code giving you problem as you finding control but grid view is having rows of controls so it take last value and gives u ..
try to get values for perticular row .

try this ,
myGridView1.Rows[dgRow.RowIndex].FindControl("txtPartNo")).Text.ToString();

i am not sure ..try some R&D on this u will find answer

pallavi

Hi Pallavi,

thanks for reply.... I have tried it by debugging. oh but still, same problem..
the value gets stored in the last row position only... Roll eyes | :rolleyes:

can u plz give me any other advices.....

Thanks,
Durga.

hello sir,
Instead of keeping in ItemTemplate keep in EditItemTemplate..

ok It will work and plz check datasourceID and dataconnection ..I think only one should be declared.

Try like this ..

ok byee
Murali

Murali

Hi Murali,

i hv tried using EditItemTemplate as u said... but itisn't showing any textboxes there... Confused | :confused:

fyi, i'm a girl.. Laugh | :laugh:

Thanks,
Durga.

hello durga,
in the edit item template u need to declare the asp:textbox it will not come automatically.try u will get...

ok byeee

Murali

I have tried it already, but it doesn't show up anything..... Confused | :confused:

hi durga,

put
OleDbCommand cmd = new OleDbCommand(strQuery, myConnection);
cmd.ExecuteNonQuery();
code in foreach loop .. now u will get what u want and put where cluase in your query

Big Grin | :-D

pallavi

Thanks for the kind help Pallavi.. My problem solved now.. Big Grin | :-D

Hi

in your code errore is in the this line "strQuery = "UPDATE [RfqInfo] SET [Partno]= '" + str + "', [mfg] = '" + str1 + "', [qty] = '" + str2 + "'";
"

you have not mantioned any whare condition for updating particuler row thats why when last time ur query get executed it update all rows by last row in ur gridview .

Hirdesh

Hi Hirdesh,
thanks for replying...
I have included the where condition but its showing.. "Syntax error (missing operator) in query expression '[Sno] = Sno[1]'."

here is code snippet:

int i = dgRow.RowIndex + 1;

str = ((TextBox)myGridView1.Rows[dgRow.RowIndex].FindControl("txtPartNo")).Text.ToString();

strQuery = "UPDATE [RfqInfo] SET [Partno]= '" + str + "', [mfg] = '" + str1 + "', [qty] = '" + str2 + "' WHERE [Sno] = Sno[" + i + "]";

plz help me...

replace your query string by

strQuery = "UPDATE [RfqInfo] SET [Partno]= '" + str + "', [mfg] = '" + str1 + "', [qty] = '" + str2 + "' WHERE [Sno] = " + i;

i'm sure ur code will run fine.

Hirdesh Smile | :)

Hi, yup.. it worked very well now...Thank youveryyy much, once again thanks a lot.. Big Grin | :-D

what is App.ico in .net? Can anybody explain me about it. i can't get a clear idea about it.

.ico is an extention for icon for starters.
Therefore App.ico = Application Icon.

This is default icon for your application.

God Bless you.
Always do good to others

Hi,

can anyone say what is the error in the following code. the value present in the datagrid is not getting stored in the variable "assetcode".

Protected Sub dgresult_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles dgresult.SelectedIndexChanged
Dim assetcode As String
assetcode = dgresult.SelectedItem.Cells(1).Text
Response.Redirect("Edit_UPS.aspx?assetcode=" + assetcode + " ")
End Sub

What is the error message you are getting??

There is no property of DataGrid called SelectedItem by the way !!