|
What was that? 
Best Regards,
Apurva Kaushal
|
|
|
|
|
|
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hey,
First I couldnt find a direct database forum, but i am using asp.net, so here it goes.
I am creating a search function, and I want to search all tables in my mysql db. Now I have researched and found that this can be done simply by seperating all the tables in the FROM clause with commas, or using a UNION statement, but what I want to know is can you just select all of the tables in the db at once?
All my tables are identicle in structure, and at first i would just like to search the one field from each table.
I have tried using something like "SELECT * FROM *" but i get errors.
The main reason I want to do this is because everytime I add a table in the db I dont want to have to edit the code.
If anyone can help or even point me in direction of some good articles it would be appreciated.
Thanks for your time.
|
|
|
|
|
Say I have a database Members.mdf. I bind a table within "Profiles" to a GridView. Then I try to use Linq to access another table in Members.mdf. (e.g. Members db = new Members(Filepath);) Then I get a cannot access database because another program is using it error. I assume that the databind connection is in conflict with the Linq connection.
Is this a fundamental database access conflict problem or LINQ specific? And how can I get around it? Or should I just try to use either databinding or linq but not both? Thanks.
|
|
|
|
|
I am developing a web application using C#.Net (dot net 2003). I want to use vertical Toolbar control on my web page.
Please help me. it's very urgent
Hrushikesh
|
|
|
|
|
Sir,
I want to refresh my page after each 30 seconds .PLease help how to do it.
Thanks
|
|
|
|
|
You can use meta tag to refresh the page in particular time.
Best Regards,
Apurva Kaushal
|
|
|
|
|
|
Best Regards,
Apurva Kaushal
|
|
|
|
|
Thanks It is working very fine.
|
|
|
|
|
always welcome..
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hello people,
Situation:
I have a webservice method which calls a method inside a separate DLL to perform some database updates. That same DLL method also writes some image files to a directory created on the fly inside the webservice IIS folder.
Problem:
Writing files to a directory on disk works fine, but creating a directory on the fly doesn't. I use Directory.CreateDirectory(path) and I get access denied to path. If I create the directory manually and run the program, all image files are written inside it with no problem. I have tried giving full control to ASPNET user account but still didn't work.
Any ideas?
Thanks,
Talal
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook
|
|
|
|
|
I'm trying to run stand-alone application from asp.net 1.1
the code is here:
Process program = new Process();
ProcessStartInfo pInfo=new ProcessStartInfo();
pInfo.UseShellExecute = false;
pInfo.RedirectStandardOutput = true;
pInfo.RedirectStandardError = true;
pInfo.RedirectStandardInput = true;
pInfo.Arguments=argument;
pInfo.FileName=reciperouteApp;
pInfo.WorkingDirectory=workingDir["Text"].ToString();
program.StartInfo = pInfo;
program.Start();
program.WaitForExit();
The application start ok but the applicatioin doesnt work properly. the applicatioin get's culture from somewhere and it's wrong the problem occur in decimal formatin i need to use (dot). but it's (comma), this hole project works fine on my laptop but in server it's not working. if i understand correct the new process start as ASP.NET user accout, but where i can chage that culture option. i have try setting the culture option on machine.config and web.config whit no luck. Thanks for help!!!!
|
|
|
|
|
Basically, the NumberFormatInfo is used based on the current CultureInfo settings, and the default culture is set based on the locale of the user that the process runs under, so you might want to check this account. To set the culture in an ASP.NET application, you can see:
How to: Set the Culture and UI Culture for ASP.NET ... [^]
|
|
|
|
|
this option helps whit the asp.net application but i need to change the culture for new process that the asp.net application start during the run of asp.net application.
this is what i do on page_load
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-us");
this is done to sure that the dot is decimal seperator
NumberFormatInfo numin=new NumberFormatInfo();
numin.CurrencyDecimalSeparator=".";
Single num = Single.Parse(number,numin);
on web.config i set
<globalization
="" requestencoding="utf-8" responseencoding="utf-8" fileencoding="utf-8" culture="en-US" uiculture="en">
but this doesnot work on new process whitch I start during use of asp.net application the new process is application.exe and it gets argument on startup. this appliction works fine when started on by shurtcut where argument is set manualy.
i hope this helps to understand my problem.
|
|
|
|
|
These settings do not have any effect on the spawned process as the new process will be using the settings of the user that it runs under. So your chances here are:
+ Dynamically set in the executable.
+ If the new process runs under the ASPNET account (or NetworkService), then configure this account's number setting.
+ Make the new process impersonate another user other than the default who has the expected format.
|
|
|
|
|
the second change i understund and i believe that the new process runs under ASPNET account or NetworkService but i dont know how to do the configurattion on that specifig account. So can you give my some example how it's done. Thanks!
|
|
|
|
|
Hi,
I'm using Delphi2006 with ASP.Net .I need to retreive the data from the backend conditioning the dates i.e., i need to get the data between the given range of dates.
My SQL query goes like this :
Select x,y,z from <table_name> where
to_date(fromdate,''RRRR/MM/DD HH24:MI:SS'') between to_date(''Calendar1.SelectedDate'',''RRRR/MM/DD HH24:MI:SS'') and to_date(''Calendar2.SelectedDate'',''RRRR/MM/DD HH24:MI:SS'').
So, here i'm passing the dates thru the calendar component from my Delphi. problem is,query is working in the backend.But, it is showing no records in the front end when i try to dispaly it in the datagrid.Atleast , it is not showing any error also.I have changed the dateformat also while passing into the query as
formatdatetime('dd/mm/yy',Calendar1.Selecteddate) and also the same for calendar2.... But i'm not getting the records displayed.
So kindly put me a solution for this.I think the problem is with dateformats in ASP.Net... Please give me a solution.
- Regards,
Bindu Priya.P
|
|
|
|
|
all,
We are using office automation to convert excel and word to htm we had severa issues like access denied exception etc. and for this issue to solve we followed KB article of MS to configure office under specific user account, but the problem is because security issues we cant follow KB article(http://support.microsoft.com/kb/288367/), by looking at KB article what i felt is they are trying to create a profile for local administrator user. So my question can any body have any alternate for this??
We accept tht we went for bad design, but we dont have any other alternative as this is a must requirement from customer.
Please any cluse any information you have.
|
|
|
|
|
Another option that you may want to look at is impersonation, your application may impersonate another user who has enough permission to work with the automation.
IamADotNetGuy wrote: this is a must requirement from customer.
Any chance to convince the client that the automation is not a recommendation, may give the Microsoft documentation, and consider a third party component that supports the same thing.
|
|
|
|
|
Hi
I am very badly struggling with web services. I am trying to call a web service which is prepared by one of our other team. I am passing soap message as
a) SOAP MESSAGE
---------------------------
"<soap:Envelope xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'><soap:Body><SaveCustomerService xmlns='http://www.gift.com/Gift'><ROOT><username>bob</username><email>b@v.com</email><category>1</category><subject>a</subject><message>aaaa</message></ROOT></SaveCustomerService></soap:Body></soap:Envelope>"
b) Here is my calling code
----------------------------------
Public Function Send(ByVal WSUrl As String, ByVal soapAction As String, ByVal soapBody As String)
Dim httpRequest As HttpWebRequest = CType(WebRequest.Create(WSUrl), HttpWebRequest)
Dim requestStream As System.IO.Stream
Dim requestWriter As System.IO.StreamWriter
Dim responseStream As System.IO.Stream
Dim responseReader As System.IO.StreamReader
Dim bodyData As Byte() = Encoding.UTF8.GetBytes(soapBody)
httpRequest.ContentLength = bodyData.Length
httpRequest.ContentType = "text/xml; charset=utf-8"
' httpRequest.Headers.Add("SOAPAction", soapAction)
httpRequest.Method = "POST"
httpRequest.PreAuthenticate = True
' Create a New 'NetworkCredential' object.
Dim networkCredentials As NetworkCredential = New NetworkCredential("XYZ", "XYZ")
' Associate the 'NetworkCredential' object with the 'HttpWebRequest' object.
httpRequest.Credentials = networkCredentials
' Create a new RequestStream to POST info (Synchronous call)
requestStream = httpRequest.GetRequestStream()
requestWriter = New StreamWriter(requestStream)
'Write Soap message into RequestStream
requestWriter.Write(soapBody)
' Cleanup
requestWriter.Close()
requestStream.Close()
' Create a new HttpWebResponse (Synchronous call)
Try
Dim httpResponse As HttpWebResponse = CType(httpRequest.GetResponse, HttpWebResponse)
Catch ex As Exception
Dim a, b, d As String
Dim c As Exception
a = ex.Source()
b = ex.Message
c = ex.InnerException
d = ex.StackTrace
End Try
ON HttpWebResponse i am getting an error "Internal Server error 500)...
I don;t know how to debug this or how to resolve...Please help me....
C)Here is my web method
----------------------------------
Public Function SaveCustomerService(ByVal CustomerService As String) As String
Try
Dim sUserName, sEmail, sCategory, sSubject, sMessage As String
sUserName = GetXmlValue(CustomerService, "username")
sEmail = GetXmlValue(CustomerService, "email")
sCategory = GetXmlValue(CustomerService, "category")
sSubject = GetXmlValue(CustomerService, "subject")
sMessage = GetXmlValue(CustomerService, "message")
Dim sResponse As String
sResponse = SaveCustomerService(sUserName, sEmail, sCategory, sSubject, sMessage)
Return sResponse
Catch ex As Exception
Dim a As New ThrowSoapException
a.myThrow()
End Try
PLEASE HELP ME............
Amit
|
|
|
|
|
I got this error when i run visual interdev at my pc..
Anyone can help me...
I'm using access
Error Code...
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
|
|
|
|
|
|
Either database is already open or some other application is using the database.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
