PDA

View Full Version : SQL Server does not exist or access denied

hoocha
07-04-2004, 01:21 AM
Hi,

I get this message when I try to insert rows into a number of tables in using a dataset on my web application

I am otherwise able to connect to the database, and I use selects statements with no problem. I have checked my Connection String, and even sued one give to me by support and it still gives this error. However, if I use the connection string from local webserver it writes to the database without a problem.

I suspect that the problem might lie with the way I have configured the other elements in web.config. Is there anything I need to do to get this running on DiscountASP.net?

Could this be a problem using datasets or permissions?

Any info greatly appreciated.
bruce
07-05-2004, 11:56 AM
Though it sounds like it is a login problem, this error usually means that the sql server is not found.

post your code snippet please.


[b]quote:Originally posted by hoocha

Hi,

I get this message when I try to insert rows into a number of tables in using a dataset on my web application, http://www.heavyenergy.com/caol.

I am otherwise able to connect to the database, and I use selects statements with no problem. I have checked my Connection String, and even sued one give to me by support and it still gives this error. However, if I use the connection string from local webserver it writes to the database without a problem.

I suspect that the problem might lie with the way I have configured the other elements in web.config. Is there anything I need to do to get this running on DiscountASP.net?

Could this be a problem using datasets or permissions?

Any info greatly appreciated.
</blockquote id="quote"></font id="quote">
hoocha
07-05-2004, 12:03 PM
This is my web.config...

<configuration>
<appSettings>
<add key="CAOLConnectionString" value="Data Source=mssql05.discountasp.net;Initial Catalog=DBNAME;User ID=heavyenergy;Password=********" />
</appSettings>
<system.web>
<compilation defaultLanguage="vb" debug="true" />
<customErrors mode="RemoteOnly" />
<identity impersonate="true" />
<authorization>
<allow users="*" /> <!-- Allow all users -->
</authorization>
<trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />
<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
</system.web>
</configuration>

And here is some code that gives the error. (just in case)

Dim tabArtisanMediums As DataTable
Dim rowArtisanMediums As DataRow

tabArtisanMediums = DataSet11.Tables("mediums")
For Each li As ListItem In cblMediums.Items
If li.Selected Then
rowArtisanMediums = tabArtisanMediums.NewRow
rowArtisanMediums("ArtisanID") = ID
rowArtisanMediums("MediumID") = li.Value
tabArtisanMediums.Rows.Add(rowArtisanMediums)
daAEMediums.Update(DataSet11)
End If
Next


I can successfully perform a select in code, and bind check box groups to data. But when it tries to insert (not tried update) a table it gives this error.

Many thanks


[b]quote:Originally posted by bruce

Though it sounds like it is a login problem, this error usually means that the sql server is not found.

post your code snippet please.


[b]quote:Originally posted by hoocha

Hi,

I get this message when I try to insert rows into a number of tables in using a dataset on my web application, http://www.heavyenergy.com/caol.

I am otherwise able to connect to the database, and I use selects statements with no problem. I have checked my Connection String, and even sued one give to me by support and it still gives this error. However, if I use the connection string from local webserver it writes to the database without a problem.

I suspect that the problem might lie with the way I have configured the other elements in web.config. Is there anything I need to do to get this running on DiscountASP.net?

Could this be a problem using datasets or permissions?

Any info greatly appreciated.
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">
bruce
07-06-2004, 12:43 PM
It is not quite possible that you can read but not insert.

Can you post the code that does the db connection as well?


[b]quote:Originally posted by hoocha

This is my web.config...

<configuration>
<appSettings>
<add key="CAOLConnectionString" value="Data Source=mssql05.discountasp.net;Initial Catalog=DBNAME;User ID=heavyenergy;Password=********" />
</appSettings>
<system.web>
<compilation defaultLanguage="vb" debug="true" />
<customErrors mode="RemoteOnly" />
<identity impersonate="true" />
<authorization>
<allow users="*" /> <!-- Allow all users -->
</authorization>
<trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />
<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
</system.web>
</configuration>

And here is some code that gives the error. (just in case)

Dim tabArtisanMediums As DataTable
Dim rowArtisanMediums As DataRow

tabArtisanMediums = DataSet11.Tables("mediums")
For Each li As ListItem In cblMediums.Items
If li.Selected Then
rowArtisanMediums = tabArtisanMediums.NewRow
rowArtisanMediums("ArtisanID") = ID
rowArtisanMediums("MediumID") = li.Value
tabArtisanMediums.Rows.Add(rowArtisanMediums)
daAEMediums.Update(DataSet11)
End If
Next


I can successfully perform a select in code, and bind check box groups to data. But when it tries to insert (not tried update) a table it gives this error.

Many thanks


[b]quote:Originally posted by bruce

Though it sounds like it is a login problem, this error usually means that the sql server is not found.

post your code snippet please.


[b]quote:Originally posted by hoocha

Hi,

I get this message when I try to insert rows into a number of tables in using a dataset on my web application, http://www.heavyenergy.com/caol.

I am otherwise able to connect to the database, and I use selects statements with no problem. I have checked my Connection String, and even sued one give to me by support and it still gives this error. However, if I use the connection string from local webserver it writes to the database without a problem.

I suspect that the problem might lie with the way I have configured the other elements in web.config. Is there anything I need to do to get this running on DiscountASP.net?

Could this be a problem using datasets or permissions?

Any info greatly appreciated.
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">
bruce
07-09-2004, 06:51 AM
This line is probably causing the problem

Me.SqlConnection1.ConnectionString = "workstation id=COMPAQ;packet size=4096;integrated security=SSPI;data source=COMPA" & _
"Q;persist security info=True;initial catalog=CAOL"
hoocha
07-09-2004, 12:21 PM
Thanks again Bruce,

I have attached all the vb code for this form....

Imports System.Data.SqlClient
Public Class WebForm1
Inherits System.Web.UI.Page

#Region " Web Form Designer Generated Code "

