|
how to update data in textbox control after retrieving from database and also i want to know that how to use query string to get data from database in update mode.Please help me with one example with C#.net coding and asp.net coding.
rajiv
|
|
|
|
|
Google is the best answer.
|
|
|
|
|
//insert to database
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["connect"].ToString());
con.Open();
string empcode = txtempcode.Text;
string empname = txtEmpname.Text;
SqlCommand com = new SqlCommand();
com.Connection = con;
com.CommandText = "insert into ankemp values(@empcode,@empname)";
com.Parameters.Add("@empcode", empcode);
com.Parameters.Add("@empname", empname);
com.ExecuteNonQuery();
bindgrid();
//datasource to grid
void bindgrid()
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["connect"].ToString());
con.Open();
string query = "select * from ankemp";
SqlDataAdapter da = new SqlDataAdapter(query.ToString(), con);
DataTable dt = new DataTable();
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
//while clicking the fetch button in grid (in aspx page <commandname="fetch" commandargument="<%# Bind("empcode") >">
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "fetch")
{
int empcode = int.Parse(e.CommandArgument.ToString());
fetch(empcode);
}
}
//fetch method
public void fetch(int empcode)
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["connect"].ToString());
con.Open();
txtempcode.Text = empcode.ToString();
StringBuilder sb = new StringBuilder();
sb.Append(" select empname, ");
sb.Append(" from ankemp where empcode="+empcode);
SqlCommand com = new SqlCommand(sb.ToString(), con);
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
txtEmpname.Text = dr["empname"].ToString();
}
//update
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["connect"].ToString());
con.Open();
string empcode = txtempcode.Text;
string empname = txtEmpname.Text;
string update = "update ankemp set empname='" + empname + "'where empcode='" + empcode + "'";
SqlCommand cmd = new SqlCommand(update, con);
cmd.ExecuteNonQuery();
bindgrid();
con.Close();
//deleteing (in aspx page <commandname="delete">
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["connect"].ToString());
con.Open();
int i = e.RowIndex;
string empcode = GridView1.Rows[i].Cells[0].Text;
string del = "delete from ankemp where empcode='" + empcode + "'";
SqlCommand com = new SqlCommand(del, con);
com.ExecuteNonQuery();
bindgrid();
}
Padmanabhan
|
|
|
|
|
I have a problem with my ajax model pop up..When i use model pop up in master page it create issues..When i use the same master page and a tab container inside the master page at the time when the model popup get fired the data inside the tabcontainer did not get display pls give me a solution
Oopppzz!!!!!!!
|
|
|
|
|
Hi Libin,
The problem which I partly understood forced me to tell you that when the modal popup gets fired, I guess no postback event gets fired right? I guess you are showing the modal popup on client side events. if you have written the code to populate the gridview on server side then it will never be populated. There may be two work around for this. One is to show modal popup from cdoe-behind like ModalPopupExtender1.Show() and callthe gridviews' populate method, Second one would be to show the modal popup in client side and call the gridview's populate method asynchronusly.
Regards
Saanj
Either you love IT or leave IT...
|
|
|
|
|
hi guys,
i'm working on a project that requires d app 2 send SMSs. however, i have to call another page <www.biosmart-ng.com sendsms.aspx="">
pls how do i do this w/out redirecting from d original site?
He who goes for revenge must first dig two graves.
|
|
|
|
|
You going to redirect your user to other page in HTTPS environment right. Why dont you think webservices instead 2 send SMSs ?
|
|
|
|
|
I'm not actually doing the sending of SMSs. I'm utilising a service. And it requires me to send username, password, and other details to that page for the sms to be sent.
Ex: sendSMS.aspx?user=john;pass=0000;msg=Hello SMS
He who goes for revenge must first dig two graves.
|
|
|
|
|
You can send sms in your Application than going to sites. What you need is a Sms gateway. there are Some provider of this service see this
http://www.dotnetfunda.com/forums/thread552-how-to-send-sms-from-aspnet.aspx[^]
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
|
Cool
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
i'm trying to create a dynamic and auto refreshing web page in which there is a bar graph which is updated based on the data in a data base.
so i want a good graphics plugin for asp.net2.0.
i've seen the article here on "jqurey" and "Creating Dynamic Graphs in ASP.NET using GDI+" but i want another plugin. please help if u know one! plz ur help means a lot!
plz tell me which one to use. does flash work good for this? if so how can i use it & how can i get it free? thanks alot !!
|
|
|
|
|
antew wrote: i've seen the article here on "jqurey" and "Creating Dynamic Graphs in ASP.NET using GDI+" but i want another plugin.
why is that? Does the jQuery plugin not good enough for your problem? or is that does not solve it?
antew wrote: plz tell me which one to use. does flash work good for this?
May be, But as far as I know it is not free.
|
|
|
|
|
I want to use the login Controls on Users That are in My SQL Server database user table. How do I authenticate user based on the users table in SQL Server? I don't want to use Stored procedures also. I am using Linq to entity database.
Thanks.
|
|
|
|
|
|
I am making an editable Gridview and it gets filled with data. When I click my Edit button I have some textboxes that are populated with the "old" data. I type in "new" different data. I have a line of code like this:
TextBox txtUpdateHours = (TextBox)gvwDetails.Rows[e.RowIndex].FindControl("txtHours");
string newHours = txtUpdateHours.Text;
However the newHours variable is always the "old" value, not what I just typed in. How can I get the "new" value? I know it must be simple but I am trouble finding what I need. Thanks for any help.
|
|
|
|
|
rebind your grid data source after updating.
Padmanabhan
|
|
|
|
|
Thank you for the response. I'm not sure this will help my problem because it seems to be occuring *before* the update...I set breakpoints on the Update function and I can see it is updating with the original values, not what I just typed in the textbox. No matter what I type in the textbox it retains the original values from the data source and I'd like the Update to use what I just typed in. I'm not sure why it's doing this.
|
|
|
|
|
is your code placed within
if (!Page.IsPostback) ?
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
Yes that was it, thanks so much.
|
|
|
|
|
Hi guys I am currently working on a web application where people can fill out information in a timesheet, and then it will store that information on a database, and then send a link to it to payroll
by email.
This is the current code that I have
Dim msgs As New MailMessage
msgs.To = SupervisorEmailGet()
msgs.From = "Payroll@server.ca"
msgs.Subject = NameTextBox.Text & " Hours for " & Session("date")
msgs.BodyFormat = MailFormat.Text
msgs.Body = "Employee: " & NameTextBox.Text & ControlChars.NewLine & "Department: " & DepartmentDropDownList.SelectedItem.Text & _
ControlChars.NewLine & "Supervisor: " & SupervisorDropDownList.SelectedItem.Text & _
ControlChars.NewLine & "The supervisor of " & NameTextBox.Text & " has viewed their time sheet." & _
" You can view the employees hours at the website shown: http://ServerHostName/TimeSheet/NewTimeSheet.aspx?ID=" & intNewId
SmtpMail.SmtpServer = "smtp.bellnet.ca"
SmtpMail.Send(msgs)
msgs = Nothing
it works but the person I am working on it for wants the web app to open up their Microsoft Outlook 2007 with a new mail window(like a mailto , but wants the information filled in dynamically through the program. The reason why they want to have a mail window is just because outlook runs locally, or if the person filling out the timesheet needs to change the body of the email.
If anyone knows how to do that I would be happy or if you know how to get the code up top to run locally I would be more than satisfied with that.
modified on Wednesday, May 27, 2009 4:03 PM
|
|
|
|
|
Found it out Here it is for anyone else that wants to know.
Dim msgs As New MailMessage
msgs.To = SupervisorEmailGet()
msgs.From = "Payroll@server.ca"
msgs.Subject = NameTextBox.Text & " Hours for " & Session("date")
msgs.BodyFormat = MailFormat.Text
msgs.Body = "Employee: " & NameTextBox.Text & ControlChars.NewLine & "Department: " & DepartmentDropDownList.SelectedItem.Text & _
ControlChars.NewLine & "Supervisor: " & SupervisorDropDownList.SelectedItem.Text & _
ControlChars.NewLine & "The supervisor of " & NameTextBox.Text & " has viewed their time sheet." & _
" You can view the employees hours at the website shown: http://ServerHostName/TimeSheet/NewTimeSheet.aspx?ID=" & intNewId
SmtpMail.SmtpServer = "ServerHostName.smtpname.ca"
SmtpMail.Send(msgs)
msgs = Nothing
ServerHostName = the name of the server hosting the website.
smtpname = The smtp of the server. i.e. smtp.BELLNET.ca
|
|
|
|
|
Hi there,
I need to prevent possible db injection attacks, I have proper validation strings in the form to replace potentially harmful characters, however there seams to be something built into .NET that screams when it sees the angle bracket followed by the word "script" before it performs any validation or string replacement function. I know hackers use these errors to thier advantage, so how can I keep the site from breaking at all if someone attempts to use this tactic to inject my database? The only solution I can think of is to use a custom generic error page - that of course reveals no info - but the fact that an error occured does.
Any suggestions? - Thanks!
|
|
|
|
|
You may want to add a validateRequest="false" in the page directive to disable the validation, and use SQL parameters to prevent potential SQL injection.
Also, read about cross site scripting (XSS) while at it b/c your may be vulnerable to it too.
|
|
|
|
|
User Parameterized queries and stop assuming that the user is feeding your application the correct data. Look at this
Introduction to SQL Injection [^]
Hope it Helps
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|