How To Use &<asp:SqlDataSource&> With Ole Database
Apr 24, 2008
Hi all,
I used to use <asp:SqlDataSource as a data suorce to my gridviews in the client side, but now I'm using access database.
Is there any way to use the same feauter with Ole Database connection, this is a sample from my <asp:SqlDataSource:
<asp:GridView ID="OrderGridView" runat="server" AutoGenerateColumns="False" DataSourceID="OrderSqlDataSource">
<asp:SqlDataSource ID="OrderPrintSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:iainternetConnectionString %>"
SelectCommand="SELECT * FROM @tblOrder">
<SelectParameters>
<asp:QueryStringParameter Name="tblOrder" QueryStringField="tbl" />
</SelectParameters>
</asp:SqlDataSource>
any ideas to solve this. thanks.
View 5 Replies
ADVERTISEMENT
Apr 25, 2007
Hello,
Is it possible to access both my database and the ASPNETDB within the same SQLDATASOURCE using SQL Express ?
I want to pull out some user details from the aspnet_* tables within the ASPNETDB
In my database I have created the 'UserId' fields so the relevant joins can take place.
In my web.config:
<connectionStrings>
<add name="mydb" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|mydb.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
</connectionStrings>
In my asp (showing only mydb):
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:mydb %>"
SelectCommand="SELECT [CreateDtTime], [UserId], [Comment] FROM [Log_Dtl] WHERE ([LogId] = @LogId)">
<SelectParameters>
<asp:QueryStringParameter Name="LogId" QueryStringField="LogId" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
Any help would be appreciated.
Thank you
Lee
View 1 Replies
View Related
Sep 13, 2006
HiI have a table in my database called 'tblUsers'It contains usernames and a few columns of data.One of them in 'birthday'it is in the format dd/mm (ie 28/04 is 28th of april)it is always 5 characters longIts data type is char in my db.Now I try this<asp:SqlDataSource ID="SqlDataSource8" runat="server" ConnectionString="<%$ ConnectionStrings:IntranetConnectionString %>" SelectCommand="SELECT DisplayName FROM [tblUsers] WHERE ([Birthday] = @ShortDate)"> <SelectParameters> <asp:ControlParameter ControlID="Calendar1" Name="ShortDate" PropertyName="SelectedDate" Type="string" /> </SelectParameters> </asp:SqlDataSource>where the selected date from a calendar control is used.Now it works when the table has a Date column which is off type DateTime but how would I modify it to work like I want?Thanks!
View 3 Replies
View Related
Mar 27, 2007
A collegue of mine, came with the idea of using the SqlDataSource to connect to an Access database.
Is this good practice?
View 1 Replies
View Related
Sep 12, 2007
Hi,I am trying to upload a file to a database. I have all the code set up but I get this error message: Operand type clash: nvarchar is incompatible with image The following is the code that I have: 1 If FileUpload1.PostedFile Is Nothing OrElse String.IsNullOrEmpty(FileUpload1.PostedFile.FileName) OrElse FileUpload1.PostedFile.InputStream Is Nothing Then
2 lblInfo.Text = "No file selected"
3 Exit Sub
4 End If
5
6 Dim extension As String = Path.GetExtension(FileUpload1.PostedFile.FileName).ToLower()
7 Dim MIMEType As String = Nothing
8
9 Select Case extension
10 Case ".gif"
11 MIMEType = "image/gif"
12 Case ".jpg", ".jpeg", ".jpe"
13 MIMEType = "image/jpeg"
14 Case ".pdf"
15 MIMEType = "application/pdf"
16 Case ".doc"
17 MIMEType = "application/msword"
18 Case ".swf"
19 MIMEType = "application/x-shockwave-flash"
20 Case ".txt", ".html"
21 MIMEType = "text/plain"
22 Case Else
23 lblInfo.Text = "Invalid file upload"
24 Exit Sub
25 End Select
26
27 Dim imageByte(FileUpload1.PostedFile.InputStream.Length) As Byte
28 FileUpload1.PostedFile.InputStream.Read(imageByte, 0, imageByte.Length)
29
30 sqlInsert = "INSERT INTO Pages (MIMEType, ImageData) VALUES (@MIMEType, @ImageData)"
31 SqlDataSource1.InsertCommand = sqlInsert
32 SqlDataSource1.InsertParameters.Add("MIMEType", MIMEType.ToString.Trim)
33 SqlDataSource1.InsertParameters.Add("ImageData", imageByte.ToString)
34 SqlDataSource1.InsertCommand = sqlInsert
35 SqlDataSource1.Insert()
36 SqlDataSource1.InsertParameters.Clear()I problem happen at line 33. I have tried using sqldatasource1.InsertParameters.add("ImageData", imageByte), it doesn't like it.Please help
View 2 Replies
View Related
Oct 23, 2007
Hello,
I have specified a default database in my web.config like this:
<dataConfiguration defaultDatabase="scsLocal"/>
<connectionStrings> <add name="scsLocal" connectionString="server=DRLSWARTEBRV;database=SCS;uid=******;password=******;" providerName="System.Data.SqlClient"/>
</connectionStrings>
Now I would like to configure a SQLDataSource control to use this default database, yet it prompts me for a connectionstring. I know I can program it in the code behind file (if I ommit connection string, it will use the default), but then I can make no use of the wizard for configuring the SQLDataSource which would safe me a lot of coding.
Is there a way to configure the SQLDataSource to use the default database that is specified in the web.config?
Thanks!
Veerle
View 1 Replies
View Related
Jan 18, 2008
I want to create a table in a SQL-database, and I'm wondering how to do it in Visual Studio 2005. Is it possible to create a table using an SQL-query in the SqlDataSource wizard?
Or, in general... what would be the best way to create a database table from VS2005?
View 4 Replies
View Related
Jan 31, 2008
Hey all Im trying to make a system in which users logged on can change their password. I dont want to use a grid view because that dosent give me the chance to let them put in their old password first for validation but now I need a way of takeing data out of the textbox with the new password and placeing it in to the field in a database.As I stand at the moment I have a data.dataview variable equal to an SQL Data Source with my query in it, bringing back a record from a users table with the users username, password and a field stating what type of user they are. It filters this by username which is stored as a session variable and username is the primary key. there is then an if statement checking that the string in the password field is equal to what the user has written in the old password box and if they match it uses the command:dv.Table.Rows(0)(1) = txtNewPassword.TextMsgBox("Password Successfully Changed", MsgBoxStyle.Information)When I run this the validation successfully checks the password is correct and then displays the message box saying the password is correct but it hasnt actually changed it. Somone I know told me that I need to use the command sqldatasource.update but I cant see where it fits in. Anyone got any ideas?
View 2 Replies
View Related
Jun 19, 2007
Is me again,and now i facing problem to retrieve a single record from the database.
here is my code:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim user As String user = TextBox1.Text Dim varpassword Dim mydata As SqlDataSource
mydata.SelectCommand = "Select * from tbluser where uLogin = '" & user & "'" varpassword = mydata.SelectCommand.uPassword
End SubEnd Class
but i get the error : 'uPassword' is not a member of 'String'
i wan to retrieve the password of that user,can anyone help me?
thanks
View 3 Replies
View Related
Jan 7, 2008
Creating custom Register form That inserts user info in to database via storeprocgetting following errorCompilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: BC30456: 'ValidateInput' is not a member of 'System.Web.UI.WebControls.TextBox'.
Source Error:
Line 3496: Me.__BuildControlTree(Me)
Line 3497: Me.AddWrappedFileDependencies(Global.ASP.partfrm_aspx.__fileDependencies)
Line 3498: Me.Request.ValidateInput
Line 3499: End Sub
Line 3500:
>.ASPX <asp:Wizard ID="AddParticipantWizard" OnFinishButtonClick="AddParticipant_FinishButtonClick" FinishDestinationPageUrl="~/partReg.aspx" runat="server">
<WizardSteps>
<asp:WizardStep ID="WizardStep1" runat="server" Title="Register Participant">
<h3> Register: </h3>
<hr />
<table border="0">
<tr>
<td align="Left" colspan="2">
<h3>
PARTICIPANT INFORMATION: </h3><hr />
Please enter information for the attendee and click 'continue'.</td>
</tr></table>
<table border="0">
<tr>
<td align="right"> Registrant Information
</td>
<td style="width: 232px">
<asp:CheckBox ID="CheckBox1" runat="server" /> Register Me</td>
</tr>
<tr>
<td align="Left" colspan="2">
<table border="0">
<tr>
<td align="right">
<asp:Label ID="FirstNameLabel" runat="server" AssociatedControlID="firstname">First Name:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="firstname" runat="server" Width="195px"></asp:TextBox>
<asp:RequiredFieldValidator ID="FirstNameRequired" runat="server" ControlToValidate="firstname"
ErrorMessage="First Name is required." ToolTip="First Name is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="LastNameLabel" runat="server" AssociatedControlID="lastname">Last Name:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="lastname" runat="server" Width="195px"></asp:TextBox>
<asp:RequiredFieldValidator ID="LastNameRequired" runat="server" ControlToValidate="lastname"
ErrorMessage="Last Name is required." ToolTip="Last Name is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="EmailLabel" runat="server" AssociatedControlID="Email">E-mail:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="Email" runat="server" Width="195px"></asp:TextBox>
<asp:RequiredFieldValidator ID="EmailRequired" runat="server" ControlToValidate="Email"
ErrorMessage="E-mail is required." ToolTip="E-mail is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr><td style="width: 232px"><br /></td></tr>
<tr>
<td align="right" style="height: 32px">
<asp:Label ID="StreetLabel" runat="server" AssociatedControlID="Street">Street:</asp:Label>
</td>
<td style="width: 232px; height: 32px">
<asp:TextBox ID="Street" runat="server" Width="195px"></asp:TextBox>
<asp:RequiredFieldValidator ID="StreetRequired" runat="server" ControlToValidate="Street"
ErrorMessage="Street is required." ToolTip="Street is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr><td></td>
<td> <br />
<br /> ".
</td></tr>
<tr>
<td align="right">
<asp:Label ID="CityLabel" runat="server" AssociatedControlID="City">City:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="City" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="CityRequired" runat="server" ControlToValidate="City"
ErrorMessage="City is required." ToolTip="City is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="StateLabel" runat="server" AssociatedControlID="State">State:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="State" runat="server" Width="18px">
</asp:TextBox><asp:RequiredFieldValidator ID="StateRequired" runat="server" ControlToValidate="State"
ErrorMessage="State is required." ToolTip="State is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr><td></td>
<td> <br /> <br /> </td></tr>
<tr><td style="width: 232px"><br /></td></tr>
<tr>
<td align="right">
<asp:Label ID="PostalCodeLabel" runat="server" AssociatedControlID="Zip">Postal/Zip<br />
Code:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="PostalCode" runat="server" Width="28px"></asp:TextBox>
<asp:RequiredFieldValidator ID="PostalCodeRequired" runat="server" ControlToValidate="PostalCode"
ErrorMessage="PostalCode is required." ToolTip="PostalCode is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="OrganizationLabel" runat="server" AssociatedControlID="Organization">Organization:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="Organization" runat="server" Width="195px"></asp:TextBox>
<asp:RequiredFieldValidator ID="OrganizationRequired" runat="server" ControlToValidate="Organization"
ErrorMessage="Organization is required." ToolTip="Organization is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="TitleLabel" runat="server" AssociatedControlID="Title">Title:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="Title" runat="server" Width="195px"></asp:TextBox>
<asp:RequiredFieldValidator ID="TitleRequired" runat="server" ControlToValidate="Title"
ErrorMessage="Title is required." ToolTip="Title is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="DepartmentLabel" runat="server" AssociatedControlID="Department">Department:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="Department" runat="server" Width="195px"></asp:TextBox>
<asp:RequiredFieldValidator ID="DepartmentRequired" runat="server" ControlToValidate="Department"
ErrorMessage="Department is required." ToolTip="Department is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="PhoneNumberLabel" runat="server" AssociatedControlID="Phone">Phone Number:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="Phone" runat="server" Width="195px"></asp:TextBox>
<asp:RequiredFieldValidator ID="PhoneRequired" runat="server" ControlToValidate="Phone"
ErrorMessage="Phone Number is required." ToolTip="Phone Number is required."
ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="RequestLabel" runat="server" AssociatedControlID="Request">Any special request:</asp:Label>
</td>
<td style="width: 232px">(e.g, )
</td>
</tr>
<tr>
<td align="right">
</td>
<td style="width: 232px">
<asp:TextBox ID="Request" runat="server" Width="235px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequestRequiredFieldValidator1" runat="server" ControlToValidate="Request"
ErrorMessage="Request is required." ToolTip="Request is required."
ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="center" colspan="2">
<asp:RegularExpressionValidator ID="EmailRegExp" runat="server" ControlToValidate="Email"
Display="Dynamic" ErrorMessage="The email format is invalid." ValidationExpression="S+@S+.S+"
ValidationGroup="AddParticipantWizard"></asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td align="center" colspan="2" style="color: red">
<asp:Literal ID="ErrorMessage" runat="server" EnableViewState="False"></asp:Literal>
</td>
</tr>
<tr><td></td>
<td align="right">
</td></tr>
</table>
</td>
</tr>
</table>
<asp:SqlDataSource ID="InsertPartDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:MyConnectionString %>" InsertCommand="PartInsert" InsertCommandType="StoredProcedure">
<InsertParameters>
<asp:ControlParameter ControlID="firstName" Name="firstName" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="lastName" Name="lastName" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="Email" Name="Email" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="Street" Name="Street" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="City" Name="City" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="State" Name="State" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="PostalCode" Name="PostalCode" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="Organization" Name="Organization" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="Title" Name="Title" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="Department" Name="Department" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="Phone" Name="Phone" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="Request" Name="Request" PropertyName="SelectedValue"
Type="String" />
<asp:ControlParameter ControlID="Assistance" Name="Assistance" PropertyName="SelectedValue"
Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</asp:WizardStep>
<asp:WizardStep ID="WizardStep2" runat="server" Title="Completion">
<p>
Your account has been successfully created.
</p>
<asp:Button ID="ContinueButton" runat="server" CommandName="Continue"
Text="Continue" />
</asp:WizardStep>
</WizardSteps>
</asp:Wizard> > CODE-BEHIND 'This event handler fires when the user clicks Finish. We need to insert the new participant record into the database
Protected Sub AddParticipant_FinishButtonClick(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.WizardNavigationEventArgs) Handles AddParticipantWizard.FinishButtonClick
'Insert the Participant into the database
InsertPartDataSource.Insert()
'Send the user back to the homepage
Response.Redirect("~/PartReg.aspx")
End Sub
View 1 Replies
View Related
Jul 23, 2007
What is the C# code I use to do this?
I'm guessing it should be fairly simple, as there is only one row selected. I just need to pull out a specific field from that row and then insert that value into a different SqlDataSource.
View 7 Replies
View Related
Oct 25, 2006
Hi, it is few days I posted here my question, but received no answer. Maybe the problem is just my problem, maybe I put my question some strange way. OK, I try to put it again, more simply. I have few textboxes, their values I need to transport to database. I set SqlDataSource, parameters... and used SqlDataSource.Insert() method. I got NULL values in the database's record. So I tried find problem by using Microsoft's sample code from address http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.insert.aspx. After some changes I tried that code and everything went well, data were put into database. Next step was to separate code beside and structure of page to two separate files followed by new test. Good again, data were delivered to database. Next step: to use MasterPage, very simple, just with one ContentPlaceHolder. After this step the program stoped to deliver data to database and delivers only NULLs to new record. It is exactly the same problem which I have found in my application. The functionless code is here:http://forums.asp.net/thread/1437716.aspx I cannot find any answer this problem on forums worldwide. I cannot believe it is only my problem. I compared html code of two generated pages - with maserPage and without. There are differentions in code in ids' of input fields generated by NET.Framework:Without masterpage:<input name="NazevBox" type="text" id="NazevBox" /><span id="RequiredFieldValidator1" style='color:Red;visibility:hidden;'>Please enter a company name.</span><p><input name="CodeBox" type="text" id="CodeBox" /><span id="RequiredFieldValidator2" style='color:Red;visibility:hidden;'>Please enter a phone number.</span><p><input type="submit" name="Button1" value="Insert New Shipper" onclick="javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions("Button1", "", true, "", "", false, false))" id="Button1" /> With masterpage:<input name="ctl00$Obsah$NazevBox" type="text" id="ctl00_Obsah_NazevBox" /><span id="ctl00_Obsah_RequiredFieldValidator1" style='color:Red;visibility:hidden;'>Please enter a company name.</span><p><input name="ctl00$Obsah$CodeBox" type="text" id="ctl00_Obsah_CodeBox" /><span id="ctl00_Obsah_RequiredFieldValidator2" style='color:Red;visibility:hidden;'>Please enter a phone number.</span><p><input type="submit" name="ctl00$Obsah$Button1" value="Insert New Shipper" onclick="javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions("ctl00$Obsah$Button1", "", true, "", "", false, false))" id="ctl00_Obsah_Button1" />In second case ids' of input fields have different names, but I hope it is inner business of NET.Framework.There must be something I haven't noticed, maybe NET's bug, maybe my own. Thanks for any suggestion.
View 2 Replies
View Related
Apr 18, 2006
I have a form setup, the code of which is listed below, and I would like to be able to submit the data that is entered in the form to a SQL 2005 standard database via the SqlDataSource control and a button. I'm just having trouble doing so because of the coding. Any help or suggestions would be greata s I've already read through the tutorials on this site and they don't go in depth very much. Thanks!
<%@ Page Language="VB" %>
<%@ Register Assembly="BasicFrame.WebControls.BasicDatePicker" Namespace="BasicFrame.WebControls"
TagPrefix="BDP" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<Script runat="server">
Private Sub InsertData(ByVal Source As Object, ByVal e As EventArgs)
SqlDataSource1.Insert()
End Sub
</Script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Weston E-Vault - New Customer Sign-Up Form</title>
</head>
<body>
<form id="form1" runat="server">
<div style="text-align: center">
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=C26819_24561;Initial Catalog=ebackups;Integrated Security=True;User Instance=False" ProviderName="System.Data.SqlClient" InsertCommand="INSERT INTO backup_info(cust_name, cust_phone, cust_contact, cust_analyst, storage_plan, install_date, backup_data, backupexec_option, backup_program, cust_email) VALUES (@cust_name, @cust_phone, @cust_contact, @cust_analyst, @storage_plan, @install_date, @backup_data, @backupexec_option, @backup_program, @cust_email)">
<InsertParameters>
<asp:ControlParameter ControlID="DropDownList1" DefaultValue="" Name="@cust_name"
PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="TextBox1" Name="@cust_contact" PropertyName="Text" />
<asp:ControlParameter ControlID="TextBox2" Name="@cust_phone" PropertyName="Text" />
<asp:ControlParameter ControlID="DropDownList3" Name="@cust_analyst" PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="BDPLite1" Name="@install_date" PropertyName="Controls" />
<asp:ControlParameter ControlID="TextBox3" Name="@cust_username" PropertyName="Text" />
<asp:ControlParameter ControlID="TextBox4" Name="@cust_password" PropertyName="Text" />
<asp:ControlParameter ControlID="DropDownList2" Name="@storage_plan" PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="TextBox5" Name="@backup_data" PropertyName="Text" />
<asp:ControlParameter ControlID="RadioButtonList1" Name="@backupexec_option" PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="TextBox6" Name="@backup_program" PropertyName="Text" />
<asp:ControlParameter ControlID="TextBox7" Name="@cust_email" PropertyName="Text" />
</InsertParameters>
</asp:SqlDataSource>
<br />
<br />
<br />
<table>
<tr>
<td style="width: 100px">
<img src="/images/westonevault_logo.jpg" /></td>
<td style="width: 703px; text-align: right">
<asp:Button ID="Button1" runat="server" BackColor="White" BorderColor="Navy" BorderStyle="Solid"
BorderWidth="1px" Font-Names="verdana" Font-Size="Small" ForeColor="Navy" PostBackUrl="~/secure/tech_home.aspx"
Text="Back" /><span style="font-size: 8pt; color: #000099"> </span></td>
</tr>
</table>
<br />
<br />
<img src="/images/div.jpg" style="font-size: 8pt; color: #000099" /><br />
<br />
<div style="text-align: center">
<table style="font-size: 8pt; width: 730px; color: #000099; font-family: Verdana">
<tr>
<td colspan="3" style="font-weight: bold; font-family: Verdana; text-align: left">
<span style="color: #000099">Customer Information<br />
</span>
<hr style="color: #000099" />
<span style="font-weight: normal; font-size: 8pt; color: #000099">Please enter all customer
data as accurately as possible. Any incorrect information on this form may result
in incorrect data being backed up, reports not reaching the customer or they may<span
style="font-size: 12pt"><strong> </strong><span style="font-size: 8pt">not receive the need</span></span>ed amount of disk
space.<br />
<br />
</span>
</td>
</tr>
<tr style="font-size: 8pt">
<td style="width: 174px; text-align: left">
<span style="font-family: Verdana"><span style="color: navy">Customer
Name:<br />
</span>
<asp:DropDownList ID="DropDownList1" runat="server" DataValueField="cust_name" Font-Names="Verdana"
Font-Size="X-Small" ForeColor="Navy" Width="178px">
<asp:ListItem Selected="True">Select Customer Name.....</asp:ListItem>
<asp:ListItem>Alaska Road Boring</asp:ListItem>
<asp:ListItem>Allen and Peterson</asp:ListItem>
<asp:ListItem>AK Guns</asp:ListItem>
<asp:ListItem>ATS Alaska</asp:ListItem>
<asp:ListItem>BC Contractors</asp:ListItem>
<asp:ListItem>Bek of Alaska</asp:ListItem>
<asp:ListItem>Brokentop Community Assoc.</asp:ListItem>
<asp:ListItem>COHRA</asp:ListItem>
<asp:ListItem>Crisis Pregnancy Center</asp:ListItem>
<asp:ListItem>Gaines and Co.</asp:ListItem>
<asp:ListItem Value="Gil Damond">Gil Damond</asp:ListItem>
<asp:ListItem>GMW Fire</asp:ListItem>
<asp:ListItem>Integrity Funding</asp:ListItem>
<asp:ListItem>La Pine Community Clinic</asp:ListItem>
<asp:ListItem>La Pine Fire District</asp:ListItem>
<asp:ListItem>Lumbermens Ins.</asp:ListItem>
<asp:ListItem>Murray</asp:ListItem>
<asp:ListItem>NEI</asp:ListItem>
<asp:ListItem>Northstar Center</asp:ListItem>
<asp:ListItem>Redi Electric</asp:ListItem>
<asp:ListItem>Robberson Ford</asp:ListItem>
<asp:ListItem>South Anchorage District Office</asp:ListItem>
<asp:ListItem>St. George Tanaq</asp:ListItem>
<asp:ListItem>Stinebaugh</asp:ListItem>
<asp:ListItem>THT Electric</asp:ListItem>
<asp:ListItem>Watterson</asp:ListItem>
<asp:ListItem>United Auto</asp:ListItem>
<asp:ListItem>Weston - ANC</asp:ListItem>
<asp:ListItem>Weston - BND</asp:ListItem>
<asp:ListItem></asp:ListItem>
</asp:DropDownList><br />
</span>
</td>
<td style="width: 187px; text-align: left">
<span style="font-family: Verdana"><span style="color: #000099">Customer
Contact:<br />
</span>
<asp:TextBox ID="TextBox1" runat="server" Font-Names="Verdana" Font-Size="X-Small"
Width="164px"></asp:TextBox><br />
</span>
</td>
<td style="width: 136px; text-align: left">
<span style="font-family: Verdana"><span style="color: #000099">Customer
Phone:<br />
</span>
<asp:TextBox ID="TextBox2" runat="server" Font-Names="verdana" Font-Size="X-Small"></asp:TextBox><br />
</span>
</td>
</tr>
<tr style="font-size: 8pt">
<td style="width: 174px; text-align: left">
<span style="font-family: Verdana"><span style="color: #000099">Customer
E-Vault Username:<br />
</span>
<asp:TextBox ID="TextBox3" runat="server" Font-Names="Verdana" Font-Size="X-Small"
Width="150px"></asp:TextBox><br />
</span>
</td>
<td style="width: 187px; text-align: left">
<span style="font-family: Verdana"><span style="color: #000099">Customer
E-Vault Password:<br />
</span>
<asp:TextBox ID="TextBox4" runat="server" Font-Names="Verdana" Font-Size="X-Small"
TextMode="Password" Width="150px"></asp:TextBox><br />
</span>
</td>
<td style="width: 136px; text-align: left">
<span style="font-family: Verdana"><span style="color: #000099">E-Vault
Storage Plan:<br />
</span>
<asp:DropDownList ID="DropDownList2" runat="server" DataValueField="storage_plan"
Font-Names="Verdana" Font-Size="X-Small" ForeColor="Navy">
<asp:ListItem Selected="True">Select Plan.....</asp:ListItem>
<asp:ListItem>0-300MB</asp:ListItem>
<asp:ListItem>300MB-2GB</asp:ListItem>
<asp:ListItem>2GB-4GB</asp:ListItem>
<asp:ListItem>4GB-6GB</asp:ListItem>
<asp:ListItem>6GB-8GB</asp:ListItem>
<asp:ListItem>8GB-15GB</asp:ListItem>
<asp:ListItem>15GB-25GB</asp:ListItem>
<asp:ListItem>25GB-35GB</asp:ListItem>
<asp:ListItem>35GB-50GB</asp:ListItem>
<asp:ListItem>50GB-100GB</asp:ListItem>
<asp:ListItem>100GB-200GB</asp:ListItem>
</asp:DropDownList><br />
</span>
</td>
</tr>
<tr style="font-size: 8pt">
<td style="width: 174px; text-align: left">
<span style="font-family: Verdana"><span style="color: #000099">Analyst:<br />
</span>
<asp:DropDownList ID="DropDownList3" runat="server" DataValueField="cust_analyst"
Font-Names="Verdana" Font-Size="X-Small" ForeColor="Navy" Width="162px">
<asp:ListItem>Select Analyst.....</asp:ListItem>
<asp:ListItem>Brock McFarlane</asp:ListItem>
<asp:ListItem>Cameron Farrally</asp:ListItem>
<asp:ListItem>Chad Huls</asp:ListItem>
<asp:ListItem>Eric Spinney</asp:ListItem>
<asp:ListItem>Greg Freeman</asp:ListItem>
<asp:ListItem>Harald Smit</asp:ListItem>
<asp:ListItem>Kevin Mark</asp:ListItem>
<asp:ListItem>Mark Anderson</asp:ListItem>
<asp:ListItem>Mike Murphy</asp:ListItem>
<asp:ListItem>Tim Elder</asp:ListItem>
</asp:DropDownList><br />
</span>
</td>
<td style="width: 187px; text-align: left">
<span style="font-family: Verdana"><span style="color: #000099">Today's
Date: (mm/dd/yyy)<br />
</span>
<bdp:bdplite id="BDPLite1" runat="server" borderstyle="None" cssclass="bdpLite" dateformat="ShortDate"
font-bold="False" font-names="verdana" font-size="X-Small" forecolor="Navy" selecteddate=""></bdp:bdplite>
</span>
</td>
<td style="width: 136px; text-align: left">
<br />
</td>
</tr>
<tr style="font-size: 8pt">
<td colspan="3">
</td>
</tr>
<tr style="font-size: 8pt">
<td colspan="3" style="text-align: left">
<span style="font-family: Verdana"><span style="color: #000099"><strong>
<br />
Backup Data<br />
<hr style="color: #000099" />
</strong><span>Please enter all directories and/or files and
folders the customer wishes to have backed up. Be thourough yet brief as this is
for historical and record keeping purposes.<br />
<br />
</span></span></span>
</td>
</tr>
<tr style="font-size: 8pt">
<td colspan="3" style="text-align: left">
<asp:TextBox ID="TextBox5" runat="server" ForeColor="#000000" Height="130px" MaxLength="200"
TextMode="MultiLine" Width="503px"></asp:TextBox><br />
</td>
</tr>
<tr style="font-size: 8pt">
<td style="width: 174px">
</td>
<td style="width: 187px">
</td>
<td style="width: 136px">
</td>
</tr>
<tr style="font-size: 8pt">
<td colspan="3" style="text-align: left">
<span style="font-family: Verdana"><span style="color: #000099"><strong>
<br />
BackupExec / NTBackup<br />
<hr style="color: #000099" />
</strong><span>Does the customer have another backup program
running that backs up their files to tape or another physical media.<br />
<br />
</span></span></span>
</td>
</tr>
<tr style="font-size: 8pt">
<td colspan="2" style="height: 41px; text-align: left">
<asp:RadioButtonList ID="RadioButtonList1" runat="server" Font-Names="Verdana" Font-Size="X-Small"
ForeColor="Navy" RepeatDirection="Horizontal" Width="127px">
<asp:ListItem Value="Yes">Yes</asp:ListItem>
<asp:ListItem Value="No">No</asp:ListItem>
</asp:RadioButtonList><span style="font-family: Verdana"><span style="color: #000099">If
"Yes", what program do they use?</span>
<asp:TextBox ID="TextBox6" runat="server" Font-Names="Verdana" Font-Size="X-Small"
Width="200px"></asp:TextBox><br />
</span>
</td>
<td style="width: 136px; height: 41px">
</td>
</tr>
<tr style="font-size: 8pt">
<td style="width: 174px">
</td>
<td style="width: 187px">
</td>
<td style="width: 136px">
</td>
</tr>
<tr style="font-size: 8pt">
<td colspan="3" style="text-align: left">
<span style="color: #000099"><span style="font-family: Verdana"><strong>
<br />
E-Mail Notifications<br />
<hr style="color: #000099" />
</strong><span>Does the customer wish to receive weekly reports
about their backups? (This includes what directories are being backed up, how much
storage space they have used on their plan and how much storage space is remaining).If
so enter their e-mail address below. If they don't want to receive notifications,
you can skip this section.<br />
<br />
</span></span></span>
</td>
</tr>
<tr style="font-size: 8pt">
<td style="width: 174px; text-align: left">
<asp:TextBox ID="TextBox7" runat="server" Font-Names="Verdana" Font-Size="XX-Small"
ForeColor="Navy" Width="201px"> N/A</asp:TextBox></td>
<td style="width: 187px">
</td>
<td style="width: 136px">
</td>
</tr>
<tr style="font-size: 8pt">
<td style="width: 174px">
</td>
<td style="width: 187px">
</td>
<td style="width: 136px">
</td>
</tr>
<tr style="font-size: 8pt">
<td style="width: 174px; height: 26px">
</td>
<td style="width: 187px; height: 26px; text-align: left">
<asp:Button ID="Button2" runat="server" BackColor="White" BorderColor="Navy" BorderStyle="Solid"
BorderWidth="1px" Font-Names="verdana" Font-Size="Small" OnClick="InsertData" Text="Submit Form" /></td>
<td style="width: 136px; height: 26px">
</td>
</tr>
</table>
</div>
<div style="text-align: center">
<img src="/images/div.jpg" /><br />
<br />
<span style="font-size: 7pt; font-family: Verdana">Copyright 2006 Weston Technology
Solutions </span>
</div>
</div>
</form>
</body>
</html>
View 3 Replies
View Related
Mar 8, 2007
i am using visual web developer 2005 with SQL Express 2005 with VB as the code behindi have one database and three tables in itfor manipulating each table i am using separate SqlDataSource() is it sufficient to use one SqlDataSource() for manipulating all the three tables ? i am manipulating all the tables in the same page only please help me
View 1 Replies
View Related
Aug 20, 2006
I have an asp:sqldatasource which is bound to a gridviewIn addition to this I would like it to a) see if there is a specif row/ item in it (ie item_id = 10 for any of the rows it has received) as I conditionally want to show another item outside of the gridview subject to if it is in the gridview or notb) show the sum of all the values within a certain column of returned rowsMany thanks
View 1 Replies
View Related
Oct 11, 2006
How do I get the result of this select into a variableDim sqldsFindUserId As SqlDataSource = New SqlDataSource sqldsFindUserId.ConnectionString = ConfigurationManager.ConnectionStrings("bluConnectionString2").ToString sqldsFindUserId.SelectCommandType = SqlDataSourceCommandType.Text Dim myUserIdCmd As String = "select pkUser from tblUsers where strDisplayName='" + myDisplayname + "" sqldsFindUserId.SelectCommand = myUserIdCmd ' The result of this select statement is to be stored in a variable, how do I do it?
View 2 Replies
View Related
Jan 15, 2007
hi all,
in all my 2.0 learnings and books i keep coming across the page element <asp:sqldatasource>.
I have always (in 1.1) used server side connections and adapters to bind my Sql datasets to any control needed. Now that im learning 2.0 im finding it difficult to understand using control on the page to bind my data. Can someone explain the benefits of using this data source? Ideally i would like to keep my data access layer separate from my presentation layer but i'd really like to understand why this method seems so popular.
thanks in advance,
mcm
View 2 Replies
View Related
Feb 23, 2007
Hi, I am new to ASP.NET 2.0 and I am trying to use VWB to bind my web site to a SQL Express edition. I used SQLDataSource to specify the .mdf file so I can connect to my tables but when I click on the advanced button to generate the Insert, Update, Delete SQL I find it grayed out and it cannot be clicked. I looked into several tutorials online and I couldn't find the problem, can anyone explain what I am missing or doing wrong? Any suggestion is very appreciated. Thanks
View 2 Replies
View Related
Mar 30, 2007
SELECT * FROM [CONTACTS] WHERE @ddl_value LIKE '%@txt_value%'
Why doesn't this not working
I am using SQLdatasource control to bind a gridview
If my query is wrong then what might be the correct one to work with like operator in the sqldatasource
Can any ony help me!
View 4 Replies
View Related
Apr 12, 2007
Hello All,
I have quick question ..
In my aspx page i have gridview and Sql DataSource object as you can see
<asp:sqldatasource id="SqlDataSource1" runat="server" ></asp:sqldatasource>
<asp:gridview id="GridView1" runat="server" allowpaging="True" allowsorting="True" autogeneratecolumns="False" datasourceid="SqlDataSource1">
<columns>
<asp:boundfield datafield="breakdownid" headertext="breakdownid" insertvisible="False"
readonly="True" sortexpression="breakdownid" />
<asp:boundfield datafield="ticketno" headertext="ticketno" sortexpression="ticketno" />
<asp:boundfield datafield="systemtype" headertext="systemtype" sortexpression="systemtype" />
<asp:boundfield datafield="break_date" headertext="break_date" readonly="True" sortexpression="break_date" />
<asp:boundfield datafield="subject" headertext="subject" sortexpression="subject" />
<asp:boundfield datafield="status" headertext="status" sortexpression="status" />
<asp:boundfield datafield="prioritylevel" headertext="prioritylevel" sortexpression="prioritylevel" />
<asp:boundfield datafield="mobiletype" headertext="mobiletype" sortexpression="mobiletype" />
</columns>
</asp:gridview>
In codebehind file i call a function to get data from database. what i want is to bind the result to the sqlDataSourse not the gridview.
I need to have the SqlDataSourse thier.. Any help please
Sub Page_load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
Dim objReader As New Dynamic.Reportsdemo
SqlDataSource1 = .objReader.Get_Tickets(1, 0, "all")
SqlDataSource1.DataBind()
objReader.objconnection.Close()
End If
End Sub
Thanks.
View 1 Replies
View Related
May 28, 2007
Hi!Please tell me, how to get a simple value using SQLDataSource, I mean a number, or char, or string - any value, NOT DataTable
View 3 Replies
View Related
Jul 23, 2007
I am trying to get record from a table and verify it with a textbox i have a sqldatasource.
i have a text box called txtEmail and this is my Select command. how can i get this working if its possible ?
something like txtEmail.text = SqlDataSource1.Secect then ... my code. (i dont know if this a correct way to do this)
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:imacstestConnectionString %>"
SelectCommand="SELECT FROM [t_CustomerAcct]"
thanks,
View 1 Replies
View Related
Aug 13, 2007
hi all,i am using sqldatasource for gridviewso that i can edit and update any row at the same place ..... and not to write any code for that....now later on if i wanna change the selectcommand of that sqldatasource how can i ? so that the edit and update will be same as it was....
View 2 Replies
View Related
Aug 21, 2007
Hi,
I'm trying to go through a checkbox list and inserting them into a database using a sqldatasource with the following code:For Each li As ListItem In Locations_Checkbox.Items
If li.Selected = True Then
Dim DataSource2 As SqlDataSource = CType(InsertProgrammeLocations, SqlDataSource) DataSource2.InsertParameters.Add("ProgrammeID", li.Value)
DataSource2.Insert()
End If
Next
When more than one checkbox is ticked, I'm getting the error 'The variable name '@ProgrammeID' has already been declared'. How do I close or reset my Datasource before I try and use it again?
Thanks for your help
View 3 Replies
View Related
Oct 28, 2007
please explain selectparameter collection and conflict detection property and filterparameter
mohsen
View 1 Replies
View Related
Oct 29, 2007
Hi, I want to know when to use an sqlDataSource object because I used to populate for example a listBox control in visual studio net 2003 from AQLK server database by using a connection object, command object, dataAdapter object and a DataSet object. I discovered if I use sqlDataSource object (using visual studio net 2005) ,all I need is to write the connection string and a Select statement as properties for that sqlDataSource, so why to use the above mentioned objects(connection,command,adapter,dataset) while I can access any database in sql server through the use of sqlDataSource?
I appreciate if you can explain to me the difference and when to use an sqlDataSource
thx
View 1 Replies
View Related
Dec 4, 2007
How can I update more than one table with one UpdateString in SqlDataSource?
View 5 Replies
View Related
Dec 9, 2007
Hi,
I have an application w/ n-tier design so I've never used the SqlDataSource up to this point but having to do my own sorting for GridViews is not something I want to keep dealing with. I'd like to take advantage of some of the packaged features too.
My question is: are there any purists out there who opted to use SqlDataSource. If so, what do you think about it? It's nice that SqlDataSource makes things simple but having data classes and dealing w/ exceptions in those classes certainly make an application pretty robust. Should I entertain the idea of using SqlDataSource or stay as a purist and keep doing things the old fashioned way?
View 1 Replies
View Related
Dec 30, 2007
How to display returned data from sqldatasurce in a textbox.
This code is not working TextBox1.Text = SqlDataSource2.ToString(); Thanks Lot.
View 2 Replies
View Related
Jan 16, 2008
Hey all,I've just started to use asp.net and so far have found it fairly easy. The only problem I've come across is with putting variable clauses into the SqlDataSources.This is one example of what I've done trying to get this to work. <asp:SqlDataSource ID="ClaimsDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
SelectCommand="SELECT TOP 20 dbo_ClaimStatus.ClaimStatus, dbo_CLAIMS.PACKET, dbo_INSURED.NAME, dbo_FEES.INSURER, dbo_FEES.CLAIM_NUMBER, dbo_CLAIMS.LOSS_DATE, dbo_CLAIMS.RECEIVED, dbo_CLAIMS.LOSS_LOCATION, dbo_CLAIM_TYPES.CODE FROM ( ( ( ( dbo_CLAIMS INNER JOIN dbo_CLAIM_TYPES ON dbo_CLAIMS.CLAIM_TYPE = dbo_CLAIM_TYPES.CODE ) INNER JOIN dbo_ClaimStatus ON dbo_CLAIMS.StatusID = dbo_ClaimStatus.ClaimStatusID ) INNER JOIN dbo_FEES ON dbo_CLAIMS.PACKET = dbo_FEES.PACKET ) INNER JOIN dbo_INSURED ON dbo_CLAIMS.PACKET = dbo_INSURED.PACKET ) WHERE dbo_ClaimStatus.ClaimStatus = @claimStatus"> <FilterParameters> <asp:QueryStringParameter Name="claimStatus" QueryStringField="ctl00$MainContent$claimStatus" /> </FilterParameters></asp:SqlDataSource>I'm posting claimStatus from a previous page using PostBackUrl on an <asp:Button /> tag and claimStatus is an <asp:DropDownList /> tag.Any idea's as to why this doesn't work?Nalum
View 2 Replies
View Related
Feb 24, 2008
Dear Friends in my project , i' ve used two SqlDataSource, one button and one gridview control;
the process that i want to do is when i click the button control ,according the if structure in this button control ; one of the SqlDataSource control assign to the gridview control DataSource property (but i assign the DataSourceID property for the gridview , it runs);
but i couldnt do it, what can i do for it? (my code doesnt give any errors but doesnt do anything too)
my code is here;
protected void btnSearch_Click(object sender, EventArgs e) { if (txtSearch.Text != null){ SqlDataSource3.SelectParameter["key"].DefaultValue = txtsearch.Text; Gridview1.DataSource = SqlDataSource3; GridView1.DataBind(); } else { SqlDataSource1.SelectParameters["keySession"].DefaultValue = cbSession.SelectedItem.ToString(); SqlDataSource1.SelectParameters["keyClass"].DefaultValue = cbClass.SelectedItem.ToString(); SqlDataSource1.SelectParameters["keyUnit"].DefaultValue = cbUnit.SelectedItem.ToString(); Gridview2.DataSource = SqlDataSource1; GridView2.DataBind(); }
View 1 Replies
View Related
Feb 24, 2008
Dear Friends in my project , i' ve used two SqlDataSource, one button and one gridview control;
the process that i want to do is when i click the button control ,according the if structure in this button control ; one of the SqlDataSource control assign to the gridview control DataSource property (but i assign the DataSourceID property for the gridview , it runs);
but i couldnt do it, what can i do for it? (my code doesnt give any errors but doesnt do anything too)
my code is here;
protected void btnSearch_Click(object sender, EventArgs e) { if (txtSearch.Text != null){ SqlDataSource3.SelectParameter["key"].DefaultValue = txtsearch.Text; Gridview1.DataSource = SqlDataSource3; GridView1.DataBind(); } else { SqlDataSource1.SelectParameters["keySession"].DefaultValue = cbSession.SelectedItem.ToString(); SqlDataSource1.SelectParameters["keyClass"].DefaultValue = cbClass.SelectedItem.ToString(); SqlDataSource1.SelectParameters["keyUnit"].DefaultValue = cbUnit.SelectedItem.ToString(); Gridview1.DataSource = SqlDataSource1; GridView1.DataBind(); } }
View 1 Replies
View Related