'This call is required by the Web Form Designer.
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
Me.SqlSelectCommand1 = New System.Data.SqlClient.SqlCommand
Me.SqlConnection1 = New System.Data.SqlClient.SqlConnection
Me.SqlInsertCommand1 = New System.Data.SqlClient.SqlCommand
Me.SqlUpdateCommand1 = New System.Data.SqlClient.SqlCommand
Me.SqlDeleteCommand1 = New System.Data.SqlClient.SqlCommand
Me.daArtisanEnquiry = New System.Data.SqlClient.SqlDataAdapter
Me.SqlSelectCommand2 = New System.Data.SqlClient.SqlCommand
Me.SqlInsertCommand2 = New System.Data.SqlClient.SqlCommand
Me.SqlUpdateCommand2 = New System.Data.SqlClient.SqlCommand
Me.SqlDeleteCommand2 = New System.Data.SqlClient.SqlCommand
Me.daCategory = New System.Data.SqlClient.SqlDataAdapter
Me.SqlSelectCommand6 = New System.Data.SqlClient.SqlCommand
Me.SqlInsertCommand6 = New System.Data.SqlClient.SqlCommand
Me.SqlUpdateCommand6 = New System.Data.SqlClient.SqlCommand
Me.SqlDeleteCommand6 = New System.Data.SqlClient.SqlCommand
Me.daNames = New System.Data.SqlClient.SqlDataAdapter
Me.SqlSelectCommand7 = New System.Data.SqlClient.SqlCommand
Me.SqlInsertCommand7 = New System.Data.SqlClient.SqlCommand
Me.SqlUpdateCommand7 = New System.Data.SqlClient.SqlCommand
Me.SqlDeleteCommand7 = New System.Data.SqlClient.SqlCommand
Me.daMediums = New System.Data.SqlClient.SqlDataAdapter
Me.SqlSelectCommand8 = New System.Data.SqlClient.SqlCommand
Me.SqlInsertCommand8 = New System.Data.SqlClient.SqlCommand
Me.SqlUpdateCommand8 = New System.Data.SqlClient.SqlCommand
Me.SqlDeleteCommand8 = New System.Data.SqlClient.SqlCommand
Me.daSalesChannels = New System.Data.SqlClient.SqlDataAdapter
Me.DataSet11 = New CAOL.DataSet1
Me.SqlSelectCommand3 = New System.Data.SqlClient.SqlCommand
Me.SqlInsertCommand3 = New System.Data.SqlClient.SqlCommand
Me.SqlUpdateCommand3 = New System.Data.SqlClient.SqlCommand
Me.SqlDeleteCommand3 = New System.Data.SqlClient.SqlCommand
Me.SqlSelectCommand4 = New System.Data.SqlClient.SqlCommand
Me.SqlInsertCommand4 = New System.Data.SqlClient.SqlCommand
Me.SqlUpdateCommand4 = New System.Data.SqlClient.SqlCommand
Me.SqlDeleteCommand4 = New System.Data.SqlClient.SqlCommand
Me.SqlSelectCommand5 = New System.Data.SqlClient.SqlCommand
Me.SqlInsertCommand5 = New System.Data.SqlClient.SqlCommand
Me.SqlUpdateCommand5 = New System.Data.SqlClient.SqlCommand
Me.SqlDeleteCommand5 = New System.Data.SqlClient.SqlCommand
Me.daAECategories = New System.Data.SqlClient.SqlDataAdapter
Me.daAESalesChannels = New System.Data.SqlClient.SqlDataAdapter
Me.daAEMediums = New System.Data.SqlClient.SqlDataAdapter
CType(Me.DataSet11, System.ComponentModel.ISupportInitialize).BeginIni t()
'
'SqlSelectCommand1
'
Me.SqlSelectCommand1.CommandText = "SELECT ID, CompanyName, Address, Town, Province, PostalCode, BusinessTel, HomeTel" & _
", CellTel, Fax, Email, Website, TradingSince, HowManyEmployed, SellOther, Medium" & _
"Other, CategoryOther, AboutMe, CommentOnThisForm FROM ArtisanEnquiry"
Me.SqlSelectCommand1.Connection = Me.SqlConnection1
'
'SqlConnection1 this is overriden in form load
'

