Date: 12/11/05     Keywords: database, asp, sql

I've created 2 pages, one to display data from a database and another to insert data. I'm having trouble with the sql insert query.
The first page displays data fine, not in the format I'd like but one thing at a time.

How do I on the second page, create text boxes and the proper connections to insert data into my database. I'm pretty sure this is a simple basic step but I can not figure it out.

Any help or tutorials? I usually hit www.asp.net when I’m stuck and their tutorial is not helping on this one.



Thanks!

Source: http://community.livejournal.com/aspdotnet/51352.html

Date: 12/08/05     Keywords: database, asp, sql, web

hello all.. ok here's the story...

i know some basic asp .. i've edited a database driven website fro a while.
I'm no trying to create a new site .. thats also database driven.

How do i connect to the server in order to pull info from it?

I tried following the trail from the site i currently update but i'm not sure what i'm seeing here...

Anyone know how to connect an asp site to a sql 2003 database?

Source: http://www.livejournal.com/community/aspdotnet/51038.html

Date: 12/08/05     Keywords: database, asp, sql, web

hello all.. ok here's the story...

i know some basic asp .. i've edited a database driven website fro a while.
I'm no trying to create a new site .. thats also database driven.

How do i connect to the server in order to pull info from it?

I tried following the trail from the site i currently update but i'm not sure what i'm seeing here...

Anyone know how to connect an asp site to a sql 2003 database?

Source: http://community.livejournal.com/aspdotnet/51038.html

Date: 12/07/05     Keywords: css, asp, sql

Anyone know how I can access controls within the EmptyDataTemplate of my GridView?

<asp:GridView ID="grdProjectHours" DataSourceID="sqlModifyProjectHours" 
        PageSize="15" AllowPaging=true AllowSorting=true 
        AutoGenerateColumns=false GridLines="Both" 
        ShowFooter=true BorderWidth="2" BorderColor="#000000" 
        runat=server Width="100%" 
        OnDataBound="grdProjectHours_OnDataBound" 
        OnRowUpdating="grdProjectHours_OnRowUpdating" 
        EditRowStyle-VerticalAlign="top">
	...
	<Columns>
		<asp:TemplateField HeaderText="Project" SortExpression="project">
			...
		</asp:TemplateField>
	</Columns>
	<EmptyDataTemplate>
		<table width="100%" cellpadding="0" cellspacing="0" border="0">
			<tr>
				<td class="gridHeader"><asp:Label ID="lblEmptyProject" runat="server" Text="Project" /></td>
				<td class="gridHeader"><asp:Label ID="lblEmptyHours" runat="server" Text="Hours" /></td>
				<td class="gridHeader"><asp:Label ID="lblEmptyWorkDate" runat="server" Text="Date of Work" /></td>
				<td class="gridHeader"><asp:Label ID="lblEmptyChangeNumber" runat="server" Text="Change Order" /></td>
				<td class="gridHeader"><asp:Label ID="lblEmptyComments" runat="server" Text="Comments" /></td>
				<td class="gridHeader"></td>
			</tr>
			<tr>
				<td colspan="7" height="2"></td>
			</tr>
			<tr>
				<td colspan="7" bgcolor="#cccccc"></td>
			</tr>
			<tr>
				<td colspan="7" height="1"></td>
			</tr>
			<tr>
				<td class="gridContent"><asp:DropDownList ID="cboNewProject" Width="225" runat="server" DataSourceID="sqlProject" DataTextField="project" DataValueField="id" OnDataBound="cboNewProject_OnDataBound" /></td>
				<td class="gridContent"><asp:TextBox ID="txtNewHours" Width="50" runat="server" /></td>
				<td class="gridContent"><asp:TextBox ID="txtNewWorkDate" Width="50" runat="server" /></td>
				<td class="gridContent"><asp:TextBox ID="txtNewChangeNumber" MaxLength="10" Width="50" runat="server" /></td>
				<td class="gridContent"><asp:TextBox ID="txtNewComments" MaxLength="155" Width="100" runat="server" /></td>
				<td class="gridContent" align="right"><asp:LinkButton ID="btnAddProjectHours" runat="server" CommandName="insert" Text="add" OnClick="btnAddProjectHours_OnClick" /></td>
			</tr>
			<tr>
				<td class="gridContent"><asp:RequiredFieldValidator ID="reqNewProject" ControlToValidate="cboNewProject" ErrorMessage="Project" CssClass="ErrorMessage" EnableClientScript="false" Display="Dynamic" runat="server" /></td>
				<td class="gridContent"><asp:RequiredFieldValidator ID="reqNewHours" ControlToValidate="txtNewHours" ErrorMessage="Hours" CssClass="ErrorMessage" EnableClientScript="false" Display="Dynamic" runat="server" /></td>
				<td class="gridContent"><asp:RequiredFieldValidator ID="reqNewWorkDate" ControlToValidate="txtNewWorkDate" ErrorMessage="Date of Work" CssClass="ErrorMessage" EnableClientScript="false" runat="server" /><asp:RangeValidator id="rngWorkDate" runat="server" CssClass="ErrorMessage" ControlToValidate="txtNewWorkDate" MaximumValue="1/1/2100" MinimumValue="1/1/1900" Type="Date" EnableClientScript="false" ErrorMessage="Date of Work (mm/dd/yyyy)" Display="dynamic" /></td>
				<td class="gridContent"></td>
				<td class="gridContent"></td>
				<td class="gridContent" align="right"></td>
			</tr>
		</table>
	</EmptyDataTemplate>
