Re: how to use Query string in asp.net - ASP.NET Discussion Boards

roguemat wrote:
but it doesnt appear to show how to do it without extentions?

It does. Did you see the example using UrlRewriter.net?

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Yes, thanks Smile | :)

.

[Message Deleted]

Firstly we don't work for you and Stop Using the words like "urgent" because you don't pay us to help you.

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/

In GridView1_RowUpdating event set a GridView1.SelectedIndex property with e.RowIndex.
So you can get the row id from that Smile | :)

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. Smile | :)

//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/

true if can go with payment systems, visit this ...![^]

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.

Yusuf
May I help you?

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.

ASP.NET Membership Provider for MySQL does not come with VS 2005/2008 by default.

Check the following links. It will help you to address your requirements.

http://forums.mysql.com/read.php?38,63403,63403[^]
Membership and Role providers for MySQL[^]

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.