ASP.NET

JosephWONG28-May-07 2:24

28-May-07 2:24

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

Sathesh Sakthivel28-May-07 3:02

28-May-07 3:02

Check your Connection String? Because that may also have problem?

Regards,

Satips.

JosephWONG28-May-07 3:59

28-May-07 3:59

Dear Satips,

I have checked the Connection String, it's correct!

Thanks & Regards

JosephWONG

Sathesh Sakthivel28-May-07 4:02

28-May-07 4:02

Let paste the Code we will check it out.

Regards,

Satips.

JosephWONG28-May-07 4:06

28-May-07 4:06

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

Sathesh Sakthivel28-May-07 4:26

28-May-07 4:26

In the code there is no error it should work fine.

Regards,

Satips.

JosephWONG28-May-07 4:35

28-May-07 4:35

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

Sathesh Sakthivel28-May-07 15:40

28-May-07 15:40

Did you wrote the class for the Insert,Update, Edit and Delete and did you execute that class?

Regards,

Satips.

JosephWONG30-May-07 17:32

30-May-07 17:32

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!

JosephWONG30-May-07 17:32

aspSmartUpload error '800a0009'

30-May-07 17:32

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!

Anurag Gandhi28-May-07 1:03

Anurag Gandhi

28-May-07 1:03

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.

Re: aspSmartUpload error '800a0009'

Christian Graus28-May-07 1:11

Christian Graus

28-May-07 1:11

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 )

dropdownlist + gridview

ritu432128-May-07 0:36

28-May-07 0:36

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. Unsure | :~

thanx .

Sherin Iranimose28-May-07 1:35

Sherin Iranimose

28-May-07 1:35

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

ritu432128-May-07 1:42

28-May-07 1:42

since i am using ajax --update panel my doing autopostback to true also donot go into the event .

Sathesh Sakthivel28-May-07 2:16

28-May-07 2:16

Did you check it by putting the break points on the DropDownList and see what error it shows?

Regards,

Satips.

ritu432128-May-07 2:58

28-May-07 2:58

i am not getting any errors .

Sathesh Sakthivel28-May-07 3:01

28-May-07 3:01

Did you get the values after executing the break point (or) it is null?

Regards,

Satips.

ritu432128-May-07 3:04

28-May-07 3:04

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);
}

Sathesh Sakthivel28-May-07 3:09

28-May-07 3:09

Fine.

Regards,

Satips.

ritu432128-May-07 3:48

28-May-07 3:48

THANKS

Sathesh Sakthivel28-May-07 4:03