Re: Update a Database Using Dropdownlist in ASP VB.Net - ASP.NET Discussion Boards

Hi,
I have written the following code in javascript and when cancel
button is clicked in alert box, the record is getting saved and when again
second time when cancel button is clicked the functionality of
the cancel button in the alertbox is working fine.My issue is at the first time
my cancel button is not working and my record is getting saved.can anybody let me know the solution of this issue.
function confirmsave()
{
if(confirm("Are u sure u want to Save Record?"))
{
return true;
}
else
{
document.getElementById('<%=Label22.ClientID %>').innerHTML = "Cancel";
return false;
}
}
<asputton ID="btnsave" runat="server" Style="z-index: 101; left: 420px; position: absolute;
top: 37px" Text="Save" Width="64px" OnClientClick="javascript:return confirmsave();" OnClick="btnsave_Click" /> protected void btnsave_Click(object sender, EventArgs e)
{
if (Page.IsValid == true)
{
Label22.Visible = true;
Label22.Text = " Record Saved ";
}
} Thanks
Ramesh

<asputton id="btnsave" runat="server" style="z-index: 101; left: 420px; position: absolute;
top: 37px" text="Save" width="64px" onclientclick="return confirm('Are u sure u want to Save Record?')" onclick="btnsave_Click">

Try above code

Kiran Banker

The code block written looks good and I used the same code block and found that clicking "cancel" working as expected. In your situation if it is not working then try following

(1) I suspect that following line might be creating problem and as a result you are not getting correct result.

<br />
<br />
document.getElementById('<%=Label22.ClientID %>').innerHTML = "Cancel";<br />
<br />