Me.SqlConnection1.ConnectionString = "workstation id=COMPAQ;packet size=4096;integrated security=SSPI;data source=COMPA" & _
"Q;persist security info=True;initial catalog=CAOL"
'
'SqlInsertCommand1
'
Me.SqlInsertCommand1.CommandText = "INSERT INTO ArtisanEnquiry(CompanyName, Address, Town, Province, PostalCode, Busi" & _
"nessTel, HomeTel, CellTel, Fax, Email, Website, TradingSince, HowManyEmployed, S" & _
"ellOther, MediumOther, CategoryOther, AboutMe, CommentOnThisForm) VALUES (@Compa" & _
"nyName, @Address, @Town, @Province, @PostalCode, @BusinessTel, @HomeTel, @CellTe" & _
"l, @Fax, @Email, @Website, @TradingSince, @HowManyEmployed, @SellOther, @MediumO" & _
"ther, @CategoryOther, @AboutMe, @CommentOnThisForm); SELECT ID, CompanyName, Add" & _
"ress, Town, Province, PostalCode, BusinessTel, HomeTel, CellTel, Fax, Email, Web" & _
"site, TradingSince, HowManyEmployed, SellOther, MediumOther, CategoryOther, Abou" & _
"tMe, CommentOnThisForm FROM ArtisanEnquiry WHERE (ID = @@IDENTITY)"
Me.SqlInsertCommand1.Connection = Me.SqlConnection1
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CompanyName", System.Data.SqlDbType.VarChar, 50, "CompanyName"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Address", System.Data.SqlDbType.VarChar, 200, "Address"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Town", System.Data.SqlDbType.VarChar, 30, "Town"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Province", System.Data.SqlDbType.VarChar, 2, "Province"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@PostalCode", System.Data.SqlDbType.VarChar, 7, "PostalCode"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@BusinessTel", System.Data.SqlDbType.VarChar, 15, "BusinessTel"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@HomeTel", System.Data.SqlDbType.VarChar, 15, "HomeTel"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CellTel", System.Data.SqlDbType.VarChar, 15, "CellTel"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Fax", System.Data.SqlDbType.VarChar, 15, "Fax"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Email", System.Data.SqlDbType.VarChar, 200, "Email"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Website", System.Data.SqlDbType.VarChar, 200, "Website"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@TradingSince", System.Data.SqlDbType.DateTime, 8, "TradingSince"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@HowManyEmployed", System.Data.SqlDbType.SmallInt, 2, "HowManyEmployed"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@SellOther", System.Data.SqlDbType.VarChar, 50, "SellOther"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@MediumOther", System.Data.SqlDbType.VarChar, 50, "MediumOther"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CategoryOther", System.Data.SqlDbType.VarChar, 50, "CategoryOther"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@AboutMe", System.Data.SqlDbType.VarChar, 2000, "AboutMe"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CommentOnThisForm", System.Data.SqlDbType.VarChar, 500, "CommentOnThisForm"))
'
'SqlUpdateCommand1
'
Me.SqlUpdateCommand1.CommandText = "UPDATE ArtisanEnquiry SET CompanyName = @CompanyName, Address = @Address, Town = " & _
"@Town, Province = @Province, PostalCode = @PostalCode, BusinessTel = @BusinessTe" & _
"l, HomeTel = @HomeTel, CellTel = @CellTel, Fax = @Fax, Email = @Email, Website =" & _
" @Website, TradingSince = @TradingSince, HowManyEmployed = @HowManyEmployed, Sel" & _
"lOther = @SellOther, MediumOther = @MediumOther, CategoryOther = @CategoryOther," & _
" AboutMe = @AboutMe, CommentOnThisForm = @CommentOnThisForm WHERE (ID = @Origina" & _
"l_ID) AND (AboutMe = @Original_AboutMe OR @Original_AboutMe IS NULL AND AboutMe " & _
"IS NULL) AND (Address = @Original_Address OR @Original_Address IS NULL AND Addre" & _
"ss IS NULL) AND (BusinessTel = @Original_BusinessTel OR @Original_BusinessTel IS" & _
" NULL AND BusinessTel IS NULL) AND (CategoryOther = @Original_CategoryOther OR @" & _
"Original_CategoryOther IS NULL AND CategoryOther IS NULL) AND (CellTel = @Origin" & _
"al_CellTel OR @Original_CellTel IS NULL AND CellTel IS NULL) AND (CommentOnThisF" & _
"orm = @Original_CommentOnThisForm OR @Original_CommentOnThisForm IS NULL AND Com" & _
"mentOnThisForm IS NULL) AND (CompanyName = @Original_CompanyName OR @Original_Co" & _
"mpanyName IS NULL AND CompanyName IS NULL) AND (Email = @Original_Email OR @Orig" & _
"inal_Email IS NULL AND Email IS NULL) AND (Fax = @Original_Fax OR @Original_Fax " & _
"IS NULL AND Fax IS NULL) AND (HomeTel = @Original_HomeTel OR @Original_HomeTel I" & _
"S NULL AND HomeTel IS NULL) AND (HowManyEmployed = @Original_HowManyEmployed OR " & _
"@Original_HowManyEmployed IS NULL AND HowManyEmployed IS NULL) AND (MediumOther " & _
"= @Original_MediumOther OR @Original_MediumOther IS NULL AND MediumOther IS NULL" & _
") AND (PostalCode = @Original_PostalCode OR @Original_PostalCode IS NULL AND Pos" & _
"talCode IS NULL) AND (Province = @Original_Province OR @Original_Province IS NUL" & _
"L AND Province IS NULL) AND (SellOther = @Original_SellOther OR @Original_SellOt" & _
"her IS NULL AND SellOther IS NULL) AND (Town = @Original_Town OR @Original_Town " & _
"IS NULL AND Town IS NULL) AND (TradingSince = @Original_TradingSince OR @Origina" & _
"l_TradingSince IS NULL AND TradingSince IS NULL) AND (Website = @Original_Websit" & _
"e OR @Original_Website IS NULL AND Website IS NULL); SELECT ID, CompanyName, Add" & _
"ress, Town, Province, PostalCode, BusinessTel, HomeTel, CellTel, Fax, Email, Web" & _
"site, TradingSince, HowManyEmployed, SellOther, MediumOther, CategoryOther, Abou" & _
"tMe, CommentOnThisForm FROM ArtisanEnquiry WHERE (ID = @ID)"
Me.SqlUpdateCommand1.Connection = Me.SqlConnection1
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CompanyName", System.Data.SqlDbType.VarChar, 50, "CompanyName"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Address", System.Data.SqlDbType.VarChar, 200, "Address"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Town", System.Data.SqlDbType.VarChar, 30, "Town"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Province", System.Data.SqlDbType.VarChar, 2, "Province"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@PostalCode", System.Data.SqlDbType.VarChar, 7, "PostalCode"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@BusinessTel", System.Data.SqlDbType.VarChar, 15, "BusinessTel"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@HomeTel", System.Data.SqlDbType.VarChar, 15, "HomeTel"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CellTel", System.Data.SqlDbType.VarChar, 15, "CellTel"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Fax", System.Data.SqlDbType.VarChar, 15, "Fax"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Email", System.Data.SqlDbType.VarChar, 200, "Email"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Website", System.Data.SqlDbType.VarChar, 200, "Website"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@TradingSince", System.Data.SqlDbType.DateTime, 8, "TradingSince"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@HowManyEmployed", System.Data.SqlDbType.SmallInt, 2, "HowManyEmployed"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@SellOther", System.Data.SqlDbType.VarChar, 50, "SellOther"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@MediumOther", System.Data.SqlDbType.VarChar, 50, "MediumOther"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CategoryOther", System.Data.SqlDbType.VarChar, 50, "CategoryOther"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@AboutMe", System.Data.SqlDbType.VarChar, 2000, "AboutMe"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CommentOnThisForm", System.Data.SqlDbType.VarChar, 500, "CommentOnThisForm"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_AboutMe", System.Data.SqlDbType.VarChar, 2000, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "AboutMe", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Address", System.Data.SqlDbType.VarChar, 200, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Address", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_BusinessTel", System.Data.SqlDbType.VarChar, 15, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "BusinessTel", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_CategoryOther", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "CategoryOther", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_CellTel", System.Data.SqlDbType.VarChar, 15, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "CellTel", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_CommentOnThisForm", System.Data.SqlDbType.VarChar, 500, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "CommentOnThisForm", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_CompanyName", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "CompanyName", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Email", System.Data.SqlDbType.VarChar, 200, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Email", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Fax", System.Data.SqlDbType.VarChar, 15, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Fax", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_HomeTel", System.Data.SqlDbType.VarChar, 15, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "HomeTel", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_HowManyEmployed", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "HowManyEmployed", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_MediumOther", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "MediumOther", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_PostalCode", System.Data.SqlDbType.VarChar, 7, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "PostalCode", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Province", System.Data.SqlDbType.VarChar, 2, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Province", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_SellOther", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "SellOther", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Town", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Town", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_TradingSince", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "TradingSince", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Website", System.Data.SqlDbType.VarChar, 200, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Website", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"))
'
'SqlDeleteCommand1
'
Me.SqlDeleteCommand1.CommandText = "DELETE FROM ArtisanEnquiry WHERE (ID = @Original_ID) AND (AboutMe = @Original_Abo" & _
"utMe OR @Original_AboutMe IS NULL AND AboutMe IS NULL) AND (Address = @Original_" & _
"Address OR @Original_Address IS NULL AND Address IS NULL) AND (BusinessTel = @Or" & _
"iginal_BusinessTel OR @Original_BusinessTel IS NULL AND BusinessTel IS NULL) AND" & _
" (CategoryOther = @Original_CategoryOther OR @Original_CategoryOther IS NULL AND" & _
" CategoryOther IS NULL) AND (CellTel = @Original_CellTel OR @Original_CellTel IS" & _
" NULL AND CellTel IS NULL) AND (CommentOnThisForm = @Original_CommentOnThisForm " & _
"OR @Original_CommentOnThisForm IS NULL AND CommentOnThisForm IS NULL) AND (Compa" & _
"nyName = @Original_CompanyName OR @Original_CompanyName IS NULL AND CompanyName " & _
"IS NULL) AND (Email = @Original_Email OR @Original_Email IS NULL AND Email IS NU" & _
"LL) AND (Fax = @Original_Fax OR @Original_Fax IS NULL AND Fax IS NULL) AND (Home" & _
"Tel = @Original_HomeTel OR @Original_HomeTel IS NULL AND HomeTel IS NULL) AND (H" & _
"owManyEmployed = @Original_HowManyEmployed OR @Original_HowManyEmployed IS NULL " & _
"AND HowManyEmployed IS NULL) AND (MediumOther = @Original_MediumOther OR @Origin" & _
"al_MediumOther IS NULL AND MediumOther IS NULL) AND (PostalCode = @Original_Post" & _
"alCode OR @Original_PostalCode IS NULL AND PostalCode IS NULL) AND (Province = @" & _
"Original_Province OR @Original_Province IS NULL AND Province IS NULL) AND (SellO" & _
"ther = @Original_SellOther OR @Original_SellOther IS NULL AND SellOther IS NULL)" & _
" AND (Town = @Original_Town OR @Original_Town IS NULL AND Town IS NULL) AND (Tra" & _
"dingSince = @Original_TradingSince OR @Original_TradingSince IS NULL AND Trading" & _
"Since IS NULL) AND (Website = @Original_Website OR @Original_Website IS NULL AND" & _
" Website IS NULL)"
Me.SqlDeleteCommand1.Connection = Me.SqlConnection1
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_AboutMe", System.Data.SqlDbType.VarChar, 2000, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "AboutMe", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Address", System.Data.SqlDbType.VarChar, 200, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Address", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_BusinessTel", System.Data.SqlDbType.VarChar, 15, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "BusinessTel", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_CategoryOther", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "CategoryOther", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_CellTel", System.Data.SqlDbType.VarChar, 15, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "CellTel", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_CommentOnThisForm", System.Data.SqlDbType.VarChar, 500, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "CommentOnThisForm", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_CompanyName", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "CompanyName", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Email", System.Data.SqlDbType.VarChar, 200, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Email", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Fax", System.Data.SqlDbType.VarChar, 15, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Fax", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_HomeTel", System.Data.SqlDbType.VarChar, 15, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "HomeTel", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_HowManyEmployed", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "HowManyEmployed", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_MediumOther", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "MediumOther", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_PostalCode", System.Data.SqlDbType.VarChar, 7, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "PostalCode", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Province", System.Data.SqlDbType.VarChar, 2, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Province", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_SellOther", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "SellOther", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Town", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Town", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_TradingSince", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "TradingSince", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Website", System.Data.SqlDbType.VarChar, 200, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Website", System.Data.DataRowVersion.Original, Nothing))
'
'daArtisanEnquiry
'
Me.daArtisanEnquiry.DeleteCommand = Me.SqlDeleteCommand1
Me.daArtisanEnquiry.InsertCommand = Me.SqlInsertCommand1
Me.daArtisanEnquiry.SelectCommand = Me.SqlSelectCommand1
Me.daArtisanEnquiry.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "ArtisanEnquiry", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("ID", "ID"), New System.Data.Common.DataColumnMapping("CompanyName", "CompanyName"), New System.Data.Common.DataColumnMapping("Address", "Address"), New System.Data.Common.DataColumnMapping("Town", "Town"), New System.Data.Common.DataColumnMapping("Province", "Province"), New System.Data.Common.DataColumnMapping("PostalCode", "PostalCode"), New System.Data.Common.DataColumnMapping("BusinessTel", "BusinessTel"), New System.Data.Common.DataColumnMapping("HomeTel", "HomeTel"), New System.Data.Common.DataColumnMapping("CellTel", "CellTel"), New System.Data.Common.DataColumnMapping("Fax", "Fax"), New System.Data.Common.DataColumnMapping("Email", "Email"), New System.Data.Common.DataColumnMapping("Website", "Website"), New System.Data.Common.DataColumnMapping("TradingSince", "TradingSince"), New System.Data.Common.DataColumnMapping("HowManyEmployed", "HowManyEmployed"), New System.Data.Common.DataColumnMapping("SellOther", "SellOther"), New System.Data.Common.DataColumnMapping("MediumOther", "MediumOther"), New System.Data.Common.DataColumnMapping("CategoryOther", "CategoryOther"), New System.Data.Common.DataColumnMapping("AboutMe", "AboutMe"), New System.Data.Common.DataColumnMapping("CommentOnThisForm", "CommentOnThisForm")})})
Me.daArtisanEnquiry.UpdateCommand = Me.SqlUpdateCommand1
'
'SqlSelectCommand2
'
Me.SqlSelectCommand2.CommandText = "SELECT ID, Category FROM ArtisanCategory ORDER BY Category"
Me.SqlSelectCommand2.Connection = Me.SqlConnection1
'
'SqlInsertCommand2
'
Me.SqlInsertCommand2.CommandText = "INSERT INTO ArtisanCategory(Category) VALUES (@Category); SELECT ID, Category FRO" & _
"M ArtisanCategory WHERE (ID = @@IDENTITY)"
Me.SqlInsertCommand2.Connection = Me.SqlConnection1
Me.SqlInsertCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Category", System.Data.SqlDbType.VarChar, 30, "Category"))
'
'SqlUpdateCommand2
'
Me.SqlUpdateCommand2.CommandText = "UPDATE ArtisanCategory SET Category = @Category WHERE (ID = @Original_ID) AND (Ca" & _
"tegory = @Original_Category OR @Original_Category IS NULL AND Category IS NULL);" & _
" SELECT ID, Category FROM ArtisanCategory WHERE (ID = @ID)"
Me.SqlUpdateCommand2.Connection = Me.SqlConnection1
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Category", System.Data.SqlDbType.VarChar, 30, "Category"))
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Category", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Category", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"))
'
'SqlDeleteCommand2
'
Me.SqlDeleteCommand2.CommandText = "DELETE FROM ArtisanCategory WHERE (ID = @Original_ID) AND (Category = @Original_C" & _
"ategory OR @Original_Category IS NULL AND Category IS NULL)"
Me.SqlDeleteCommand2.Connection = Me.SqlConnection1
Me.SqlDeleteCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Category", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Category", System.Data.DataRowVersion.Original, Nothing))
'
'daCategory
'
Me.daCategory.DeleteCommand = Me.SqlDeleteCommand2
Me.daCategory.InsertCommand = Me.SqlInsertCommand2
Me.daCategory.SelectCommand = Me.SqlSelectCommand2
Me.daCategory.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "ArtisanCategory", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("ID", "ID"), New System.Data.Common.DataColumnMapping("Category", "Category")})})
Me.daCategory.UpdateCommand = Me.SqlUpdateCommand2
'
'SqlSelectCommand6
'
Me.SqlSelectCommand6.CommandText = "SELECT ID, ArtisanID, FirstName, LastName FROM ArtisanNames"
Me.SqlSelectCommand6.Connection = Me.SqlConnection1
'
'SqlInsertCommand6
'
Me.SqlInsertCommand6.CommandText = "INSERT INTO ArtisanNames(ArtisanID, FirstName, LastName) VALUES (@ArtisanID, @Fir" & _
"stName, @LastName); SELECT ID, ArtisanID, FirstName, LastName FROM ArtisanNames " & _
"WHERE (ID = @@IDENTITY)"
Me.SqlInsertCommand6.Connection = Me.SqlConnection1
Me.SqlInsertCommand6.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ArtisanID", System.Data.SqlDbType.Int, 4, "ArtisanID"))
Me.SqlInsertCommand6.Parameters.Add(New System.Data.SqlClient.SqlParameter("@FirstName", System.Data.SqlDbType.VarChar, 20, "FirstName"))
Me.SqlInsertCommand6.Parameters.Add(New System.Data.SqlClient.SqlParameter("@LastName", System.Data.SqlDbType.VarChar, 20, "LastName"))
'
'SqlUpdateCommand6
'
Me.SqlUpdateCommand6.CommandText = "UPDATE ArtisanNames SET ArtisanID = @ArtisanID, FirstName = @FirstName, LastName " & _
"= @LastName WHERE (ID = @Original_ID) AND (ArtisanID = @Original_ArtisanID OR @O" & _
"riginal_ArtisanID IS NULL AND ArtisanID IS NULL) AND (FirstName = @Original_Firs" & _
"tName OR @Original_FirstName IS NULL AND FirstName IS NULL) AND (LastName = @Ori" & _
"ginal_LastName OR @Original_LastName IS NULL AND LastName IS NULL); SELECT ID, A" & _
"rtisanID, FirstName, LastName FROM ArtisanNames WHERE (ID = @ID)"
Me.SqlUpdateCommand6.Connection = Me.SqlConnection1
Me.SqlUpdateCommand6.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ArtisanID", System.Data.SqlDbType.Int, 4, "ArtisanID"))
Me.SqlUpdateCommand6.Parameters.Add(New System.Data.SqlClient.SqlParameter("@FirstName", System.Data.SqlDbType.VarChar, 20, "FirstName"))
Me.SqlUpdateCommand6.Parameters.Add(New System.Data.SqlClient.SqlParameter("@LastName", System.Data.SqlDbType.VarChar, 20, "LastName"))
Me.SqlUpdateCommand6.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand6.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ArtisanID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ArtisanID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand6.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_FirstName", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "FirstName", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand6.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_LastName", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "LastName", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand6.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"))
'
'SqlDeleteCommand6
'
Me.SqlDeleteCommand6.CommandText = "DELETE FROM ArtisanNames WHERE (ID = @Original_ID) AND (ArtisanID = @Original_Art" & _
"isanID OR @Original_ArtisanID IS NULL AND ArtisanID IS NULL) AND (FirstName = @O" & _
"riginal_FirstName OR @Original_FirstName IS NULL AND FirstName IS NULL) AND (Las" & _
"tName = @Original_LastName OR @Original_LastName IS NULL AND LastName IS NULL)"
Me.SqlDeleteCommand6.Connection = Me.SqlConnection1
Me.SqlDeleteCommand6.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand6.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ArtisanID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ArtisanID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand6.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_FirstName", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "FirstName", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand6.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_LastName", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "LastName", System.Data.DataRowVersion.Original, Nothing))
'
'daNames
'
Me.daNames.DeleteCommand = Me.SqlDeleteCommand6
Me.daNames.InsertCommand = Me.SqlInsertCommand6
Me.daNames.SelectCommand = Me.SqlSelectCommand6
Me.daNames.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "ArtisanNames", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("ID", "ID"), New System.Data.Common.DataColumnMapping("ArtisanID", "ArtisanID"), New System.Data.Common.DataColumnMapping("FirstName", "FirstName"), New System.Data.Common.DataColumnMapping("LastName", "LastName")})})
Me.daNames.UpdateCommand = Me.SqlUpdateCommand6
'
'SqlSelectCommand7
'
Me.SqlSelectCommand7.CommandText = "SELECT ID, Medium FROM Mediums ORDER BY Medium"
Me.SqlSelectCommand7.Connection = Me.SqlConnection1
'
'SqlInsertCommand7
'
Me.SqlInsertCommand7.CommandText = "INSERT INTO Mediums(Medium) VALUES (@Medium); SELECT ID, Medium FROM Mediums WHER" & _
"E (ID = @@IDENTITY)"
Me.SqlInsertCommand7.Connection = Me.SqlConnection1
Me.SqlInsertCommand7.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Medium", System.Data.SqlDbType.VarChar, 30, "Medium"))
'
'SqlUpdateCommand7
'
Me.SqlUpdateCommand7.CommandText = "UPDATE Mediums SET Medium = @Medium WHERE (ID = @Original_ID) AND (Medium = @Orig" & _
"inal_Medium OR @Original_Medium IS NULL AND Medium IS NULL); SELECT ID, Medium F" & _
"ROM Mediums WHERE (ID = @ID)"
Me.SqlUpdateCommand7.Connection = Me.SqlConnection1
Me.SqlUpdateCommand7.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Medium", System.Data.SqlDbType.VarChar, 30, "Medium"))
Me.SqlUpdateCommand7.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand7.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Medium", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Medium", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand7.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"))
'
'SqlDeleteCommand7
'
Me.SqlDeleteCommand7.CommandText = "DELETE FROM Mediums WHERE (ID = @Original_ID) AND (Medium = @Original_Medium OR @" & _
"Original_Medium IS NULL AND Medium IS NULL)"
Me.SqlDeleteCommand7.Connection = Me.SqlConnection1
Me.SqlDeleteCommand7.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand7.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Medium", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Medium", System.Data.DataRowVersion.Original, Nothing))
'
'daMediums
'
Me.daMediums.DeleteCommand = Me.SqlDeleteCommand7
Me.daMediums.InsertCommand = Me.SqlInsertCommand7
Me.daMediums.SelectCommand = Me.SqlSelectCommand7
Me.daMediums.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "Mediums", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("ID", "ID"), New System.Data.Common.DataColumnMapping("Medium", "Medium")})})
Me.daMediums.UpdateCommand = Me.SqlUpdateCommand7
'
'SqlSelectCommand8
'
Me.SqlSelectCommand8.CommandText = "SELECT ID, SalesChannel FROM SalesChannels ORDER BY SalesChannel"
Me.SqlSelectCommand8.Connection = Me.SqlConnection1
'
'SqlInsertCommand8
'
Me.SqlInsertCommand8.CommandText = "INSERT INTO SalesChannels(SalesChannel) VALUES (@SalesChannel); SELECT ID, SalesC" & _
"hannel FROM SalesChannels WHERE (ID = @@IDENTITY)"
Me.SqlInsertCommand8.Connection = Me.SqlConnection1
Me.SqlInsertCommand8.Parameters.Add(New System.Data.SqlClient.SqlParameter("@SalesChannel", System.Data.SqlDbType.VarChar, 30, "SalesChannel"))
'
'SqlUpdateCommand8
'
Me.SqlUpdateCommand8.CommandText = "UPDATE SalesChannels SET SalesChannel = @SalesChannel WHERE (ID = @Original_ID) A" & _
"ND (SalesChannel = @Original_SalesChannel OR @Original_SalesChannel IS NULL AND " & _
"SalesChannel IS NULL); SELECT ID, SalesChannel FROM SalesChannels WHERE (ID = @I" & _
"D)"
Me.SqlUpdateCommand8.Connection = Me.SqlConnection1
Me.SqlUpdateCommand8.Parameters.Add(New System.Data.SqlClient.SqlParameter("@SalesChannel", System.Data.SqlDbType.VarChar, 30, "SalesChannel"))
Me.SqlUpdateCommand8.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand8.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_SalesChannel", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "SalesChannel", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand8.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"))
'
'SqlDeleteCommand8
'
Me.SqlDeleteCommand8.CommandText = "DELETE FROM SalesChannels WHERE (ID = @Original_ID) AND (SalesChannel = @Original" & _
"_SalesChannel OR @Original_SalesChannel IS NULL AND SalesChannel IS NULL)"
Me.SqlDeleteCommand8.Connection = Me.SqlConnection1
Me.SqlDeleteCommand8.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand8.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_SalesChannel", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "SalesChannel", System.Data.DataRowVersion.Original, Nothing))
'
'daSalesChannels
'
Me.daSalesChannels.DeleteCommand = Me.SqlDeleteCommand8
Me.daSalesChannels.InsertCommand = Me.SqlInsertCommand8
Me.daSalesChannels.SelectCommand = Me.SqlSelectCommand8
Me.daSalesChannels.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "SalesChannels", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("ID", "ID"), New System.Data.Common.DataColumnMapping("SalesChannel", "SalesChannel")})})
Me.daSalesChannels.UpdateCommand = Me.SqlUpdateCommand8
'
'DataSet11
'
Me.DataSet11.DataSetName = "DataSet1"
Me.DataSet11.Locale = New System.Globalization.CultureInfo("en-GB")
'
'SqlSelectCommand3
'
Me.SqlSelectCommand3.CommandText = "SELECT ID, ArtisanID, CategoryID FROM ArtisanEnquiryCategories"
Me.SqlSelectCommand3.Connection = Me.SqlConnection1
'
'SqlInsertCommand3
'
Me.SqlInsertCommand3.CommandText = "INSERT INTO ArtisanEnquiryCategories(ArtisanID, CategoryID) VALUES (@ArtisanID, @" & _
"CategoryID); SELECT ID, ArtisanID, CategoryID FROM ArtisanEnquiryCategories WHER" & _
"E (ID = @@IDENTITY)"
Me.SqlInsertCommand3.Connection = Me.SqlConnection1
Me.SqlInsertCommand3.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ArtisanID", System.Data.SqlDbType.Int, 4, "ArtisanID"))
Me.SqlInsertCommand3.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CategoryID", System.Data.SqlDbType.Int, 4, "CategoryID"))
'
'SqlUpdateCommand3
'
Me.SqlUpdateCommand3.CommandText = "UPDATE ArtisanEnquiryCategories SET ArtisanID = @ArtisanID, CategoryID = @Categor" & _
"yID WHERE (ID = @Original_ID) AND (ArtisanID = @Original_ArtisanID) AND (Categor" & _
"yID = @Original_CategoryID); SELECT ID, ArtisanID, CategoryID FROM ArtisanEnquir" & _
"yCategories WHERE (ID = @ID)"
Me.SqlUpdateCommand3.Connection = Me.SqlConnection1
Me.SqlUpdateCommand3.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ArtisanID", System.Data.SqlDbType.Int, 4, "ArtisanID"))
Me.SqlUpdateCommand3.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CategoryID", System.Data.SqlDbType.Int, 4, "CategoryID"))
Me.SqlUpdateCommand3.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand3.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ArtisanID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ArtisanID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand3.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_CategoryID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "CategoryID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand3.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"))
'
'SqlDeleteCommand3
'
Me.SqlDeleteCommand3.CommandText = "DELETE FROM ArtisanEnquiryCategories WHERE (ID = @Original_ID) AND (ArtisanID = @" & _
"Original_ArtisanID) AND (CategoryID = @Original_CategoryID)"
Me.SqlDeleteCommand3.Connection = Me.SqlConnection1
Me.SqlDeleteCommand3.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand3.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ArtisanID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ArtisanID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand3.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_CategoryID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "CategoryID", System.Data.DataRowVersion.Original, Nothing))
'
'SqlSelectCommand4
'
Me.SqlSelectCommand4.CommandText = "SELECT ID, ArtisanID, SalesChannelID FROM ArtisanEnquirySalesChannels"
Me.SqlSelectCommand4.Connection = Me.SqlConnection1
'
'SqlInsertCommand4
'
Me.SqlInsertCommand4.CommandText = "INSERT INTO ArtisanEnquirySalesChannels(ArtisanID, SalesChannelID) VALUES (@Artis" & _
"anID, @SalesChannelID); SELECT ID, ArtisanID, SalesChannelID FROM ArtisanEnquiry" & _
"SalesChannels WHERE (ID = @@IDENTITY)"
Me.SqlInsertCommand4.Connection = Me.SqlConnection1
Me.SqlInsertCommand4.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ArtisanID", System.Data.SqlDbType.Int, 4, "ArtisanID"))
Me.SqlInsertCommand4.Parameters.Add(New System.Data.SqlClient.SqlParameter("@SalesChannelID", System.Data.SqlDbType.Int, 4, "SalesChannelID"))
'
'SqlUpdateCommand4
'
Me.SqlUpdateCommand4.CommandText = "UPDATE ArtisanEnquirySalesChannels SET ArtisanID = @ArtisanID, SalesChannelID = @" & _
"SalesChannelID WHERE (ID = @Original_ID) AND (ArtisanID = @Original_ArtisanID) A" & _
"ND (SalesChannelID = @Original_SalesChannelID); SELECT ID, ArtisanID, SalesChann" & _
"elID FROM ArtisanEnquirySalesChannels WHERE (ID = @ID)"
Me.SqlUpdateCommand4.Connection = Me.SqlConnection1
Me.SqlUpdateCommand4.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ArtisanID", System.Data.SqlDbType.Int, 4, "ArtisanID"))
Me.SqlUpdateCommand4.Parameters.Add(New System.Data.SqlClient.SqlParameter("@SalesChannelID", System.Data.SqlDbType.Int, 4, "SalesChannelID"))
Me.SqlUpdateCommand4.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand4.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ArtisanID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ArtisanID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand4.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_SalesChannelID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "SalesChannelID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand4.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"))
'
'SqlDeleteCommand4
'
Me.SqlDeleteCommand4.CommandText = "DELETE FROM ArtisanEnquirySalesChannels WHERE (ID = @Original_ID) AND (ArtisanID " & _
"= @Original_ArtisanID) AND (SalesChannelID = @Original_SalesChannelID)"
Me.SqlDeleteCommand4.Connection = Me.SqlConnection1
Me.SqlDeleteCommand4.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand4.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ArtisanID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ArtisanID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand4.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_SalesChannelID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "SalesChannelID", System.Data.DataRowVersion.Original, Nothing))
'
'SqlSelectCommand5
'
Me.SqlSelectCommand5.CommandText = "SELECT ID, ArtisanID, MediumID FROM ArtisanEnquiryMediums"
Me.SqlSelectCommand5.Connection = Me.SqlConnection1
'
'SqlInsertCommand5
'
Me.SqlInsertCommand5.CommandText = "INSERT INTO ArtisanEnquiryMediums(ArtisanID, MediumID) VALUES (@ArtisanID, @Mediu" & _
"mID); SELECT ID, ArtisanID, MediumID FROM ArtisanEnquiryMediums WHERE (ID = @@ID" & _
"ENTITY)"
Me.SqlInsertCommand5.Connection = Me.SqlConnection1
Me.SqlInsertCommand5.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ArtisanID", System.Data.SqlDbType.Int, 4, "ArtisanID"))
Me.SqlInsertCommand5.Parameters.Add(New System.Data.SqlClient.SqlParameter("@MediumID", System.Data.SqlDbType.Int, 4, "MediumID"))
'
'SqlUpdateCommand5
'
Me.SqlUpdateCommand5.CommandText = "UPDATE ArtisanEnquiryMediums SET ArtisanID = @ArtisanID, MediumID = @MediumID WHE" & _
"RE (ID = @Original_ID) AND (ArtisanID = @Original_ArtisanID) AND (MediumID = @Or" & _
"iginal_MediumID); SELECT ID, ArtisanID, MediumID FROM ArtisanEnquiryMediums WHER" & _
"E (ID = @ID)"
Me.SqlUpdateCommand5.Connection = Me.SqlConnection1
Me.SqlUpdateCommand5.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ArtisanID", System.Data.SqlDbType.Int, 4, "ArtisanID"))
Me.SqlUpdateCommand5.Parameters.Add(New System.Data.SqlClient.SqlParameter("@MediumID", System.Data.SqlDbType.Int, 4, "MediumID"))
Me.SqlUpdateCommand5.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand5.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ArtisanID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ArtisanID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand5.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_MediumID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "MediumID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand5.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"))
'
'SqlDeleteCommand5
'
Me.SqlDeleteCommand5.CommandText = "DELETE FROM ArtisanEnquiryMediums WHERE (ID = @Original_ID) AND (ArtisanID = @Ori" & _
"ginal_ArtisanID) AND (MediumID = @Original_MediumID)"
Me.SqlDeleteCommand5.Connection = Me.SqlConnection1
Me.SqlDeleteCommand5.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand5.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ArtisanID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ArtisanID", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand5.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_MediumID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "MediumID", System.Data.DataRowVersion.Original, Nothing))
'
'daAECategories
'
Me.daAECategories.DeleteCommand = Me.SqlDeleteCommand3
Me.daAECategories.InsertCommand = Me.SqlInsertCommand3
Me.daAECategories.SelectCommand = Me.SqlSelectCommand3
Me.daAECategories.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "ArtisanEnquiryCategories", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("ID", "ID"), New System.Data.Common.DataColumnMapping("ArtisanID", "ArtisanID"), New System.Data.Common.DataColumnMapping("CategoryID", "CategoryID")})})
Me.daAECategories.UpdateCommand = Me.SqlUpdateCommand3
'
'daAESalesChannels
'
Me.daAESalesChannels.DeleteCommand = Me.SqlDeleteCommand4
Me.daAESalesChannels.InsertCommand = Me.SqlInsertCommand4
Me.daAESalesChannels.SelectCommand = Me.SqlSelectCommand4
Me.daAESalesChannels.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "ArtisanEnquirySalesChannels", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("ID", "ID"), New System.Data.Common.DataColumnMapping("ArtisanID", "ArtisanID"), New System.Data.Common.DataColumnMapping("SalesChannelID", "SalesChannelID")})})
Me.daAESalesChannels.UpdateCommand = Me.SqlUpdateCommand4
'
'daAEMediums
'
Me.daAEMediums.DeleteCommand = Me.SqlDeleteCommand5
Me.daAEMediums.InsertCommand = Me.SqlInsertCommand5
Me.daAEMediums.SelectCommand = Me.SqlSelectCommand5
Me.daAEMediums.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "ArtisanEnquiryMediums", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("ID", "ID"), New System.Data.Common.DataColumnMapping("ArtisanID", "ArtisanID"), New System.Data.Common.DataColumnMapping("MediumID", "MediumID")})})
Me.daAEMediums.UpdateCommand = Me.SqlUpdateCommand5
CType(Me.DataSet11, System.ComponentModel.ISupportInitialize).EndInit( )

