|
Hi all,
I have GridView which contains few columns of checkbox.My problem is how do I insert or Update Database on save button click(this button is outside the GridView).Following is the code what I have use but not getting where do U update DB:
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" Width="100%" CellPadding="4"
ForeColor="#333333" GridLines="None">
<Columns>
<asp:BoundField DataField="FormID" HeaderText="FormID"
InsertVisible="False" ReadOnly="True" SortExpression="FormID">
<HeaderStyle Width="50px" />
</asp:BoundField>
<asp:BoundField DataField="FormName" HeaderText="Form Name"
SortExpression="Name" >
<HeaderStyle Width="100px" />
</asp:BoundField>
<asp:TemplateField HeaderText="Add" SortExpression="Add">
<ItemTemplate>
<center>
<asp:CheckBox ID="chkAdd" runat="server" Checked='<%# IsActive(Eval("Add")) %>' />
</center>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Modify" SortExpression="Modify">
<ItemTemplate>
<center>
<asp:CheckBox ID="chkModify" runat="server" Checked='<%# IsActive(Eval("Modify")) %>' />
</center>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Delete" SortExpression="Delete">
<ItemTemplate>
<center>
<asp:CheckBox ID="chkDelete" runat="server" Checked='<%# IsActive(Eval("Delete")) %>' />
</center>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="View" SortExpression="View">
<ItemTemplate>
<center>
<asp:CheckBox ID="chkView" runat="server" Checked='<%# IsActive(Eval("View")) %>' />
</center>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Print" SortExpression="Print">
<ItemTemplate>
<center>
<asp:CheckBox ID="chkPrint" runat="server" Checked='<%# IsActive(Eval("Print")) %>' />
</center>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333"
HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
Public Shared Function IsActive(ByVal sValue As String) As Boolean
If sValue = "True" Then
Return True
Else
Return False
End If
End Function
Protected Sub btnSave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSave.Click
Dim index As Integer
Dim sCB1Add As String = String.Empty
Dim sCB2Modify As String = String.Empty
Dim sCB3Delete As String = String.Empty
Dim sCB4View As String = String.Empty
Dim sCB5Print As String = String.Empty
For index = 0 To GridView1.Rows.Count - 1
Dim gvRow As GridViewRow = GridView1.Rows(index)
If CType(gvRow.FindControl("chkAdd"), CheckBox).Checked Then
sCB1Add = "1"
Else
sCB1Add = "0"
End If
If CType(gvRow.FindControl("chkModify"), CheckBox).Checked Then
sCB2Modify = "1"
Else
sCB2Modify = "0"
End If
If CType(gvRow.FindControl("chkDelete"), CheckBox).Checked Then
sCB3Delete = "1"
Else
sCB3Delete = "0"
End If
If CType(gvRow.FindControl("chkView"), CheckBox).Checked Then
sCB4View = "1"
Else
sCB4View = "0"
End If
If CType(gvRow.FindControl("chkPrint"), CheckBox).Checked Then
sCB5Print = "1"
Else
sCB5Print = "0"
End If
Next
End Sub
Please help me as I am new for 2005 Version.
Thanks....
|
|
|
|
|
In your btnSave_Click event you can call an update command for each record w/in the loop. Based on which checkbox is selected, call the appropriate update method (INSERT/UPDATE/DELETE).
The other option is to perform each operation (Add, Update, Delete) on a DataTable object, define a DataAdapter object and set the UpdateCommand, InsertCommand and DeleteCommand properties then pass the DataTable to the DataAdapter.Update() method.
|
|
|
|
|
Hi all,
can smbody please give me the codings to create a crystal report in ASP.NET?
I need to extract data to the report from a specified query. How to provide the query to the crystal report??
and how do you display it on the web page, can I use the reportviewer to do that or is there anty other method?
Thanks for any reply!!
|
|
|
|
|
Hi there.
i want to show pop up box on any event i have selected from d dropdown menu.please reply me by my mail id or here itself.
nimal_8@yahoo.com
Regards
Neemal Shah
|
|
|
|
|
Use Javascript to handle the onclick event. You should have no difficulty finding resources here [^]
only two letters away from being an asset
|
|
|
|
|
hi i m mayur
you can write javascript onchange event on bropdownlist
in javascript you can show hide panel or div
like
document.getElementById('rfvleavingdate').style.display = 'block';
document.getElementById('rfvleavingtype').style.display = 'none';
|
|
|
|
|
Hi, now i my ISP's smtp server and it is "maltanet.net". Now for some reason, from the localhost it is being sent fast and the email is being sent for REAL. but when i am uploading the website on the server, the email will be sent very long (very slow) and the email is not being send!  why is this?
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
|
|
|
|
|
Check the SMTP server of the server machine where you uploaded...
|
|
|
|
|
Thanks very much bro!! it worked 100% because the problem that i was doing, is that i was using the smtp of the web server on my localhost and it was firing back an error about spamming. then when i uploaded the asp files, they worked well with the smtp of the web server!!
Thanks again!!
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
|
|
|
|
|
You are most welcome... 
|
|
|
|
|
Hi! Does anyone know how the following files encircled in red were added into the project?(see image from link)
http://img.photobucket.com/albums/v247/diorelle/cultures.jpg[^]
There isn't any template for it when I try to add a new item into the solution, plus the item doesn't go under the Global.asax file... I wanted to add a new resource file for another language...
Thanks so much! 
|
|
|
|
|
You can add the language-specific resource file as you would with a normal file, then you need to open the project file and add the DependentUpon attribute for the File entry of this resource file. You can see the File entry of the Global.asax.resx in the project file as an example.
|
|
|
|
|
I have a page that uses javascript to encypt its contents after a button is pressed before calling
document.forms[0].submit();
to submit the form, however the event handler for the button is not called.
I dont want to call it from postback as there are other server control on the page - any ideas what could be goind wrong?
I have already tried repairing "ASP.NET" as some times I know this can happen but I have had no luck.
Any help will be apreciated.
Dan
|
|
|
|
|
The problem is that when you just call submit() on the form instead of using postback the post is missing the arguments needed to call the proper event handler.
Could you clarify what your requirements are? Why don't you want to call postback? It sounds like you want to make sure all the data on the form is submitted, but this is what happens by default. After the client-side postback methods are called the form.submit() method is called if there are no errors.
|
|
|
|
|
Hi
Sorry for not being clear. I do want postback to be called, however at the moment I explicitly call btnSubmit_Click in my postback so that it would fire the event.
I feel this is becoming more of a javascript issue now and that this is the wrong place for it but how do I make it so that it just postsback rather than use submit()
Sorry for the wrong message board.
Cheers
Dan
|
|
|
|
|
Is btnSubmit_Click a server-side or client-side method? If it's server-side then you should be able to register it with the click event by setting the name of the method to the value of the "Click" property in the property window or as the OnClick attribute of the asp:Button element.
Also, have you verified that you've added runat="server" to the control? I sometimes forget this when hand-coding controls.
If neither of these helps, could you provide some code snippets of your web form code?
|
|
|
|
|
Thanks for all the help guys
Turns out it wasnt an ASP problem but my lack of understanding of javascript.
Just incase any one else has the problem i had i fixed it by:
adding to the form tag onsubmit="return ValidateFields();" this runs the client side code and then if returns true posts back with the inforation of which server control event needs firing.
Thanks again
Dan
|
|
|
|
|
hi all
here i have a problem with crystal reports. while printing a report, print is coming in two pages.
if i have grouping on any one field, it is ginving an error- 'crystal engine error'
what is best way to use the crystal reports.
thanking you
|
|
|
|
|
Hi all. While developing the application in asp.net 2.0, i have seen once a file (auto generated by a tool in which all namespaces, sources , dataset references etc etc can be found) when i was in debug mode. But I want to see it without debug mode. Can anyone tell me from where i can see that file. Please tell me. i will be very thankful to you.
|
|
|
|
|
Normally, the ASP.NET generates the dynamic source file in the ASP.NET temp folder, however when the debug attribute of the comilation entry is false, it does not generate the source files such as .cs, or .vb there. You might be interested in Dino's article[^].
|
|
|
|
|
I am using Visual Web Developer 2005 and am using the provided login controls to control access to a site. How can I access the logged in user's name (or role membership) in VB without putting one of the login controls on the page?
|
|
|
|
|
Bah! I found it.
FYI, it's in Page.User.Identity.Name.
|
|
|
|
|
Hi,
I wish to submit my web form by hitting the ENTER Key from anywhere in the form.
How to achieve this? Kindly help me
I am using asp.net 1.1
Regards,
Jay
|
|
|
|
|
If you have a Submit button, this will be "pressed" automatically.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
There is a subtle "feature" in IE that can cause problems. If, for example, your form consists of only one textbox and one or more buttons, then when the textbox has the focus and you hit ENTER, the form will still do a postback, but the button's click event handler does not get raised.
You can work around this in one of two ways:
1) Insert another textbox in the form, but use CSS to hide it from view.
2) Handle the "ENTER" keypress in JavaScript and use it to manually invoke a postback from the submit button.
I know this doesn't directly answer your question, but I thought I'd throw it out there in the off chance that it would help you out.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