Change the line to check whether it can find that object as follows, ( I suspect that following line could give 'null' in your actual code block,

alert(document.getElementById('<%=Label22.ClientID %>'));

Let me know if it helps,

Thanks,
Arindam D Tewary

Hello all,

First off I am using VB.net
I have a dropdown list in the Item template.
I would like the user to select a value and update the database without clicking an update button.

Here is the Code for the DDL

<asp:DropDownList ID="DropDownList1" runat="server" 
                            DataSourceID="SqlDataSource2" DataTextField="provider" 
                            DataValueField="provider" AutoPostBack="True" AppendDataboundItems="true" OnSelectedIndexChanged = "ddl_SelectedChange"
                             SelectedValue='<%# Bind("provider") %>'>
                            <asp:ListItem Value=""></asp:ListItem>
                        </asp:DropDownList>

here is my Behind code I am not sure what to put after the Dim statement

Protected Sub ddl_SelectedChange(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim ddl = DirectCast(sender, DropDownList)

Any help would be greatly appreciated

Where is the rest of the code behind?? or do you want us to help you in writing that???

Yes I am asking for hep is wrting that.

Thanks,

* Now that you have the drop down list object, you can get the selected value/text.
* You need to determine the row from which the event was fired and get the id.
- Simple means would be to associate the primary key data to the dropdown using attributes.

You can use these data to save the info to the database.

HTH!

<br />
  <asp:DropDownList ID="provider" runat="server"                             DataSourceID="dr" DataTextField="provider"                             DataValueField="provider" AutoPostBack="True" AppendDataboundItems="true" OnSelectedIndexChanged="dd_OnSelectedIndexChanged"                             SelectedValue='<%# Bind("provider") %>'>                            <asp:ListItem Value=""></asp:ListItem>                         </asp:DropDownList>  <asp:DropDownList ID="provider" runat="server" <br />
                            DataSourceID="dr" DataTextField="provider" <br />
                            DataValueField="provider" AutoPostBack="True" AppendDataboundItems="true" OnSelectedIndexChanged="dd_OnSelectedIndexChanged"<br />
                             SelectedValue='<%# Bind("provider") %>'><br />
                            <asp:ListItem Value=""></asp:ListItem><br />
                         </asp:DropDownList>

Here is the Behind Code

Protected Sub dd_OnSelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs)
        '*******************************************************
        '*This will get the dropdownlist which has been clicked*
        '*******************************************************
        Dim ddl As DropDownList
        ddl = DirectCast(sender, DropDownList)
        '***********************************************************************
        '*The row will be the currently selected row from which the dropdownlist*
        '*was clicked                                                           *
        '***********************************************************************
        Dim row As GridViewRow = DirectCast(ddl.NamingContainer, GridViewRow)
        '******************************
        '*Get the datakey for that row*
        '******************************
        Dim DataKey As String = GridView1.DataKeys(row.RowIndex).Values("IEN").ToString()
        '**********************
        '*Define Data Objects *
        '**********************
        Dim conn As SqlConnection
        Dim comm As SqlCommand

        '******************************************
        '*Read the connectionstring from we.config*
        '******************************************
        Dim ConnectionString As String = ConfigurationManager.ConnectionStrings("ER_BloodHoundConnectionString").ConnectionString
        '***********************
        '*Initialize Connection*
        '***********************
        conn = New SqlConnection(ConnectionString)
        '****************
        '*Create Command*
        '****************
        comm = New SqlCommand("UPDATE VW_Paitent SET provider=@provider WHERE IEN=@IEN", conn)
        '************************
        '*Add command Perameters*
        '************************
        comm.Parameters.Add("@Provider", System.Data.SqlDbType.NVarChar, 50)
        comm.Parameters("@Provider").Value = ddl.SelectedItem.Value

        comm.Parameters.Add("@IEN", System.Data.SqlDbType.Float)
        comm.Parameters("@IEN").Value = DataKey
        '*******************************************
        '*Enclose Database code in Try catch Finaly*
        '*******************************************
        Try
            '*********************
            '*Open the connection*
            '*********************
            conn.Open()
            '*********************
            '*Execute The command*
            '*********************
            comm.ExecuteNonQuery()
        Finally
            '**********************
            '*Close the connection*
            '**********************
            conn.Close()
        End Try
    End SubProtected Sub dd_OnSelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs)
        '*******************************************************
        '*This will get the dropdownlist which has been clicked*
        '*******************************************************
        Dim ddl As DropDownList
        ddl = DirectCast(sender, DropDownList)
        '***********************************************************************
        '*The row will be the currently selected row from which the dropdownlist*
        '*was clicked                                                           *
        '***********************************************************************
        Dim row As GridViewRow = DirectCast(ddl.NamingContainer, GridViewRow)
        '******************************
        '*Get the datakey for that row*
        '******************************
        Dim DataKey As String = GridView1.DataKeys(row.RowIndex).Values("IEN").ToString()
        '**********************
        '*Define Data Objects *
        '**********************
        Dim conn As SqlConnection
        Dim comm As SqlCommand

        '******************************************
        '*Read the connectionstring from we.config*
        '******************************************
        Dim ConnectionString As String = ConfigurationManager.ConnectionStrings("ER_BloodHoundConnectionString").ConnectionString
        '***********************
        '*Initialize Connection*
        '***********************
        conn = New SqlConnection(ConnectionString)
        '****************
        '*Create Command*
        '****************
        comm = New SqlCommand("UPDATE VW_Paitent SET provider=@provider WHERE IEN=@IEN", conn)
        '************************
        '*Add command Perameters*
        '************************
        comm.Parameters.Add("@Provider", System.Data.SqlDbType.NVarChar, 50)
        comm.Parameters("@Provider").Value = ddl.SelectedItem.Value

        comm.Parameters.Add("@IEN", System.Data.SqlDbType.Float)
        comm.Parameters("@IEN").Value = DataKey
        '*******************************************
        '*Enclose Database code in Try catch Finaly*
        '*******************************************
        Try
            '*********************
            '*Open the connection*
            '*********************
            conn.Open()
            '*********************
            '*Execute The command*
            '*********************
            comm.ExecuteNonQuery()
        Finally
            '**********************
            '*Close the connection*
            '**********************
            conn.Close()
        End Try
    End Sub

Thanks all. Problem solved. See previous post. Cool | :cool:

Hi all,
I am creating a xml file dynamically. If there is no data for a particuler tag then XMl file automatically close it like <test /> but i want to the tag in following format

<test> </test>
I am creating XML using following tag.

writer.WriteElementString("test","");

Can anybody please help me?

Regards
Rahul

People Laugh on me Because i am Different but i Laugh on them
Because they all are same.