End Sub
Protected WithEvents ddlProvince As System.Web.UI.WebControls.DropDownList
Protected WithEvents Panel2 As System.Web.UI.WebControls.Panel
Protected WithEvents Panel3 As System.Web.UI.WebControls.Panel
Protected WithEvents LinkButton1 As System.Web.UI.WebControls.LinkButton
Protected WithEvents LinkButton2 As System.Web.UI.WebControls.LinkButton
Protected WithEvents LinkButton4 As System.Web.UI.WebControls.LinkButton
Protected WithEvents LinkButton5 As System.Web.UI.WebControls.LinkButton
Protected WithEvents txtTradingSince As System.Web.UI.WebControls.TextBox
Protected WithEvents txtEmployees As System.Web.UI.WebControls.TextBox
Protected WithEvents cblSell As System.Web.UI.WebControls.CheckBoxList
Protected WithEvents cblMediums As System.Web.UI.WebControls.CheckBoxList
Protected WithEvents txtMediums As System.Web.UI.WebControls.TextBox
Protected WithEvents cblCategory As System.Web.UI.WebControls.CheckBoxList
Protected WithEvents txtCategory As System.Web.UI.WebControls.TextBox
Protected WithEvents txtAboutMe As System.Web.UI.WebControls.TextBox
Protected WithEvents txtMissed As System.Web.UI.WebControls.TextBox
Protected WithEvents txtCompany As System.Web.UI.WebControls.TextBox
Protected WithEvents txtAddress As System.Web.UI.WebControls.TextBox
Protected WithEvents txtTown As System.Web.UI.WebControls.TextBox
Protected WithEvents txtPostalCode As System.Web.UI.WebControls.TextBox
Protected WithEvents txtBusPhone As System.Web.UI.WebControls.TextBox
Protected WithEvents txtHomePhone As System.Web.UI.WebControls.TextBox
Protected WithEvents txtCellPhone As System.Web.UI.WebControls.TextBox
Protected WithEvents txtFax As System.Web.UI.WebControls.TextBox
Protected WithEvents txtEmail As System.Web.UI.WebControls.TextBox
Protected WithEvents txtWeb As System.Web.UI.WebControls.TextBox
Protected WithEvents Panel4 As System.Web.UI.WebControls.Panel
Protected WithEvents txtSales As System.Web.UI.WebControls.TextBox
Protected WithEvents SqlSelectCommand1 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlInsertCommand1 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlUpdateCommand1 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlDeleteCommand1 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlConnection1 As System.Data.SqlClient.SqlConnection
Protected WithEvents daArtisanEnquiry As System.Data.SqlClient.SqlDataAdapter
Protected WithEvents SqlSelectCommand2 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlInsertCommand2 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlUpdateCommand2 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlDeleteCommand2 As System.Data.SqlClient.SqlCommand
Protected WithEvents daCategory As System.Data.SqlClient.SqlDataAdapter
Protected WithEvents SqlSelectCommand6 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlInsertCommand6 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlUpdateCommand6 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlDeleteCommand6 As System.Data.SqlClient.SqlCommand
Protected WithEvents daNames As System.Data.SqlClient.SqlDataAdapter
Protected WithEvents SqlSelectCommand7 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlInsertCommand7 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlUpdateCommand7 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlDeleteCommand7 As System.Data.SqlClient.SqlCommand
Protected WithEvents daMediums As System.Data.SqlClient.SqlDataAdapter
Protected WithEvents SqlSelectCommand8 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlInsertCommand8 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlUpdateCommand8 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlDeleteCommand8 As System.Data.SqlClient.SqlCommand
Protected WithEvents daSalesChannels As System.Data.SqlClient.SqlDataAdapter
Protected WithEvents DataSet11 As CAOL.DataSet1
Protected WithEvents SqlSelectCommand3 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlInsertCommand3 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlUpdateCommand3 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlDeleteCommand3 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlSelectCommand4 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlInsertCommand4 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlUpdateCommand4 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlDeleteCommand4 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlSelectCommand5 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlInsertCommand5 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlUpdateCommand5 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlDeleteCommand5 As System.Data.SqlClient.SqlCommand
Protected WithEvents daAECategories As System.Data.SqlClient.SqlDataAdapter
Protected WithEvents daAEMediums As System.Data.SqlClient.SqlDataAdapter
Protected WithEvents daAESalesChannels As System.Data.SqlClient.SqlDataAdapter
Protected WithEvents RequiredFieldValidator1 As System.Web.UI.WebControls.RequiredFieldValidator
Protected WithEvents RequiredFieldValidator2 As System.Web.UI.WebControls.RequiredFieldValidator
Protected WithEvents RequiredFieldValidator3 As System.Web.UI.WebControls.RequiredFieldValidator
Protected WithEvents RequiredFieldValidator4 As System.Web.UI.WebControls.RequiredFieldValidator
Protected WithEvents RequiredFieldValidator5 As System.Web.UI.WebControls.RequiredFieldValidator
Protected WithEvents RequiredFieldValidator6 As System.Web.UI.We
hoocha
07-10-2004, 02:16 AM
Thanks Bruce....you are absolutely right. I can see exactly what I did!

I declared by alternative connection string in A "if not postback" block of code. The result of this was that when the page originally loads it does some DB selects and they work fine, but when it posts back, the original connection string is restored...when I eventually get to my submit page I am trying to connect to the database on my development machine as opposed to the Db on the site.

This will explain why my code worked on my local environment but not DiscountASP's servers.

I don't know how I missed it.

Thanks for the help.

Tone