</asp:GridView>

Source: http://www.livejournal.com/community/aspdotnet/50872.html

Date: 12/07/05     Keywords: css, asp, sql

FYI: Problem resolved


Anyone know how I can access controls within the EmptyDataTemplate of my GridView?

<asp:GridView ID="grdProjectHours" DataSourceID="sqlModifyProjectHours" 
        PageSize="15" AllowPaging=true AllowSorting=true 
        AutoGenerateColumns=false GridLines="Both" 
        ShowFooter=true BorderWidth="2" BorderColor="#000000" 
        runat=server Width="100%" 
        OnDataBound="grdProjectHours_OnDataBound" 
        OnRowUpdating="grdProjectHours_OnRowUpdating" 
        EditRowStyle-VerticalAlign="top">
	...
	<Columns>
		<asp:TemplateField HeaderText="Project" SortExpression="project">
			...
		</asp:TemplateField>
	</Columns>
	<EmptyDataTemplate>
		<table width="100%" cellpadding="0" cellspacing="0" border="0">
			<tr>
				<td class="gridHeader"><asp:Label ID="lblEmptyProject" runat="server" Text="Project" /></td>
				<td class="gridHeader"><asp:Label ID="lblEmptyHours" runat="server" Text="Hours" /></td>
				<td class="gridHeader"><asp:Label ID="lblEmptyWorkDate" runat="server" Text="Date of Work" /></td>
				<td class="gridHeader"><asp:Label ID="lblEmptyChangeNumber" runat="server" Text="Change Order" /></td>
				<td class="gridHeader"><asp:Label ID="lblEmptyComments" runat="server" Text="Comments" /></td>
				<td class="gridHeader"></td>
			</tr>
			<tr>
				<td colspan="7" height="2"></td>
			</tr>
			<tr>
				<td colspan="7" bgcolor="#cccccc"></td>
			</tr>
			<tr>
				<td colspan="7" height="1"></td>
			</tr>
			<tr>
				<td class="gridContent"><asp:DropDownList ID="cboNewProject" Width="225" runat="server" DataSourceID="sqlProject" DataTextField="project" DataValueField="id" OnDataBound="cboNewProject_OnDataBound" /></td>
				<td class="gridContent"><asp:TextBox ID="txtNewHours" Width="50" runat="server" /></td>
				<td class="gridContent"><asp:TextBox ID="txtNewWorkDate" Width="50" runat="server" /></td>
				<td class="gridContent"><asp:TextBox ID="txtNewChangeNumber" MaxLength="10" Width="50" runat="server" /></td>
				<td class="gridContent"><asp:TextBox ID="txtNewComments" MaxLength="155" Width="100" runat="server" /></td>
				<td class="gridContent" align="right"><asp:LinkButton ID="btnAddProjectHours" runat="server" CommandName="insert" Text="add" OnClick="btnAddProjectHours_OnClick" /></td>
			</tr>
			<tr>
				<td class="gridContent"><asp:RequiredFieldValidator ID="reqNewProject" ControlToValidate="cboNewProject" ErrorMessage="Project" CssClass="ErrorMessage" EnableClientScript="false" Display="Dynamic" runat="server" /></td>
				<td class="gridContent"><asp:RequiredFieldValidator ID="reqNewHours" ControlToValidate="txtNewHours" ErrorMessage="Hours" CssClass="ErrorMessage" EnableClientScript="false" Display="Dynamic" runat="server" /></td>
				<td class="gridContent"><asp:RequiredFieldValidator ID="reqNewWorkDate" ControlToValidate="txtNewWorkDate" ErrorMessage="Date of Work" CssClass="ErrorMessage" EnableClientScript="false" runat="server" /><asp:RangeValidator id="rngWorkDate" runat="server" CssClass="ErrorMessage" ControlToValidate="txtNewWorkDate" MaximumValue="1/1/2100" MinimumValue="1/1/1900" Type="Date" EnableClientScript="false" ErrorMessage="Date of Work (mm/dd/yyyy)" Display="dynamic" /></td>
				<td class="gridContent"></td>
				<td class="gridContent"></td>
				<td class="gridContent" align="right"></td>
			</tr>
		</table>
	</EmptyDataTemplate>
