|
Dear all,
I am wirting an ASP.NET with VB. In my web form, there are a DataGrid which is contained Edit and Update function. But I found that I cannot update my data during testing. Could anyone tell me how to solve this problem.
Thanks and regards.
JosephWONG
Finally, I hope my message can assist or takle your problem.
God Bless You!
|
|
|
|
|
Hi,
Can you tell us where exactly r u getting problem?
Your update query is not getting executed or your vb code is not getting executed or your data is not getting updated in your database or r u getting any exception?
Thanks and Regards,
Chetan Ranpariya
|
|
|
|
|
Dear Chetan Ranpariya,
I don't know that Why the data is not getting update in my database, and I have try to use other database to connect with my code, but it's works.
Could you tell me how can I let you know all of my code & database for your modification.
Thanks & regards.
JosephWONG
Finally, I hope my message can assist or takle your problem.
God Bless You!
|
|
|
|
|
What Database you connected with your project and in that did you execute the Query on the database?
Regards,
Satips.
|
|
|
|
|
Dear Satips,
I am using Access Database connected my project. I can execute the Quey on the database.
Please tell me what can I do to solve the problem.
Regards and Thanks.
JosephWONG
|
|
|
|
|
Check your Connection String? Because that may also have problem?
Regards,
Satips.
|
|
|
|
|
Dear Satips,
I have checked the Connection String, it's correct!
Thanks & Regards
JosephWONG
|
|
|
|
|
Let paste the Code we will check it out.
Regards,
Satips.
|
|
|
|
|
Dear Satips,
The code is shown as follow, and the database is MS Access.
<% @ Page Language="VB" Debug="True" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.OleDb" %>
<HTML>
<BODY>
<Form Runat="Server">
<asp:DataGrid id="dgQuesManage" runat="Server" HeaderStyle-BackColor="#CCFF00"
CellPadding="2" CellSpacing="2" DataKeyField="no"
onEditCommand="Edit"
onUpdateCommand="Update"
onCancelCommand="Cancel"
AutoGenerateColumns="False">
<Columns>
<asp:BoundColumn DataField="no" HeaderText="Question No" ReadOnly="True"/>
<asp:BoundColumn DataField="cid" HeaderText="Subject ID" ReadOnly="True"/>
<asp:BoundColumn DataField="stem" HeaderText="Question"/>
<asp:EditCommandColumn HeaderText="Edit" ItemStyle-Wrap="False"
EditText="Edit" UpdateText="Update" CancelText="Cancel"/>
</Columns>
</asp:DataGrid>
</Form>
</BODY>
</HTML>
<Script Language="VB" Runat="Server">
Sub Page_Load(Sender As Object, e As EventArgs)
If Not IsPostBack Then
open_db
End If
End Sub
Sub open_db()
Dim dbProvider As String="provider=Microsoft.Jet.OLEDB.4.0; data source=C:\Inetpub\wwwroot\Test\quiz2.mdb"
Dim con As New OleDbConnection(dbProvider )
Dim strSQL As String
Dim objDataAdapter As OleDbDataAdapter
Dim objDataSet As DataSet
con.Open()
strSQL = "Select * from itembank "
objDataAdapter = New OleDbDataAdapter(strSQL, con)
objDataSet = New DataSet()
objDataAdapter.Fill(objDataSet, "itembank")
dgQuesManage.DataSource=objDataSet.Tables("itembank").DefaultView
dgQuesManage.DataBind()
con.Close()
End Sub
Sub Edit(Sender As Object, e As DataGridCommandEventArgs)
dgQuesManage.EditItemIndex=e.Item.ItemIndex
open_db()
End Sub
Sub Update(Sender As Object, e As DataGridCommandEventArgs)
Dim dbProvider As String="provider=Microsoft.Jet.OLEDB.4.0; data source=C:\Inetpub\wwwroot\Test\quiz2.mdb"
Dim con As New OleDbConnection(dbProvider )
Dim strUpdateSQL, str1, no_str As String
con.Open()
Dim t1 As TextBox
t1=e.Item.Cells(2).Controls(0)
no_str=dgQuesManage.DataKeys(e.Item.ItemIndex)
str1="Set stem='" & t1.Text &"' Where no='" & no_str & "'"
strUpdateSQL="Update itembank " & str1
Dim objCommand As New OleDbCommand(strUpdateSQL, con)
objCommand.ExecuteNonQuery()
con.Close()
dgQuesManage.EditItemIndex=-1
open_db()
End Sub
Sub Cancel(Sender As Object, e As DataGridCommandEventArgs)
dgQuesManage.EditItemIndex=-1
open_db()
End Sub
</Script>
Thanks and regards.
JosephWONG
|
|
|
|
|
In the code there is no error it should work fine.
Regards,
Satips.
|
|
|
|
|
Dear Satips,
Before I post my code for you, I guess the code is correct! Actually I cannot store or update the data into the database. I don't know how to do????
Thanks for your assistance so much.
JosephWONG
|
|
|
|
|
Did you wrote the class for the Insert,Update, Edit and Delete and did you execute that class?
Regards,
Satips.
|
|
|
|
|
Dear Satips,
I have only wrote a class for Update, and have been tested by my friend, they replied that the class was fine and works.
Thanks a lot of assistance.
Regards
JosephWONG
Finally, I hope my message can assist or takle your problem.
God Bless You!
|
|
|
|
|
Dear Satips,
I have only wrote a class for Update, and have been tested by my friend, they replied that the class was fine and works.
Thanks a lot of assistance.
Regards
JosephWONG
Finally, I hope my message can assist or takle your problem.
God Bless You!
|
|
|
|
|
Hi All,
I am getting the following error when i am trying to execute my asp code:
aspSmartUpload error '800a0009'
Subscript out of range
/seba/marketing/updatejobs.asp, line 29
The code at Line 29 is:
mySmartUpload.Upload
Can anyone tell me what and where is the problem.
Thanks.
Anurag Gandhi.
|
|
|
|
|
This is the ASP.NET forum, try the web development forum for asp questions.
There's obviously no subscript there, looks like you're calling a component and it is what's blowing up.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
i am having a gridview in which i have a dropdown which is populating from the database on gridviews row created event . i want to show the default first row as select in the dropdownlist .How to do this
i did
<asp:DropDownList ID="DropDowmFormGroup" Width="100px"
runat="server" OnSelectedIndexChanged="DropDowmFormGroup_SelectedIndexChanged"><asp:ListItem Text="Select One"></asp:ListItem>
protected void DropDowmFormGroup_SelectedIndexChanged(object sender, EventArgs e)
{
foreach (GridViewRow gvr in GrdFormType.Rows)
{
maintainance m = new maintainance();
DataSet dsFormTypeForDropDown = new DataSet();
dsFormTypeForDropDown = m.Get_Form_Group();
if(gvr.RowType ==DataControlRowType.Footer)
{
DropDownList ddl = (DropDownList)gvr.FindControl
("DropDowmFormGroup");
ddl.DataSource = dsFormTypeForDropDown;
ddl.DataTextField = "Group_Name";
ddl.DataValueField = "Form_Group_ID";
ddl.DataBind();
}
}
}
but my this event is not firing on dropdownlist .
please help me out.  
thanx .
|
|
|
|
|
Hi,
You should set autopostback property of dropdownlist to true.
Then only the event will fire.
To succeed, we must first believe that we can.
Sherin Iranimose
|
|
|
|
|
since i am using ajax --update panel my doing autopostback to true also donot go into the event .
|
|
|
|
|
Did you check it by putting the break points on the DropDownList and see what error it shows?
Regards,
Satips.
|
|
|
|
|
i am not getting any errors .
|
|
|
|
|
Did you get the values after executing the break point (or) it is null?
Regards,
Satips.
|
|
|
|
|
i solved it myself now
like this.
ListItem li = new ListItem("--Select--","0");
ddl.Items.Insert(0, li);
ddl.SelectedValue = "0";
//ddlCountry.Items.Add(lst);
for (int i = 0; i <= dsFormTypeForDropDown.Tables[0].Rows.Count-1; i++)
{
ListItem lst = new ListItem();
lst.Text = (string ) dsFormTypeForDropDown.Tables[0].Rows[i][1];
//lst.Value = (Int32 ) dsFormTypeForDropDown.Tables[0].Rows[i][0];
ddl.Items.Add(lst);
}
|
|
|
|
|
Fine.![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
Regards,
Satips.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
