|
Hi,
I have 3-4 textbox,dropdown controls.
I have to write query for all possibilities for searhing operation.
How can I do?
Thank you,
sjs
|
|
|
|
|
If each control represents a column in a database, then you could just take the text/selection from each control and put the data in the correct spot in the SQL query.
Eg,
SELECT * FROM tableName WHERE col1='textbox1 value' AND col2='dropdown1 value' ... and so on.
This way, you only really write one query, but it changes based on the selections that are made by the user.
Hope this helps,
Mitch
|
|
|
|
|
Hi,
I have to match each and every condition.If textbox empty and dropdown has value then dropdown value taken and setup the query.
Also and condition also check for searching.
Thank You,
sjs
|
|
|
|
|
Hello Friends,
I'm sending mails through following code given below but it throwing error...
I'm getting the following error
Could not access 'CDO.Message' object.
MailMessage mail=new MailMessage();
mail.To="mail@saamstesting.com";
mail.From=txtEmail.Text;
mail.Subject="Default Page";
mail.Priority=MailPriority.Normal;
mail.Body="Programme"+":-"+ddlProgramme.SelectedItem.Text+"\n"+"Name"+" :- "+txtName.Text+"\n"+"Review"+":-"+txtReview.Text;
try
{
SmtpMail.SmtpServer="127.0.01";
SmtpMail.Send(mail);
lblMsg1.Text="Record Saved Successfully";
lblMsg1.ForeColor=Color.Green;
}
catch(Exception ex)
{
//lblMsg1.Text="Error Occured!!";
lblMsg1.Text=ex.Message.ToString();
lblMsg1.ForeColor=Color.Red;
}
|
|
|
|
|
Hhttp://www.systemwebmail.com/faq/4.2.3.aspx
|
|
|
|
|
Thnxxxxxxxxxxxxxx.....................
|
|
|
|
|
Hello frnd
I displayed database(student marklist) value in data grid,if i click the cell value(like roll number) i want to display all the detail about that cell(roll number,mark,name) in text box.I am new for asp.net plz any one give come sample coding for this.I am using ASP.net 1.1
|
|
|
|
|
I can give you some idea  not code.
while select one row, use GridviewRow class and and read the row of corrosponding selected index and then use can use textbox1.text=GR.column[0].text like that
Try this concept it will work
|
|
|
|
|
thank u for replay.
frnd i have one doubt how to find selected row? and how to write onclick event for data grid?
|
|
|
|
|
hi,
insert Select column (checkbox)as the first column in ur datagrid, so it will be at begining of each row,
if it is checked means selectd nd u can progress further
write a bool func isChecked(){}
try it ll definately work
i m faisal
|
|
|
|
|
Hi,
Please anybody give me a good method for handling session timeout...i mean after session time out user will redirect to some pages...
regards
alex.
|
|
|
|
|
use can use it inside web.config
|
|
|
|
|
Hi,
I didn't get correctly..can you pls tell me little bit clearly...
thanks Alex.
|
|
|
|
|
Global.ASAX?
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
Hi,
I have uploaded a image with some data in a reg. from. so datas are going to the respective table and images are going to the respective folder,
now i want to retrive that folder images in separate form, can u pls help me...
krishna
|
|
|
|
|
|
Thanx for ur information... i will check and get u back.
krishna
|
|
|
|
|
Iam using mssql, its support?
krishna
|
|
|
|
|
I have involved in developing my first Ajax .Net project and after nearly completing the project we have been testing performance of our application. We have found that the Ajax RoundedCornersExtender has a serious effect on the performance of our application and we improved query results from 4-5 seconds to less than a second by taking it out.
Thanks to firebug we isolated this. I really wish the toolkit controls where thoroughly tested before release.
Anyway, just thought I would share.
Jared
|
|
|
|
|
I have a master page that contains a simple table. There is probably a 10 pixel space between both the top and left sides of the screen. How do I remove this spacing?
I have tried div and table padding spacing? Any other suggestions?
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
Found it, I needed to set the style on the body tag. Thought about that about 5 seconds after posting.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
hi everyone
i am desighning a global application in which i need to create a module of country-state and city module but i am having trouble
For example
http://msn.careerbuilder.com/jobseeker/resumes/postresumenew/postresumestart.aspx
If u just give any name and some text in covernote the next step will give u example of what i want and this can help me and many others...because with others i can cope with but with united kingdom post code its different story
|
|
|
|
|
This is a public site, most everything is of use to more than just one person
Are you asking how to create a dropdown with states and counties ?
only two letters away from being an asset
|
|
|
|
|
yes please but like it mathces to address for every country and good concept of storing that in sql database with search aspects
|
|
|
|
|
Hi, I am making an ASP.NET site with a menu on the side. The menu items are loaded from a database, and the items themselves are hyperlinks(at the moment) created dynamically for each item it finds in the database.
But how do I make the links work? I could just set the URL of it but I am just redirecting to the same page. When that page loads I want it to be able to tell what they just clicked(or if they just came to the site) and generate the content from there.
So I though maybe I could use sessions and then when the page loads it just checks the session with a couply if statements. Will this work? And if so, how do I do it? I have tried many different ways, but no matter what I try I cannot find a way to make a hyperlink do anything onclick besides going to its url.
Please help me, or if you have a better idea(which im sure you will, im new to this) them please share. Much appreciated.
Regards
Matt
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