</asp:GridView>

Source: http://community.livejournal.com/aspdotnet/50872.html

Date: 12/06/05     Keywords: database, sql

Hey gang,

I'm in the process of fixing an application a former programmer slap together. We found the database design went against company standards, so our DBA went through to fix her up. Now I'm working on the task of fixing the UI code to interact properly with the new changes.

However, I've ran in to a strange behavior with UpdateParameters within my SqlDataSource.

Originally, the Stored Proc calls for the following parameters:

Source: http://www.livejournal.com/community/aspdotnet/50533.html

Date: 12/06/05     Keywords: database, sql

FYI: Resolved.

Hey gang,

I'm in the process of fixing an application a former programmer slap together. We found the database design went against company standards, so our DBA went through to fix her up. Now I'm working on the task of fixing the UI code to interact properly with the new changes.

However, I've ran in to a strange behavior with UpdateParameters within my SqlDataSource.

Originally, the Stored Proc calls for the following parameters:

Source: http://community.livejournal.com/aspdotnet/50533.html

Date: 12/01/05     Keywords: database, sql

I'm writing a program that does queries on a database, and we just converted to a code-table format (instead of whole strings going in the DB we just put in numbers that reference another table which has all the definitions. Note that these tables are NOT connected (sadly.)) Anyways I'm writing this program that returns data from the database into a datagridview. I've been told that I can't do the conversion on the DataSet or the DGV side and that SQL server needs to do it, so basically I need to write a query that will get all the records that match the request, and then in a particular column, instead of putting in the number that is in teh database, have it look at the code table, find the matching id, and have THAT be displayed instead.

Here's conceptually what I'm going for (this is NOT SQL compliant and my SQL knowledge isn't that great. Hell if it was I wouldn't be here asking this question which I know any standard SQL DB user will likely know the answer to):

SELECT * FROM Table1, Table2
In Table1.Column,
instead of showing the code in it,
WHERE Table1.Column = Table2.Column(id),
Display in Table1.Column the info in Table2.Description.

I realize this is sort of hard to describe in text vs speech. I know there's an easy way to do this with an Inner Join, but that simply adds the info from the 2nd table to the end of the first (and displayed) table.

Here's the SQL code

SELECT * FROM sfrf_request
INNER JOIN sfrf_request_type
ON CONVERT(int,sfrf_request.request_type)=sfrf_request_type.id
WHERE sfrf_request.id = ddl1.SelectedIndex

BTW the CONVERT function is used because the column has string data in it still and thus I can't reference it as an integer.

Any help would be greatly appreciated.

Source: http://www.livejournal.com/community/aspdotnet/49681.html

Date: 12/01/05     Keywords: database, sql

I'm writing a program that does queries on a database, and we just converted to a code-table format (instead of whole strings going in the DB we just put in numbers that reference another table which has all the definitions. Note that these tables are NOT connected (sadly.)) Anyways I'm writing this program that returns data from the database into a datagridview. I've been told that I can't do the conversion on the DataSet or the DGV side and that SQL server needs to do it, so basically I need to write a query that will get all the records that match the request, and then in a particular column, instead of putting in the number that is in teh database, have it look at the code table, find the matching id, and have THAT be displayed instead.

Here's conceptually what I'm going for (this is NOT SQL compliant and my SQL knowledge isn't that great. Hell if it was I wouldn't be here asking this question which I know any standard SQL DB user will likely know the answer to):

SELECT * FROM Table1, Table2
In Table1.Column,
instead of showing the code in it,
WHERE Table1.Column = Table2.Column(id),
Display in Table1.Column the info in Table2.Description.

I realize this is sort of hard to describe in text vs speech. I know there's an easy way to do this with an Inner Join, but that simply adds the info from the 2nd table to the end of the first (and displayed) table.

