SQL 2005 RS
I have 5 dropdown parameters, of which only one is required.
All 5 are populated by a dataset.
I have checked allow nulls and blanks for the 4 that are not required.
The SP that I wrote is written in dynamic sql, so it tests for null values for all params, and only includes...
I am looking for a good tutorial on reading, writing and modifying XML in C#.
This is the approach I think I should use.
Read the XML file and put it in a dataset. Manipulate the dataset as needed, and write it back out to the XML file. I guess I am suppose to blow away the entire XML...
We have set up SQL 2000 to use Windows Authentication. There is one person who gets Login Failed for user Null when they try to connect, whether it be Query Analyzer or setting up an ODBC connection. There are 19 of us that have no problems.
However, there was one difference. He had mapped...
I have a client that has a membership only website. The user would pay for either monthly or yearly subscription and this would be recurring. I am open to all gateways (paypal, auth.net, verisign etc). This site will have 1000+ users. I also want the solution to integrate into the current...
I have 3 tables, data_row, data_col and data.
data_row fields are row_id and row_text.
data_col fields are col_id and col_text.
data fields are row_id_fk and col_id_fk and value.
Is it possible to create a datagrid where col_text is displayed horizontally across the top for each column, and...
My excel sheets do not allow me to see when I fill in a background color for a cell. It is visible when I go to print preview, but not when I am editing the page. I don't have templates and I have tried resetting any default options. Any ideas?
Thanks,
Chad
I am trying to get the following line of code to work.
sSagList = "('31Z','32Z','31R','32R')"
document.write('<td class="list" style="padding-left:2px; font-weight:bold; border-right:0px solid #eeeeee"> <img style="cursor: default" onclick="AddRow(this,\'' + sSagList + '\');" alt="Insert...
I have a multiline textbox that will hold paragraphs of information. I think that I have to write the data to a text file and save the text file to the database, because it doesn't save all of the data when I use the usual request.form("txtArticle") .
Does anyone know of a good article that...
I have a site where I want to allow different groups access certain areas.
I have my main web.config, and a web.config in the subdirectory that I want to redirect to a login page.
This is my Main web.config
1<system.web>
2
3<authentication mode="Forms">
4 <forms name="yourAuthCookie"
5...
Here is the environment.
IIS 5.0 on one server. The web site uses a security certificate. Windows Integrate Auth is checked. Anonymous is unchecked. We must use windows auth and not anonymous because I need to collect server variables. Basic also cannot be used.
SQL 2000 on another server...
Here is some code that would be useful for reports where your user would like to choose the columns of the datagrid that he or she wants to see.
I use a checkboxlist with a checkbox for each column of my datagrid. To make it easy for the user I suggest setting the value of the ListItems to the...
Last week I posted this thread.
http://www.tek-tips.com/viewthread.cfm?SQID=817445&SPID=855&newpid=855&page=1
I got a great answer and everything works well.
My current problem is when I need to have 2 sets of tablerows on the fly.
I.e. I have 2 dropdowns that each have values 1 through...
Is there any way to create tablerows based on the value of a dropdownlist?
I.e dropdown contains values 1 through 10.
User selects 5. 5 Tablerows are created.
I was thinking something along the lines of
i=dropdown.selectedvalue
so i=5...
For x = 1 to i
<TR>
<TD>
<asp:dropdownlist...
I am converting an asp page to asp.net and I am one section away from getting it to work.
Here is what I have...
Do Until rs.EOF
HttpContext.Current.Response.Write("<option value=""" & rs(0) & """>" & rs(1) & "</option>" &...
If I have a dataset that has field1 and field2, how do I retrieve just field1's value?
I have a count of the number of records in the dataset (recordcount).
I want to loop through them like this.
For i = 0 to recordcount
if string = "dataset.table.field1(i)" <-- this is where I am...
Is there a good way to validate a textbox entry by the user against a dataset?
I.e
Dataset: VENDORS - Cisco, Dell, Microsoft
I would like the string entered in the textbox (txtVendor) to be searched for in the dataset, and if found, thrown an error saying that the Vendor already exists.
I...
I have a dropdown box...
<asp:DropDownList id="ddVendor" runat="server" Width="226px" DataTextField="VENDOR" DataValueField="PK_VENDOR_ID"></asp:DropDownList>
I have this in the button_click event...
Dim vendorID as integer
vendorID =...
I have a dropdown box...
<asp:DropDownList id="ddVendor" runat="server" Width="226px" DataTextField="VENDOR" DataValueField="PK_VENDOR_ID"></asp:DropDownList>
I have this in the button_click event...
Dim vendorID as integer
vendorID =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.