Search results for query: *

I have been using a tool called sql pretty printer for a while which is great for formatting sql queries. (Basically you pass in a long string to the tool and it places the enters in logical places in the query and then highlights keywords. I am looking for a free tool/plugin for vs.net to...

I have the following line of code in my javascript. document.all['test_label'].firstChild.data = '<img src="/images/cabinet.gif" height=15 width=15>Check this out'; When it goes to render the page it displays it as <img src="/images/cabinet.gif" height=15 width=15>Check this out Any idea why...

Is there a quick way to convert a one dimensional array into a comma delimited string. I know i can just iterate through the array and generate the string using concatination. Is there a better or simpler way? (FYI: The elements in the array are numbers) thanks

I have the following code: <a onmousedown='test();' onmousover=''><img src='button.gif'/></a> I want to place some code in the onmouseover to apply the following css style to to the image when a user mouses over the image. cursor:hand; filter...

Hi, I have the following query: select first_name,last_name, address from address_book which returns the following table john smith 393 Jones RD bill smith 345 Jenkins RD I would like to modify the query so the resulting query returns a table that looks like this john smith 393...

Hi, I have a modal dialog (window.showModalDialog) which contains the following link: <a href='download.aspx?file=test.txt'>" + "test" + "</a> Note: This issue only arises when the link is clicked from inside a modal dialog window. IE6 When i click the link a blank window shows up, and then...

I have two sql statements. The first has a unique primary key on name, whereas the second is a one to many relationship on name. I would like to join the two queries so the result looks like: John Smith, 234 Jones Rd, 430-293-3928, note1 John Smith, 234 Jones Rd, 430-293-3928, note2 John Smith...

Hi, I have a several white links on a dark green background. (which looks good) I need to have some of the links "disabled" what color should I make the disabled links? Thanks

Hi I have the following two lines in my code (see below) the only difference is that the title is different in each and one is disabled while the other is not. I created a css style see below which is applied to both. Is it possible to create two css styles and have one applied to the disabled...

Hi, I am currently using Microsoft SQL Server Management Studio to look at the contents of my database and view/edit my stored procedures. Is there a way using SQL Server Management Studio to search through all the stored procedures for the words 'accounts'. I know one solution i have is to...

Hi, I am looking to create a regular expression that only allows Upper Case and Lower Case Letters and hyphens. I have the following so far which allows for uppercase and lower case characters. How do I modify it to include "-" also? var re = new RegExp("^([a-zA-Z])+$");

Hi, I have the following code <asp:Panel ID="Panel1" runat="server" Height="150px" Width="200px" ScrollBars="Auto" CssClass="box"> here is my text...</asp:panel> when the code runs i see a scrollable panel with a lot of text. When i hit the print button, it only shows me the text that i can...

I have a Datatable with 100 rows in it. (I can easily convert it into a Datarow[].) Is there anyway to insert rows in the middle of these structures. Meaning can i insert a new Datarow in between rows 35 and 36. (If there is no way to do this, are there any other data structures I can easily...

Hi, I know you can add a row to a table by doing Table table = new Table(); table.Rows.Add(new Row()); How would you go about adding a column to that table? Thanks.

Hi, I know you can add a row to a table by doing Table table = new Table(); table.Rows.Add(new Row()); How would you go about adding a column to that table? Thanks.

Hi, How would i use the xml writer in c# to write the following? <TABLE cellspacing=1 cellpadding=1> <TR> <TD align=center colspan=4><FONT size=4 color=blue>Price Quote</FONT></TD> </TR> <TR> <TD><B>Product</B></TD> <TD><B>Price</B></TD> </TR> </TABLE>

I wrote the following code (full source code at the bottom) which writes to cells A7 and B7 in Book1.xls. I am wondering how can I modify the following code so it only write to one cell. I attempted the following comOleDBCommand.CommandText = "UPDATE [Sheet1$A7:B7] SET F1 = 5, F2 = 'Cell G3'"...

Not sure what data type to use for this. (language c#). I have a function that takes in three values a row, column and a string. (I have no idea how many rows or columns there will be). I will later need to pull the values in the following order. First Row, First Column First Row, Second...

I wrote the following code (code below) which opens an excel spreadsheet named Book1.xls. Afterwards it writes the text 5 in cell A7 and the text "Cell G3" in cell B7. This works okey the only issue is that when I open the spreadsheet and place the curser in cell A7 the number 5 is formatted as...

I saw the following code on the codeproject which allows you to copy a table from one server to another server. Is there a simple way to do the same thing but instead copy a database? SqlConnectionStringBuilder cb = new SqlConnectionStringBuilder(); cb.DataSource = "SQLProduction"...