|
hi
I h've created one sql table with a column "image data type". I want to retrive it and want to send this as an attachment using SendSMTPMail. Can anyone tell me , how to retrieve the image type from Sql server
thanks in advance
|
|
|
|
|
I am not cler with ur requirements.
what i had done is , while uploading the file i fetched the file extension using the fileinfo class. and stores it in database.
Hello Forum
Always be in touch to help about the topic ASP.NET
|
|
|
|
|
Hi...
Friends.
I want to get the length of multiple uploaded file from http header in asp.net ?
Do you have any solution or suggestions for that ?
Thanks in advance.
Regards,
Abhi
|
|
|
|
|
U have to controll this logically at ur end.
what i get in mind to store size of every file on one variable and get updated every time the file is uploaded to upstaging server.
Hello Forum
Always be in touch to help about the topic ASP.NET
|
|
|
|
|
Sorry, I can't get you !!
Can you please explain me this pardon !!
Thanks..
Regards,
Abhi
|
|
|
|
|
|
i was using the stored procedure , there i am usiong the two queries
select * from tablename
select is from table where name='name'
for that i am using the following code.
SqlConnection con;
con = new SqlConnection("database=db`;user id=sa;pwd=sa;server=localhost");
con.Open();
SqlCommand cmd;
SqlDataAdapter ad;
ad = new SqlDataAdapter("abc", con);
DataSet ds;
ds = new DataSet();
ad.Fill(ds);
if i use the select * form table queryt then the above code is working vey fine.
if i use both the queries , then the above cod eis not working.
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
Hi sonia, well nice to see u again in problem ha ha ha , kidding ok.
So can u plz specify what exact is ur requirement and what u need to do.
i am not clear abt what u r asking.
Regards
sulabh
Hello Forum
Always be in touch to help about the topic ASP.NET
|
|
|
|
|
If you have sql statements directly in your sqlcommand, it is expecting only one result set to return. If you are calling a stored procedure, which I think you are, then you can return multiple result sets. The down side is that .net version 1.1 doesn't handle multiple result sets. They only added that to .net 2.0. So if you are using .net 1.1 you will have to call the stored procedure. Then call another one to get the second result set.
Ben
|
|
|
|
|
Sonia Gupta wrote: con = new SqlConnection("database=db`;user id=sa;pwd=sa;server=localhost");
Connection String Syntax error...
Regards John
|
|
|
|
|
Hi,
Try this.
SqlConnection con;
con = new SqlConnection("database=db`;user id=sa;pwd=sa;server=localhost");
con.Open();
SqlCommand cmd;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "abc"; // Assuming abc is ur sp name;
cmd.Connection = con;
SqlDataAdapter ad = new SqlAdapter(cmd);
DataSet ds = new DataSet();
ad.Fill(ds);
Let me know if it works.
Laddie
|
|
|
|
|
I have a question how to abandon a session when user right clicks on task bar and selects close. I know how to abandon session in the case of user presses alt+ F4.
Share ur ideas with me
Thanks in advance,
surya
-- modified at 8:57 Wednesday 22nd August, 2007
|
|
|
|
|
I think as user closes the browser whether from taskbar or Alt+F4, the session automatically get expires.
Also u can do session null at global file with event Application_onStart
Hello Forum
Always be in touch to help about the topic ASP.NET
|
|
|
|
|
sulabh2020 wrote: I think as user closes the browser whether from taskbar or Alt+F4, the session automatically get expires.
No it won't be expired when user closes browser
|
|
|
|
|
When the browser is closed the session does not end. The session will only end if you end it, based off a user clicking logout or something like that. Or when the session times out. The default timeout is 20 minutes.
Ben
|
|
|
|
|
|
i have a database of lists of subjects...then in my module, i want to display all the subjects that i recorded in the listbox...
how can i do it? i already connect my dataset in the connection wizard but i can't display it in the listbox.
|
|
|
|
|
use the following coding...
String sql = "SELECT Category Name FROM Categories";
OleDbConnection con = new OleDbConnection(connectionString);
OleDbCommand cmd = new OleDbCommand(sql,con);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataTable dt =new DataTable();
con.Open();
da.Fill(dt);
ListBox1.DataSource = dt;
ListBox1.DataBind();
|
|
|
|
|
how can i declared all the variables there?
will i put in form_load or in listbox1_SelectedIndexChanged???
|
|
|
|
|
hi all
i'm new for ASP .Net(c#) i'm developeing a web application in that i've to get informations from user then i've to genarte the aroschope for the user by using third party aroscope generaters then i've to display the aroscope details in my web page.the entier process(aroscope generating) is happenning in background then detail will be display in web page
any idea about this please give some solution.
regards
balraj thoma
|
|
|
|
|
What is an aroschope ? I assume it comes out as a bitmap, you'd just show it as a bitmap, either in an img tag, or by pushing the data into a response, and showing just the image in a window.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Did you mean horoscope?? Even google was stumped.....
SG
|
|
|
|
|
I have created one web application.If I am clicking on browser Refresh button then it is showing one message "The page can't be refreshed without resending the information" with 2 buttons "Retry" and "Cancel".When I click on Retry button the previous events are fired.
Is there any way to change/check this behaviour.
Thanks.
satyaki mishra
|
|
|
|
|
Yes. If you write your app so that any postback redirects to a new page ( which can be done by taking the data that needs to be passed and putting it on the URL ), then there's never a refresh that does a postback, it will just show the new page, and so you will never see this message.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
But thing is that after post back it has to come to same page.scenario is like this..In the grid i am showing all the pending users.Admin selects "approve request" or "reject request" from the drop downlist that is kept inside the grid and click on a Button.Then the application will send a mail to the user and it will load the same page.
so whenever I am clicking on Refresh button the previous event is fired.
satyaki mishra
|
|
|
|