|
Hi,
I'm designing a online purchase form... i'm using gridview for this: here is my source code:
<asp:GridView ID="myGridView1" runat="server" Width="483px" CellPadding="4" ForeColor="#333333" AutoGenerateColumns="False" DataSourceID="AccessDataSource1" AllowPaging="True" 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]" UpdateCommand="UPDATE [RfqInfo] SET [Partno] = txtPartNo.Text, [mfg] = txtMfg.Text, [qty] = txtQty.Text WHERE [Sno] = Sno">
</asp:AccessDataSource>
below this i hv a "submit button".
whenever user enter values in the textboxes & click on sumit button values should update in the database...
how could I do that??.. Any one please help me. its urgent...
Thanks in Advance.
|
|
|
|
|
DKalepu wrote: whenever user enter values in the textboxes & click on sumit button values should update in the database...
how could I do that??
GridView is having a method called FindControl() which finds the control specified from the grid view. So in your scenario, you need to find each textboxes from grid view and update to DB.
TextBox txt = (TextBox) myGridView1.Rows[i].Cells[1].FindControl("txtPartNo");
This will give you the txtPartNo textbox object. Write code for all other controls like this.
|
|
|
|
|
hi friend
ur tring that method of updating the gridview data to database is applicable only on the gridview event.
and the person who had this problem asking for getting data updated on external button_click to the gridview.
so, see my reply, if u have any confusion @ this
Dont mind please...
Amit Metkar
3i-infotech, Mumbai.
|
|
|
|
|
amit.metkar wrote: ur tring that method of updating the gridview data to database is applicable only on the gridview event.
and the person who had this problem asking for getting data updated on external button_click to the gridview.
Dear,
Could you tell me how you judge this ? And please show me the difference between your and my code ? Only difference what I found is I given a hit, and you given entire code!. Actually my idea is just give a hint, why should I write entire code, it's like I doing his homework.
|
|
|
|
|
there is much more difference in ur code and my code
it is not like ur giving him just the hint and i m giving him the entire code OR homework.
UR CODE -- for the external button click which is not in gridview, so in this situation u can not get row index , this is the biggest problem in ur code, i m not saying that ur code was wrong.
MY CODE -- I get the Row index thro' GridViewRow Object. And one by one i can retrieve all rows and their cells values.
Amit Metkar
3i-infotech, Mumbai.
|
|
|
|
|
amit.metkar wrote: UR CODE -- for the external button click which is not in gridview, so in this situation u can not get row index , this is the biggest problem in ur code, i m not saying that ur code was wrong.
Again you are misunderstanding me, I think you are confused with that variable i, right ? I am very lazy to type  , so I didn't type the loop That's it. Anyway good suggestion, Thanks
|
|
|
|
|
Ohhh Dear,
Sorry @ that, but a small thing can make things differ.
Okay dear, Nice to talk with u..
Amit Metkar
3i-infotech, Mumbai.
|
|
|
|
|
Hi Navneeth, Thanks for the help! this piece of code solved my problem!
thanks once again!
|
|
|
|
|
U must have multiple rows in that GridView, so make a foreach loop like this.
foreach (GridViewRow dgRow in myGridView1.Rows)
{
string strPK = myGridView1.DataKeys[dgRow.RowIndex].Value.ToString();
string str = ((TextBox)dgRow.FindControl("txtText")).Text.ToString();
//like this u will get all cells values and PK field ..
//Now U can Update this data from Gridview of each row
//to DataBase
}
Amit Metkar
3i-infotech, Mumbai.
|
|
|
|
|
Hi, Thanks for the help... should I write it in "button_click" event..?
& also kindly plz tell me how to use the Update command to update database....
plz.. thanks in advance!
|
|
|
|
|
Yes, u can write that in "button_click" event.
and @ ur second Q, can u clarify it,i mean explain it little, i m not getting wat u want?
Amit Metkar
3i-infotech, Mumbai.
|
|
|
|
|
dont use external button... the thing ur doing is inbuild so use the smart tag and add or edit colums in that watever thing u needed just add it weather its edit r update r any thing else and in the fireevent write the coding.. i think tis will help u
vivek nanda
|
|
|
|
|
Hi all,
Can we browse for files without using file upload control. Is there any web user control.
Why I need this is, I want to browse multiple files at a time. That is not possible in file upload control. So could you please help me out to solve this problem.
Thanks and Regards,
Hariharan C
|
|
|
|
|
Looks like you have posted a similar thread in another forum also.
There aren't much file system specific controls for security reasons. You may need to go in for an ActiveX Solution for MultipleFiles.
|
|
|
|
|
Hi,
I am not familiar with activex solution. Can you teach me.
Thanks and Regards,
Hariharan C
|
|
|
|
|
Is this[^] your requirement ? If yes I think we had discussed lot there. Is it ?
|
|
|
|
|
Hi Navaneeth,
Yes we have discussed a lot about this.But still I didn't get my solution. My problem is I dont want the file upload control, where we can upload only one file at a time.
Can we have any other web user control for that, where we can browse for multiple files at a single click.
Thanks and Regards,
Hariharan C
|
|
|
|
|
Could you go through the previous threads ? I think my final answer will solve your problem.
|
|
|
|
|
Hi Navaneeth,
In the final answer what you have suggest is to add the list box. But there also we are adding the file one by one to the list box. we are not able to add more than one file at a stretch (i.e at one click) to the list box.
Thats why I am asking is there any other web user control, where you can browse more than one file at a single click. Could you please help me out.
Thanks and Regards,
Hariharan C
|
|
|
|
|
Then you can check the link what satips referred. But will your client browser allow activex controls to be installed ?
|
|
|
|
|
Multiple Files Upload[^]
Regards,
Satips. ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus
|
|
|
|
|
Is there any way to hide a dropdownlist when its holding data...?
SAJAN A PILLAI
C#.NET Programmer
TELESOFT INDIA PVT LTD...
BANGALORE
|
|
|
|
|
Do you want to hide a dropdownlist when it has items listed in it?
If yes,
if(dropdownlist1.items.count>0)
dropdownlist1.visible=false
gauthee
|
|
|
|
|
thnx anyway .....
i tried it another way...
dropdownlist1.Visible=false;
but that time i encountered a javascript error..saying that
Error : Object required ;
i am not getting wat it means...
i have written a javascript in .cs file, but has no relation with the dropdownlist..
SAJAN A PILLAI
C#.NET Programmer
TELESOFT INDIA PVT LTD...
BANGALORE
|
|
|
|
|
sajan ss wrote: i have written a javascript in .cs file, but has no relation with the dropdownlist..
Can you show us the Javascript that you wrote?
sajan ss wrote: Error : Object required ;
The invisible control doesn't show in HTML. So, any javascript code (eg: document.getElementById('dropdown');) which is trying to grap the id of invisible control will throw this error.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
