|
pranu_13 wrote: and stays in a waiting state.
looks like you have an infinite loop. Have you tried stepping into the code?
|
|
|
|
|
change you browser with "browse with" and try again, this problem may be exception on your browser.
Human knowledge belongs to the world
|
|
|
|
|
That did not work. i just added a button and label in the application. No other code. Interesting is when i replaced localhost with IP address it works. It does not work with localhost.
|
|
|
|
|
I have a table which name is login & contain 3 columns. Such as: Name,password & code. In code column contains the table name. eg: table1,table2 so on.
And I also create the table of same name as mentioned in code column which is mentioned above.
My requirement is that I insert the value in table1 or table2. but in insert query I want to put the table name from the code column.
I use following two methods but it didn’t work::
string code = " select code from login where user_name= name";
da = new SqlDataAdapter(code, con);
string s = da.Fill(ds, "c");
string time = " insert into '"+s+"' values (getdate(),getdate())";
da = new SqlDataAdapter(time, con);
da.Fill(ds, "b");
------------OR-------------
string code = " select code from login where user_name = name'";
string time = " insert into '"+code+"' values (getdate(),getdate())";
da = new SqlDataAdapter(time, con);
da.Fill(ds, "b");
thanks in advance
|
|
|
|
|
Your code is broken.
ahmad25 wrote: string s = da.Fill(ds, "c");
SqlDataAdapter.Fill is not returning string.
ahmad25 wrote: string time = " insert into '"+s+"' values (getdate(),getdate())";
You are not taking value from the filled dataset.
Try this
string code = "select code from login where user_name= name";
string s;
using(SqlCommand command = new SqlCommand(code,con)){
con.Open();
s = (string)command.ExecuteScalar();
con.Close();
}
string time = " insert into [" + s +"] values (getdate(),getdate())";
|
|
|
|
|
hii!
Thanks a lot to Mr. Navneeth. you r really solved my problem.
I have one more problem. In above program I fetch only one value from a column. if I want to fetch a entire row what can I do?
thanks again
|
|
|
|
|
ahmad25 wrote: I fetch only one value from a column. if I want to fetch a entire row what can I do?
ExecuteScalar can return only a single column. Use ExecuteReader instead. Take it to a SqlDataReader instance.
|
|
|
|
|
Hi,
If in login table you told that value is like table1,table2 etc. After retriving data from that column you directly inserted in insert query I don't think so you can insert data more that one table at a time. As per your code you are trying to write this query
insert into table1,table2 values ('1','1');
It will generate error. Am I right?
Other wise after retriving that data split it with , then loop and fire insert query.
Just reply am I write with above query. And also describe the error message perfactly.
http://techiefromsurat.blogspot.com
|
|
|
|
|
Hi!
Thanks for your reply. but i think you do not understand my question.
it is right that we can't insert data at a time more than one table.
Mr. Navneeth give me a right query.
Thanx
|
|
|
|
|
how to create more than one excel sheet on button click in asp.net and C#?
|
|
|
|
|
vikas2727 wrote: how to create more than one excel sheet on button click in asp.net and C#?
Probably in a loop 
|
|
|
|
|
hi all, I am learning to send an email frm my website using system.net.mail. The mail is sent and there is no error but the recipient doesn't recieve the mail but it is shown in Inetpub\mailroot\queue and after sometime delivery is failed.
Plz help me.Where I am wrong ?? Any specific setting for this??
//variables
string strFromEmail = tbxFrom.Text;
string strToEmail = tbxTo.Text;
string strSubject = tbxSubject.Text;
string strMsg = ftbMsg.Text;
string strHostName = "mail.gmail.com";
int iHostSMTPPort=25;
//string strImagePath;
//variable to create message instace
MailAddress mailAddrFrom = new MailAddress(strFromEmail);
MailAddress mailAddrTo = new MailAddress(strToEmail);
MailMessage msgObj = new MailMessage(mailAddrFrom,mailAddrTo);
//definitions to send mail
SmtpClient smtpObj = new SmtpClient(strHostName, iHostSMTPPort);
//settings to send email
msgObj.Subject = strSubject;
msgObj.Body = strMsg;
msgObj.IsBodyHtml = true;
smtpObj.DeliveryMethod = SmtpDeliveryMethod.PickupDirectoryFromIis;
//sending email
smtpObj.Send(msgObj);
|
|
|
|
|
Does your SMTP server Configure properly?
|
|
|
|
|
I don't know. It works fine when I send email from my gmail account.but fails when I use any other domaim.I use server smtp.gmail.com
Thanks for ur response.
|
|
|
|
|
You can not use smtp.gmail.com you have to use mail.yourdomainname.com. and if you are sending from local system then use localhost or 127.0.0.1
I hope it will help you.
http://techiefromsurat.blogspot.com
|
|
|
|
|
joindotnet wrote: Inetpub\mailroot\queue
Your SMTP server might be stopped. Type inetmgr in the "Run" window, Click on "Default SMTP server" and start it.
|
|
|
|
|
It is not stopped.I have checked it.I can send emails from gmail to gmail if I use smtp.gmail.com host server.
How can I send mail from any domain to any domain.
Plz help.I'd be obliged.
|
|
|
|
|
i see many people had posted this problem. can some one please help.
i have a user control with asp:label on it. the label loses its text on postback
it is now a whole month i am trying to find a work around but no success.
|
|
|
|
|
hassanmohamed wrote: i see many people had posted this problem.
Did they get any answers?
hassanmohamed wrote: it is now a whole month i am trying to find a work around but no success.
That's sad, man.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Are you re-binding the control every time you postback? Where are you setting the text? Can you post a few (smallish) code snippets.
|
|
|
|
|
Looks like you are adding label dynamically. ASP.NET won't maintain viewstate for dynamic controls created after viewstate is loaded.
|
|
|
|
|
Check your label for following scenarios :
1. Is the property EnableViewState is set to false for the label control or its parent control
2. Is the control is being dynamically added to your page. if yes recreate the control on "Init"
3. Binding a "Null" or "Empty" value to label on postbacks
|
|
|
|
|
(I asked this question in C# sub-forum, but according to the discussion with others, I post the question here. Thanks for understanding.)
Hello everyone,
If my ASP.Net page returns both response Http headers and redirection to client's Http request, my question is when client follows the redirection instruction to access the redirection destination URL, will the client automatically include the response Http headers into the further Http request headers to follow-up redirection or not? Is it a standard to follow to include the previous Http response headers to redirection Http request headers by client or optional?
(my current confusion is I want client to redirect to some other URL and also include current Http response headers to the redirection URL request headers, but I am not sure whether all clients could follow this way.)
BTW: clients I mean browsers.
thanks in advance,
George
|
|
|
|
|
cant get ur question.
Thanks
(with regards)
B.Balachandhar
|
|
|
|
|
Thanks Balachandhar,
My question is like this,
1. browser send http request to server, server response with redirection to another URL and also include some response http headers;
2. browser will then follow the redirection URL to send http request.
my question is in step 2, will the browser send the response http headers (received in step 1) as http request header to the redirection URL? Is it a must or not ensured all kinds of browsers will follow up to send the response http headers (received in step 1) as http request header to the redirection URL?
regards,
George
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
