Code:
public static string sqlInsert(string table, ArrayList values, int numValues)
{
string result = String.empty;
string sqlValues = String.Empty;
for (int i = 1; i <= numValues; i++)
{
if (i < numValues)
z1freeride
Last Activity: Jan 25 '10, 05:50 PM
Joined: Feb 3 '09
Location:
-
Dynamic parametized sql insert - is this a good idea?
I wanted to build an insert sql statement with an unknown number of values. Would this be better as a stored procedure? Is it possible to do this as a stored procedure?
... -
I simplified the code to focus on only one issue. The javascript that I have on my live page is a lot longer and works fine. I'm just trying to get the embed code working. -
Embed code doesn't evaluate
I've found out that I can't do this:
Doing that just outputs the text and does not evaluate what's in the server tag.Code:OnClientClick='var a = <%# DataBinder.Eval(Container.DataItem, "field") %>;'
How do I correctly evaluate that expression so that it outputs the contents of the data? -
Deploying App, requiring .net Framework problem
I tried to install my app an a machine without the .net framework. In my Publish/Prerequisite settings (C# express 2008), I had "Download prerequisites from the component vendor's web site" check. But unfortunately, I received an error and it did not download from Microsoft's site.
I would like to try to download the prerequisites from my website. So I found the .net redistributable but I'm not exactly sure how to go about... -
Possible? Log file analyzer on a client machine
My boss doesn't want me to install any kind of log analyzer (awstats) on our server. Is there anyway to transfer the logs to my local computer and run it through an analyzer? Are there any programs that do that?
Thank you -
Perfect. Thank you!
20 characters....Leave a comment:
-
Showing document in Windows Explorer
I'm programming a download manager and I'm trying to implement the "Show Containing Folder" feature that you would find in Firefox.
This is what I have so far:
This simply opens the folder but in Firefox, it hilights the file. How would I do ...Code:Process proc = new Process(); proc.StartInfo.FileName = "explorer.exe"; proc.StartInfo.Arguments = dlPath; proc.Start();
-
c# webbrowser occasionally doesn't show website (timeout?)
I have a c# web browser that points to one website. About 1 out 100 times nothing is displayed.
I tried to solve it with a more refined refresh button. Here is what I am doing when I click the refresh button:
...Code:if (browser.Document.Title.ToString() != "") { browser.Refresh(); } else { MessageBox.Show("web browser timeout?"); browser.Stop(); -
Oops, found the solution: http://bytes.com/groups/net-c/267801...owfilter-issue (from bytes.com)Leave a comment:
-
Getting row count after setting RowFilter on datatable
I'm trying to get the filtered row count on my datatable. Is this possible?
I'm doing something like this:
dt.DefaultView. RowFilter = expression;
lbl_count.Text = dt.DefaultView. Table.Rows.Coun t.ToString();
//binding to a PagedDataSource object goes here... etc etc.
But obviously that doesn't work. -
So I found the solution. I need to check the option to allow parameters to be passed under the Publish settings -> Options.
Thanks for your suggestions.Leave a comment:
-
Thanks for the tips tlhintoq. You've helped me out a lot.
The problem is that I need to use:
but it is always NULL. It should contain parameters for me to use when I launched the app from a website. I just don't understand why it is NULL.Code:System.Deployment.Application.ApplicationDeployment.CurrentDeployment.ActivationUri.Query
Leave a comment:
-
Hm, according to this: http://www.devnewsgroups.net/group/m...opic62067.aspx, my application has to be set as "online only" in order to access the query parameters. Right now, I have it set as availalbe offline as well (launchable from Start menu).
Is this correct?Leave a comment:
-
Launching app from website, retrieving query string info
I'm trying to launch my C# app from a website and send it some query parameters like so: http://www.test.com/app.application?...t¶m2=test2
According to: http://msdn.microsoft.com/en-us/library/ms172242.aspx, I need to have this line of code:
But my app crashes. It says that (after narrowing it down) ActivationUri...Code:string queryString = ApplicationDeployment.CurrentDeployment.ActivationUri.Query;
-
z1freeride replied to Windows Authentication: Can't access secure website from server, but can from clientin IISStill don't see it. I'm using Windows 2008 server and IIS 7. Click on "default sites" inside IIS? On the left I see a "Sites" directory and then it lists all of my websites.Leave a comment:
-
You're probably right. I was just trying to figure out how to create a "Single Instance" app. I wanted the original instance to come to the front (whether behind, minimized or in the system tray) when a new instance is trying to load.
I found my solution here: http://www.codeproject.com/KB/cs/Sin...eAppMutex.aspxLeave a comment:
-
Get WindowState of a process?
I'm wondering if there's a way to get the windowstate (maximized, minimized normal) of a process.
For example:
Process p = Process.GetProc essesByName("sa mple")[0];
I would like to know if p is in a normal state or not. -
z1freeride replied to Windows Authentication: Can't access secure website from server, but can from clientin IISVirtual Directory? The portion of the website is just in a folder (regular directory). When I right click that folder, I don't see the "Properties " option, just edit permissions (and other things). So I chose that but then I don't see "Directory Security."
Can you be a little more specific as to where I go? I have IIS 7.Leave a comment:
-
z1freeride started a topic Windows Authentication: Can't access secure website from server, but can from clientin IISWindows Authentication: Can't access secure website from server, but can from client
Hi, I have a portion of my website that uses windows authentication. I am able to access that site through my computer. But when I remote into the server and try to access the website, I am unable to.
The error is a HTTP error 401.1 - Unauthorized.
Module: WindowsAuthenti cationModule
Notification: AuthenticateReq uest
Handler: StaticFile
Error Code 0xc000006d
Logon Method: Not yet determined
... -
I already have one form using runat="server" so I'm trying to get a regular html form to post back to the page.Leave a comment:
No activity results to display
Leave a comment: