|
Hello everyone........
I am here stuck with problem......
I can search one string from database.........
but cannot search multiple strings from databse........
I am coding in ASP using MS Access
more clearly.........
if one of the record contain name as " david hussey"
and another record contain name as " micheal Miller"
and when I input only "david" or any word I find positive result.....
But If i put "David miller" ,i get no results.........
please tell how to code..........
or what SQL statememt to choose
kundan
ph4ufree@yahoo.co.in
|
|
|
|
|
you could search if the string is LIKE '%david%' OR the string is LIKE '%miller%'
This question belongs in the SQL forum, BTW
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi
I'm using Visual web developer 2005 with Sql server express 2005 edition. I'm not able to connect to Sql server express 2005 although I'm able to connect to the same using oSql command line utility. I get the following error using the Visual web developer.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I tried searching on the Ineternet for the same and applied with different combinations but problem persists. Please advise
Thanks in advance!
Don't Quit
|
|
|
|
|
If you have enabled remote connections, this is probably firewall which is blocking the connections.
|
|
|
|
|
N a v a n e e t h wrote: If you have enabled remote connections, this is probably firewall which is blocking the connections.
Hi, Firstly both visual web dev and Sql server express 2005 are on same system. Secondly Firewall is turned off.
Any clues????? 
Thanks
Don't Quit
|
|
|
|
|
I have this login page that when a user is authenticated s/he is directed to the main page.The problem is that only Mozilla Firefox actually takes the user to that main page.Internet explorer always take the user back to the login page even when the user is a valid user.I just don't what or why it is so.
The web.config part..
<authorization>
<allow users="?" />
</authorization>
<authentication mode="Forms">
<forms name=".ASPXAUTH" protection="All" timeout="60" loginurl="PerformanceLogon.aspx" slidingexpiration="true" />
</authentication>
<trace enabled="false" requestlimit="10" pageoutput="false" tracemode="SortByTime" localonly="true" />
<sessionstate mode="InProc" stateconnectionstring="tcpip=127.0.0.1:42424" sqlconnectionstring="data source=127.0.0.1;Trusted_Connection=yes">
cookieless="false" timeout="20" />
</sessionstate>
The code behind..
modified on Monday, June 16, 2008 3:49 AM
|
|
|
|
|
what namespace I should add with using system.classname
for Literalcontrol in asp.net with c#
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|
|
Just drag and drop from the toolbox. It comes in System.Web.UI.WebControls though.
|
|
|
|
|
You use the toolbox ?
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Yes. I felt it's easy than typing the markup. Don't you use toolbox ?
|
|
|
|
|
Never. I always type the markup, b/c the design view in VS2002/2003 was a nightmare, and I just got used to doing it by hand.
Plus the design view generates a lot of css that I don't want auto generated for me.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Christian Graus wrote: Plus the design view generates a lot of css that I don't want auto generated for me.
I agree. Typing markup gives more control than the designer. I guess auto CSS generation can be controlled, right ? When I add some tables, I used to disable the auto CSS generation, so it just generates the tags.
|
|
|
|
|
Fair enough, I abandoned the designer before I investigated those sort of options. 
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
dynamically created below 2 buttons coming in single row I want second button in next row.
Button btnPayment = new Button();
btnPayment.Text = "Payment";
btnPayment.ID = "0";
string s = "<br />";
Button btnPayment1 = new Button();
btnPayment1.Text = "Payment";
btnPayment1.ID = "1";
btnPayment.Visible = true;
btnPayment1.Visible = true;
divButtons.Controls.Add(btnPayment);
divButtons.Controls.Add(btnPayment1);
btnPayment.CommandArgument = "1";
btnPayment.Command += new CommandEventHandler(btnPayment_Click);
btnPayment1.CommandArgument = "2";
btnPayment1.Command += new CommandEventHandler(btnPayment_Click);
You get the best out of others when you give the best of yourself.
|
|
|
|
|
put a literal BR between them, or otherwise seperate them in the HTML.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hello friends,
I am using built in controls for membership. I got this error when I run the code for passwordrecovery..
what could be the cause and the possible solution?
error is
The SMTP host was not specified.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: The SMTP host was not specified.
Amit
|
|
|
|
|
The cause is that you didn't specify an SMTP host, and so an email can't be sent. Specify a valid SMTP host.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Thanks,
I mention the smtp host name. The error is changed now to
" Mailbox unavailable. The server response was: 5.7.1 Unable to relay for iamdking@rediffmail.com"
where iamdking@rediffmail.com is the mail address of the recipient...
What could be the solution for this?
Thanks in advance,
Amit
|
|
|
|
|
hai friends
in a page i have a button "close"
when i click this button
then i should get a confirmation dialog box
with "ok" and "cancel" or with "yes" and "no"
if press "ok" then the user is redirected to "HomePage.aspx"
else the same is refreshed
plz help me....
thanks in advance
vijay
|
|
|
|
|
This is a basic javascript task. Your button has OnClick, it also has OnClientClick. OnClientClick points to a javascript function, if this returns true, OnClick is called. This sounds like you can do it all on the client in JS tho.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
what is the difference between events and function
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
Do you have any sort of source materials yourself, such as books ? You should get some.
An event is just a method, but it's also a delegate, which is basically a pointer/reference to a method. This means a method is specified as a paremeter, in code, and whatever method(s) you specify are called when that event fires. So, you can write a function, and it's a function. If you write a function with the signature of an event, and attach it to an event, then the event mechanism is used to associate that function being called with that event firing.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
|
req.GetRequestStream().Length' threw an exception of type 'System.NotSupportedException'
I'm getting this error while implementing paypal payment process.
when control going to this statement in asp.net page after coming back from payment process completion.
StreamReader streamIn = new StreamReader(req.GetResponse().GetResponseStream());
code:
string strSandbox = "https://www.sandbox.paypal.com/cgi-bin/webscr";
//string strLive = "https://www.paypal.com/cgi-bin/webscr";
HttpWebRequest req = (HttpWebRequest)WebRequest.Create(strSandbox);
req.Method = "POST";
req.ContentType = "application/x-www-form-urlencoded";
byte[] param = Request.BinaryRead(HttpContext.Current.Request.ContentLength);
string strRequest = Encoding.ASCII.GetString(param);
strRequest += "&cmd=_notify-validate";
if (strRequest != "&cmd=_notify-validate")
{
req.ContentLength = strRequest.Length;
//Send the request to PayPal and get the response
StreamWriter streamOut = new StreamWriter(req.GetRequestStream(), System.Text.Encoding.ASCII);
streamOut.Write(strRequest);
streamOut.Close();
//ERROR in below 2 statements some time ---right now not coming
StreamReader streamIn = new StreamReader(req.GetResponse().GetResponseStream());
string strResponse = streamIn.ReadToEnd();
streamIn.Close();
You get the best out of others when you give the best of yourself.
|
|
|
|
|
hai friends
how to get/set listwidth of dropdownlist in asp.net
dropdownlist is single selection option
does there is a property listwidth for this
thanks in advance
vijay
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
