|
* 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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
SayamiSuchi wrote: i think textbox value is not going to the database
For that, please share the event code! Once you get the value in ASPX, you should be able to save it.
|
|
|
|
|
protected void btnSubmit_Click(object sender, EventArgs e)
{
WriteThisMessageToThePage1.sendMessageToThePage += delegate(string message){txtNeededDate.Text = message; };
WriteThisMessageToThePage2.sendMessageToThePage += delegate(string message){txtRequestDate.Text = message; };
cmd = new SqlCommand("INSERT INTO ProjectRequestInfo(ClientFName,ClientMName,ClientLName,Email,Extension,DepartmentName,ProjectTitle,ProjectDescription,DueDate,RequestDate,IntendedUsersAudience,SubmittedDate,NotificationTo) values('" + txtFirstName.Text + "','" + txtMiddleName.Text + "','" + txtLastName.Text + "','" + txtEmail.Text + "','" + txtExtension.Text + "','" + DrpDwnDepartmentList.SelectedItem.ToString() + "','" + txtProjectTitle.Text + "','" + txtProjectDescription.Text + "','" + txtNeededDate.Text + "','" + txtRequestDate.Text + "','" + txtIntendedUsers.Text + "','" + System.DateTime.Now.ToShortDateString() + "','" + getHighCnt + "')", conn);
conn.Open();
cmd.ExecuteNonQuery();
}
here i am getting value for txtNeededDate.text from message(i.e from usercontrol) and i am inserting the txtNeededDate.text to the database like that. It is not giving any error but it is not inserting value to database.
suchita
|
|
|
|
|
Could you just try putting a little delay after first two lines, before inserting in SQL?
like a dummy loop of 10,000 or so.
Or in debug mode, just put a breakpoint at cmd line and check what is the value of txtNeededDate.
|
|
|
|
|
Dummy loop is also not working...
suchita
|
|
|
|
|
From your code, there does not seem any problem.
One suggestion, yo could've public property in your usercontrol which gives the value that you want to update in textbox and use that property. This is cleaner and simple approach.
Debug your code and see where the problem lies.
Using the textbox to insert the data in DB should not be a problem. Also try using a local variable assign this first, then use this to insert in DB, might be you get the problem.
|
|
|
|
|
I tried using local variable too but the same problem...
suchita
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