I have a user control with a datagrid and few other information on
title and summary. I would like to render this control to an Excel file !

The problem is , as soon as i try to open the rendered xls file, Excel reports an error, that the file extension is not valid, and that it is not from a trusted resource.

Is there a way, i can remove this error ?

Any help , would be appreciated!

Thanks and Regards
G

Hi everyone,

Now i plan for my final year project but i not sure wat tilte i want to do. Any ideas?
I plan to do a web-based system.
I want to develop by Asp.net with C# and microsoft SQL server.

Any help is appriaciated!!!

Best regards,
Nasri

I believe the point is for you to come up with an idea. It's your project and as it's your final year you should have learned something in the previous years to give you an idea.

I know the language. I've read a book. - _Madmatt

Hi Nasri,

In final year project you need to think for both your best learning and maximum score you can achieve from the project.

If you want to develop web based project using ASP.NET and C# then my suggestion is to contact good company who can give you chance to develop project and provide you resources for the same. Like you can go for Financial projects and apply your maximum technical skill and functional knowledge and that will give you nice learning and good placement even.

If you required any technical guidance then surely ask to me..

I will do my best to help you...

Regards and all the best.

Nilesh Shah.

Nasri87 wrote:
i not sure wat tilte i want to do. Any ideas?

Try online Library tracking system. Include as many features as much possible based on time and knowledge.

You have to search Codeproject Article, here are many articles from them you can inspired for your final year project.

Gaurav Dudeja
http://www.gdinfotechindia.com

Dont be afraid of changing your life to better !

Dear all,

Thks a lot for sharing!!

best regards,
Nasri

Hi guys,
I have seen the following codes and i am having difficulty understanding it. Could you please teach me in a simpler way.

Thanks

public event Action<mycustomclass> PanelUpdated;

Which one of the four words are you having difficulty understanding?

netJP12L wrote:
a simpler way.

Simpler than what? This is simple.

I know the language. I've read a book. - _Madmatt

netJP12L wrote:
Could you please teach me in a simpler way.

I don't know if there is simpler way, but this[^] may help.

Yusuf
May I help you?

Hello,

i have one question regarding textbox update. What happens is i have used one textbox say txtbox1 and button btn1 in aspx page. And i have one usercontrol in ascx page. On the button btn click event, i am getting values from user contro to the txtbox1. And on the same button click, i am using that txtbox1 value to insert into the database. but Since its a same button click, though the value is showing in the txtbox1, it is not inserting into the database. So what can be the reason for that ? Is that because of not using postback thing or any other reason. I am using asp.net with sql server.

suchita

SayamiSuchi wrote:
Is that because of not using postback thing

What do you mean by this? Does this mean you are using AJAX to get value from usercontrol to textbox and then textbox to DB?

Whatever the case is, did you debug it? What did you got?

SayamiSuchi wrote:
On the button btn click event, i am getting values from user contro to the txtbox1. And on the same button click, i am using that txtbox1 value to insert into the database

Is it two client events working on the same button? If so, what is the order? Are they async? They need to be in order... synchronously.

Post a little code, if these doesnt help. The button click event part, the way you are binding the methods and whats in the menthod.

No error at all. Actually i have one user control in ascx page. And using that user control, i put that result in the textbox which is in aspx page. now the value which i am keeping from user control to that textbox is in button click event. now On the same button click, i am trying to use that textbox value for inserting into the database. but it is not sending that value to the database though once i click the button, that value is showing in that textbox. So just wondering is that because i didnt put the postback thing??

suchita

You need to be little more clear Suchita!

From what i got from your details, the flow should be:
1. Fill some value in Usercontrol ascx: ValueA
2. Press buttonA in ASPX parent page.
3. buttonA, brings ValueA in the textboxA of ASPX parent page
4. buttonA, send the ValueA in DB to store.

Now, if the sequence is right, they need to be SYNCHRONOUSLY, i.e. one after other.

Further, step 3 & 4 needs to be coded together in its handler. Add on if i missed something and also post a little part of your button click event.

you got it. But the problem is since the textbox is getting value and also textbox value is using for database in the same event, i think textbox value is not going to the database. But if i use the same thing in two events, its working fine. but i need that in a single event..

suchita