|
SELECT * FROM ATable WHERE CLIENTNAME LIKE '%searchtext%'
|
|
|
|
|
Sorry, i don't quite get you. Do you want to search a dataset?
|
|
|
|
|
hi all,
I have a Dropdown box(Active/Inactive) in Asp updateform.If the user selects Inactive and updates the form,then SP gives an output message that Inactive is selected.
Here i need to keep an confirm box using java script.This should be called only when Inactive is selected.
So i wrote code like this
<br />
protected void FormView1_ItemUpdating(object sender, FormViewUpdateEventArgs e)<br />
{<br />
if (myCommand_update.Parameters["@out_Message"].Value != DBNull.Value)<br />
{<br />
Status_Msg.Text = Convert.ToString(myCommand_update.Parameters["@out_Message"].Value);<br />
update_btn.Attributes.Add("onclick","return confirm_update();") <br />
<br />
<br />
}<br />
}<br />
function confirm_update()<br />
{<br />
if (confirm("Would you like to Inactive the same?")==true)<br />
return true;<br />
else<br />
return false;<br />
}<br />
<br />
<br />
but it is not working.
If active is selected there will be no ouput meaasge.
Plz help me to find the solution
Thanks in advance,
cheers
sangeet
|
|
|
|
|
try running your code like this first,
function confirm_update()
{
alert('hello');
}
in this way you can be sure that your function is being called or not. if you see pop up saying 'hello' then there would be something wrong with your code which this,
function confirm_update()
{
if (confirm("Would you like to Inactive the same?")==true)
return true;
else
return false;
}
|
|
|
|
|
Hi all,
I have a web site where i have a login section that uses password written(encrypted) in an sql server.
I want to add financial part to my web site, where only authorized people can buy or whatever.
My question is about the best way to secure my users and their info presenting while doing their inquiries.
Thanks.
|
|
|
|
|
Hi All...
My friend has Visual Studio 2003 and also Visual Studio 2005 installed in her system.
Whenever she has to work with VS-2003, she will change the IIS to point the .Net framework 1.1 version and switches to .Net 2.0 when she works with VS-2005 and also she is telling that she has both the framework.
What I thought was, to work with both VS-2003 and 2005, it is enough to have .Net framework 2.0 and this 2.0 will have all the features supported by 1.0 and 1.1. We dont install .Net 2.0 as seperate one and only upgrade 1.1 to 2.0. So no need to change the framework.
I dont understand why she changes her IIS every time.
But I dont change IIS. I just work with both VS-2003 and VS-2005 at a same time.
How is it possible?
Wht is the concept behind this .Net Framework different versions?
Am I making sense?
Hope I narrated in a way you can understand.
Expecting your explanations for this dbt.
Thank You,
Saran
|
|
|
|
|
Saranya B wrote: What I thought was, to work with both VS-2003 and 2005, it is enough to have .Net framework 2.0 and this 2.0 will have all the features supported by 1.0 and 1.1. We dont install .Net 2.0 as seperate one and only upgrade 1.1 to 2.0. So no need to change the framework.
Yes you are correct.
Saranya B wrote: I dont understand why she changes her IIS every time.
She don't have any other work to do 
Saranya B wrote: But I dont change IIS. I just work with both VS-2003 and VS-2005 at a same time.
How is it possible?
Because framework 2.0 can support all the libraries available in 1.1. Updating a version means, they won't remove the previous classes. 2.0 is having much more classes than 1.0. Now 3.0 is there. That can support all the classes available in 1.1 as well as 2.0. Hope you understood
|
|
|
|
|
|
DooDooo wrote: Saranya B wrote:
What I thought was, to work with both VS-2003 and 2005, it is enough to have .Net framework 2.0 and this 2.0 will have all the features supported by 1.0 and 1.1. We dont install .Net 2.0 as seperate one and only upgrade 1.1 to 2.0. So no need to change the framework.
Yes you are correct.
DooDooo wrote: Because framework 2.0 can support all the libraries available in 1.1. Updating a version means, they won't remove the previous classes. 2.0 is having much more classes than 1.0. Now 3.0 is there. That can support all the classes available in 1.1 as well as 2.0. Hope you understood
Close, but not quite - there are some pretty major differences between the versions, as my boss would tell you if he were here - he spent an age porting our app to 2.0 hehe
"Knock me down, I'll get straight back up again, I'll come back stronger than a powered up pacman"
(Lilly Allen / Kaiser Chiefs)
|
|
|
|
|
VS 2005 has a built in stand-alone web server, so it doesn't need IIS. You can use IIS for 1.1 applications and the stand-alone server for 2.0 applications.
Saranya B wrote: We dont install .Net 2.0 as seperate one and only upgrade 1.1 to 2.0.
There is no "upgrade" from 1.1 to 2.0. When you install 2.0 on a system that already has 1.1, they will both be available side byte side.
Saranya B wrote: I dont understand why she changes her IIS every time.
Me neither.
Saranya B wrote: But I dont change IIS. I just work with both VS-2003 and VS-2005 at a same time.
How is it possible?
My guess is that you are using the stand-alone server in VS 2005.
---
single minded; short sighted; long gone;
|
|
|
|
|
Thanks for you explanation!!!
Guffa wrote: There is no "upgrade" from 1.1 to 2.0. When you install 2.0 on a system that already has 1.1, they will both be available side byte side.
So, do you mean when we install .net framework 2.0, there will be 2 instances. One with 1.1(which exist already) and another instance with 2.0 version?
Can I take your explanation in this way?
|
|
|
|
|
|
Yes.
---
single minded; short sighted; long gone;
|
|
|
|
|
Error 2 Base class 'System.MarshalByRefObject' specified for class 'RemotableType' cannot be different from the base class 'System.Windows.Forms.Form' of one of its other partial types. C:\Documents and Settings\050661M.SITEI\Desktop\remoting\WindowsApplication1\WindowsApplication1\RemotableType.vb 4 14 WindowsApplication1
the above is the error i get when trying to inherite the 'System.MarshalByRefObject' for remoting by referencing from
[^]
anybody knows y?
|
|
|
|
|
Hi,
I am working in a Asp.Net Project in which i have to import an Excel sheet datas into a mysql database table and then i want to retrieve those datas into my dotnet application. pls note that i don't use any datagrid in my application. i just designed tables in my Form and get datas in text boxes. i'm new in using mysql database and i already worked in sql server. in sql we have import option and i don't find any of that option in mysql. i'm totally confused in how to import those datas into my database as there are some 50 rows in my excel sheet. I heard that we can extract those datas to database using C# code. pls provide me with a proper solution as i'm new to this concept and i'm struggling with this for the past 3 days(pls note that i don't need any tool to be used for exporting datas as no such tools will be provided for me).
Thanks in Advance
Vijay.
|
|
|
|
|
//-------------------------------------------
//To Extract data from excel sheet and store it in Dataset.
private DataSet PerformQueryIntoDataSet(string strFileName,string sheetName)
{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strFileName + ";" + "Extended Properties=" + Convert.ToChar(34).ToString() + "Excel 8.0;HDR=NO; IMEX=1;" + Convert.ToChar(34).ToString();
//You must use the $ after the object you reference in the spreadsheet
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM ["+ sheetName + "$]", strConn);
DataSet myData = new DataSet();
myCommand.Fill(myData, sheetName);
return myData;
}
//-------------------------------------------
//To get number of records in the sheet
[Datasetname].Tables["<sheet name="">"].Rows.Count;
//To extract data from table in dataset.
DataRow RowName = (DataRow)[Datasetname].Tables["<sheet name="">"].Select().GetValue(rowIndex);
string strValue = RowName[0].ToString().ToUpper().Trim();
//Then check for validation and store it in Database.
There's never a Wronge Time To Do The Right Thing !!
|
|
|
|
|
I have tried webclient class uploadfile method to upload files to server as,
Dim fs As New WebClient
Dim retValue As Byte()
retValue = fs.UploadFile("http:\\<somesrc>\srcfile", "POST", "c:\srcfile")
I got exception as,
The remote server returned an error: (401) Unauthorized.
Let me know how to solve this error, and upload files to server using webclient.
Be simple and Be sample.
|
|
|
|
|
Check ASP.NET is having write permission on c:\srcfile ? Try server.mappath for the server directory
|
|
|
|
|
when i am sending mail to a person whose domain is same like the domain name i have mentioned in the smtpserver it is sending correctly.but if i will send to a person who has a yahoo email id it's not sending it's showing an error like this
Server Error in '/' Application.
--------------------------------------------------------------------------------
The server rejected one or more recipient addresses. The server response was: 503 This mail server requires authentication when attempting to send to a non-local e-mail address. Please check your mail client settings or contact your administrator to verify that the domain or address is defined for this server.
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.Runtime.InteropServices.COMException: The server rejected one or more recipient addresses. The server response was: 503 This mail server requires authentication when attempting to send to a non-local e-mail address. Please check your mail client settings or contact your administrator to verify that the domain or address is defined for this server.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[COMException (0x8004020f): The server rejected one or more recipient addresses. The server response was: 503 This mail server requires authentication when attempting to send to a non-local e-mail address. Please check your mail client settings or contact your administrator to verify that the domain or address is defined for this server.
]
[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters) +0
System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams) +2500080
System.Web.Mail.LateBoundAccessHelper.CallMethod(Object obj, String methodName, Object[] args) +72
[HttpException (0x80004005): The server rejected one or more recipient addresses. The server response was: 503 This mail server requires authentication when attempting to send to a non-local e-mail address. Please check your mail client settings or contact your administrator to verify that the domain or address is defined for this server.
]
System.Web.Mail.LateBoundAccessHelper.CallMethod(Object obj, String methodName, Object[] args) +119
System.Web.Mail.CdoSysHelper.Send(MailMessage message) +2684
System.Web.Mail.SmtpMail.Send(MailMessage message) +131
GEthermometrics_Inquiryform.Inquiryform1.btnsendrequest_Click(Object sender, EventArgs e) in inquiryform.aspx.cs:162
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
can anyone help me.it's urgent
|
|
|
|
|
What about posting some sample code ?
|
|
|
|
|
Hi,
I need to upload all files from the given client's physical folder path to server path.
How do I upload all files to web server path without using "file" type.
Rams.
Be simple and Be sample.
|
|
|
|
|
ramskr wrote: web server path without using "file" type.
But whats the problem with File type ?
Thanks and Regards
Sandeep
If you want something you never had,
do something you have never done!
|
|
|
|
|
User can be able to choose only the folder, not the files.
Be simple and Be sample.
|
|
|
|
|
ramskr wrote: How do I upload all files to web server path without using "file" type.
First get the files in that directory using
System.IO.Directory.GetFiles
The above line will return all the files present in the directory as a string array.
ramskr wrote: I need to upload all files from the given client's physical folder path to server path.
Use webclient class. It is having upload method. Start a loop till end of the above string array and upload each file using webclient method in the loop. Finally dispose webclient object
|
|
|
|
|
I need the list of client side files for the selected folder.
For eg, if user choose D:\Test, my web application needs to upload all files in that client folder to web path.
If we use system.io.directory.getfiles - it searches on server and cause exception as "could't find the path"..
Is there any way to get all files on client machine and upload to server machine.
Be simple and Be sample.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