Here's the SQL code

SELECT * FROM sfrf_request
INNER JOIN sfrf_request_type
ON CONVERT(int,sfrf_request.request_type)=sfrf_request_type.id
WHERE sfrf_request.id = ddl1.SelectedIndex

BTW the CONVERT function is used because the column has string data in it still and thus I can't reference it as an integer.

Any help would be greatly appreciated.

Source: http://community.livejournal.com/aspdotnet/49681.html

Date: 11/29/05     Keywords: programming, sql, web

Ok this is a weird question that may not be appropriate here but here's my situation: I'll be getting a new computer for Xmas that will be a powerful machine that will be used for 2 primary functions: Programming and Gaming. Thing is that basically I do alot of web programming so I'm going to have VS 2003 and 2005, SQL Server (possibly 2000 AND 2005), and IIS. As you know gaming requires alot of system resources and memory and I don't want to have to go to task manager everytime I boot up to play a game to close off all the programming and server programs. So what I'm wondering is whether or not I should:

A: Set up 2 user accounts on my computer (this is an XP Pro machine) with one for programming and one for gaming that has a modified startup script to disable everything (which i have no experience in writing BTW). I also don't know if this would even free up all the memory that I'd want.

B: Install 2 instances of XP Pro and use a dual boot configuration with one config with all the server and programming tools and one without. HD space isnt' really an issue since I will have a 250 gig hard drive (and likely will be adding more at a later date.) However I'm not very experienced with this sort of setup. I do plan on installing Windows XP 64-bit as well, so I'd have to do the 2 32-bit installations first and then do the 64-bit one. I'm not very keen on dealing with multiple partitions for all my programs, especially if they can't talk to one another (although I bet there's tools that allow you to view on the parttions, like I said I don't have much experience with this.) I know the 64 will require its own partition.

Sorry if this is really "out there" or inappropriate for this community. If someone knows a more appropriate one please let me know. I just figured since there appears to be a decent number of intelligent computer users here that perhaps there'd be someone here who could help me as well. Thanks alot.

Source: http://www.livejournal.com/community/aspdotnet/49429.html

Date: 11/29/05     Keywords: programming, sql, web

Ok this is a weird question that may not be appropriate here but here's my situation: I'll be getting a new computer for Xmas that will be a powerful machine that will be used for 2 primary functions: Programming and Gaming. Thing is that basically I do alot of web programming so I'm going to have VS 2003 and 2005, SQL Server (possibly 2000 AND 2005), and IIS. As you know gaming requires alot of system resources and memory and I don't want to have to go to task manager everytime I boot up to play a game to close off all the programming and server programs. So what I'm wondering is whether or not I should:

A: Set up 2 user accounts on my computer (this is an XP Pro machine) with one for programming and one for gaming that has a modified startup script to disable everything (which i have no experience in writing BTW). I also don't know if this would even free up all the memory that I'd want.

B: Install 2 instances of XP Pro and use a dual boot configuration with one config with all the server and programming tools and one without. HD space isnt' really an issue since I will have a 250 gig hard drive (and likely will be adding more at a later date.) However I'm not very experienced with this sort of setup. I do plan on installing Windows XP 64-bit as well, so I'd have to do the 2 32-bit installations first and then do the 64-bit one. I'm not very keen on dealing with multiple partitions for all my programs, especially if they can't talk to one another (although I bet there's tools that allow you to view on the parttions, like I said I don't have much experience with this.) I know the 64 will require its own partition.

Sorry if this is really "out there" or inappropriate for this community. If someone knows a more appropriate one please let me know. I just figured since there appears to be a decent number of intelligent computer users here that perhaps there'd be someone here who could help me as well. Thanks alot.

Source: http://community.livejournal.com/aspdotnet/49429.html

Date: 11/25/05     Keywords: asp

Validaton of a calender control in asp.net (vb) I
need to make sure a value has been clicked in the
calendar control and that if there hasn't been a
value selected in the calendar control that the
page doesn't submit and returns an error.

Source: http://www.livejournal.com/community/aspdotnet/49250.html

Date: 11/25/05     Keywords: asp

Validaton of a calender control in asp.net (vb) I
need to make sure a value has been clicked in the
calendar control and that if there hasn't been a
value selected in the calendar control that the
page doesn't submit and returns an error.

Source: http://community.livejournal.com/aspdotnet/49250.html

Date: 11/21/05     Keywords: database, web

I'm working on grabbing data from a database and putting it into a DataGridView. My program starts off with 1 DGV, and I want the program to then go to another page that has 3 DGVs on it, all referencing the "id" field from the previous form. Thing is I don't know how I can grab the id value from the DGV. I cant' find a .SelectedValue or .Value of the selected cell.. also this isnt' for a web form, so I don't think I can just do the hyperlink column with a query string on the end of it/passed value. Does anyone know of a way to grab the value of a selected cell? thanks.

Source: http://www.livejournal.com/community/aspdotnet/48644.html

Date: 11/21/05     Keywords: database, web

I'm working on grabbing data from a database and putting it into a DataGridView. My program starts off with 1 DGV, and I want the program to then go to another page that has 3 DGVs on it, all referencing the "id" field from the previous form. Thing is I don't know how I can grab the id value from the DGV. I cant' find a .SelectedValue or .Value of the selected cell.. also this isnt' for a web form, so I don't think I can just do the hyperlink column with a query string on the end of it/passed value. Does anyone know of a way to grab the value of a selected cell? thanks.

EDIT: Nevermind.. I figured it out. Its DataGridView.CurrentCell.Value

Source: http://community.livejournal.com/aspdotnet/48644.html

Date: 11/21/05     Keywords: no keywords

I need to do some date validation on a few calendar
controls what is a quick and easy method of validating
these controls and how do i implement it?

Source: http://www.livejournal.com/community/aspdotnet/48627.html

Date: 11/17/05     Keywords: sql

I'm writing a program in C# that is supposed to take a datagridview control that is binded to a SQL query. I'm trying to write something that will loop through each cell and will make the cell invisible if there's no data in it. I'm not sure if I'm supposed to loop it using a column count or through cells or what. I'm pretty new to this control (Its a 2.0 control in case no one knows what this is referring to.) If anyone has any suggestions it'd be greatly appreciated.

Source: http://www.livejournal.com/community/aspdotnet/48214.html

Date: 11/15/05     Keywords: asp, web

Hello,

I am a newby to ASP.NET. So, my question may be a stupid one. I have a CheckBoxList on my WebForm and I want to enable the postback only when at least one of the checkboxes in the list is checked. How can I do this?

Source: http://www.livejournal.com/community/aspdotnet/48099.html

Date: 11/14/05     Keywords: asp, web

If you saw my previous inane message you know I'm working on converting an ASP.Net webform from 1.1 to 2.0, and I'm having an "issue" with viewing my page in the VS design mode. The page uses ALOT of panels that are visible/invisible depending on what you select on the form. In VS.net 2003 the design mode shows all the panels fully opened, which made design rather easy, but now I can't see any of the panels, which cuts off about 75% of the web page. Is there a setting option or viewing thing that I need to enable to allow the panels to be viewed? If you want I can post a picture of what I'm talking about, but I'd like to think my explanation is fairly straightforward. Thanks in advance.

BTW If I find a solution before one is posted here (ie I answer my own questions) I'll commit a self-imposed ban on myself here so that I don't keep putting up stupid posts on this board. :-p

Source: http://www.livejournal.com/community/aspdotnet/47665.html

Date: 11/11/05     Keywords: web

I'm converting a 1.1 webform to 2.0, and I'm having an issue trying to fix an obsolete class. System.Web.Mail has been obseleted so now I have to convert to the System.Net.Mail. I'm having a problem because now for some reason when I try to add the "from" and "to" parts of the email its giving me an error of "Value of type 'String' cannot be converted to 'System.Net.Mail.MailAddress.'" ...ummmm... so would an INTEGER be more appropriate? It also says, "Property 'To' is 'ReadOnly'." ....huh?

Here's the code:

Try
Dim sMailMessage As String
sMailMessage = fcnSendForm()

Dim sErrMsg As String = fcnInsertDB()
If sErrMsg.Trim <> "" Then

Dim objMM As New MailMessage
objMM.Subject = "Systems & Facilities Request Form ERROR"
objMM.Body = sErrMsg & vbCrLf & vbCrLf & vbCrLf & sMailMessage
objMM.From = "xxxxxxxxx@xxx.com" <----ERROR here type string can't be converted
objMM.To = sErrorRecipient <------ERROR here property "to" is ReadOnly
objMM.Priority = MailPriority.High
SmtpMail.SmtpServer = sSMTPserver
SmtpMail.Send(objMM)
End If


Any help would be greatly appreciated

EDIT: Nevermind.. I think I solved this through some internet research. For those of you who have the same problem visit Mike's Blog

Source: http://www.livejournal.com/community/aspdotnet/47455.html