Database Insert Question - Best Practices For Empty Data
Apr 17, 2007
I am making a form that takes input for 1 to 5 students using VWD. With the help of previous posts I have been able to make the database insert query work properly. In my form I have a radio list that has the user select if they are entering information for 1, 2, 3,4, or 5 children. Depending on how many children are selected on the radio list, I am displaying the proper number of textboxes and validating the data using the handy RequiredFieldValidator.
Now I am at the point where I want to perform the instert to the database depending on the selected number of children in the family. What is the general rule for best practices. Please keep in mind that it is my understanding that ALL fileds in a SQL insert statment must have data. Should I ...
1) create alternative SQL statements depending on the textboxes displayed OR
2) is it more common to insert a standard string or integer, depending on the datatype, into the unused textboxes to populate the unused fields?
Sincerely,
Mike
View 2 Replies
ADVERTISEMENT
Jul 11, 2007
Hi,
I'm new to VS2005 (vb.net) and here my situation
I have form with a dataset1 (tbl1, tbl2, tbl3, tbl4) pulling data from a Access db. and showing it on the form1(databound)
I need to write what is on form1 to the empty dataset2 in SQL 2005 db
I have created a new DB in SQL 2005 with a Table SQL1 which has the same fields as on form1. Please can some one show me how do I do this. Please
Thanks in advance for your response.
-NM
View 3 Replies
View Related
Dec 31, 2007
I was wondering if you guys know of a good site that talks about programmatically accessing and displaying data from a sql server 05 database in ASP.NET 2.0.I want to have a data adapter in a dataset, but I would like to create my own class file and pull the data from the adapter through code into the class. Is this the best way? Im wondering about the best practices while learning this new technology. Any articles provided would be appreciated. Thanks!
View 2 Replies
View Related
Mar 21, 2008
Hi i wanna delete all the records from an large database 200 -300 tables, because i want make some changes an start from scratch,but keep the structures of the database key , index etc, i tried to generate script but when i run to many errors , plz help 10x
View 11 Replies
View Related
Jul 24, 2007
for now, doing a small school project, i find doing SPs for Insert useful, like checking for existing data and not inserting, that might not be the best method, i had advice from here i can use unique constraints instead, then what about update and delete? SPs also? the pros make SPs for everything? currently use dynamically generated SQL from SqlDataSources. for Update / delete. some delete are SPs too...
View 2 Replies
View Related
Sep 18, 2007
Hi-I have a sql server database, and am wring web apps to access it.I've created databases different ways, and ended up with different owners (eg dbo, nt authorityetwork services...)I also have connection strings using windows authentication, and some using a user name and password.I have read that using windows authentication is the best way to go, as far as security goes, but I have noticed some connectivity issues when I upload the site to the server, and test it remotely. What is the safest 'owner' of the database, and what's the safest way to connect?Thanks Dan
View 8 Replies
View Related
May 15, 2008
I have two SSIS packages that import from the same flat file into the same SQL 2005 table. I have one flat file connection (to a comma delimited file) and one OLE DB connection (to a SQL 2005 Database). Both packages use these same two Connection Managers. The SQL table allows NULL values for all fields. The flat file has "empty values" (i.e., ,"", ) for certain columns.
The first package uses the Data Flow Task with the "Keep nulls" property of the OLE DB Destination Editor unchecked. The columns in the source and destination are identically named thus the mapping is automatically assigned and is mapped based on ordinal position (which is equivalent to the mapping using Bulk Insert). When this task is executed no null values are inserted into the SQL table for the "empty values" from the flat file. Empty string values are inserted instead of NULL.
The second package uses the Bulk Insert Task with the "KeepNulls" property for the task (shown in the Properties pane when the task in selected in the Control Flow window) set to "False". When the task is executed NULL values are inserted into the SQL table for the "empty values" from the flat file.
So using the Data Flow Task " " (i.e., blank) is inserted. Using the Bulk Insert Task NULL is inserted (i.e., nothing is inserted, the field is skipped, the value for the record is omitted).
I want to have the exact same behavior on my data in the Bulk Insert Task as I do with the Data Flow Task.
Using the Bulk Insert Task, what must I do to have the Empty String values inserted into the SQL table where there is an "empty value" in the flat file? Why & how does this occur automatically in the Data Flow Task?
From a SQL Profile Trace comparison of the two methods I do not see where the syntax of the insert command nor the statements for the preceeding captured steps has dictated this change in the behavior of the inserted "" value for the recordset. Please help me understand what is going on here and how to accomplish this using the Bulk Insert Task.
View 2 Replies
View Related
Apr 21, 2008
I'm trying to find out if this is possible.. i know that you can do an execute script command and have it export the results to a script file or clipboard.. then in a new database, run that in the query window and it will recreate the table schema.. but is there a way to do the entire table, contents and all via a script in a similar fashion?
This would be with SQL 2005 standard edition...
Thanks for any input.
View 1 Replies
View Related
Nov 1, 2007
Hi,
i am newbie in ASP.net world. i am using 3 tier application architechture for my web based application. data base is sql server 2000. i have looked at object and sql datasource objects but i think they are not suitable for my requirements. so i am planning to directly use ado.net to access data from database.( i.e. creating connection, then creating commands n executing them)
now what i am looking for is the best known practices for the above task. i have following solutions in my mind please let me know if i am missing some or which could be the best aproach.
careate one class which will handle all the database requests so that all the pages and business objects request that class to to do all the db related stuff. (creating connection, command n execution)
View 4 Replies
View Related
Oct 30, 2007
Is there a way to INSERT a new empty record without having to designate a field?
I tried the obvious but they issue errors.
--PhB
View 11 Replies
View Related
Jan 30, 2006
I am developing an inventory database in SQL Server. I realize there aremany commercial (as well as some non-commercial) inventory offerings, but myclient has specific requirements that would necessitate significantcustomization of any off-the-shelf application. In the end, we decided itwould be more feasible to build one to our specifications.What I am looking for are a list of best practices/recommendations for thearchitecture and modeling of an inventory database. This inventoryapplication will be for managing a wholesale products operation. It mustmanage purchase orders to the manufacturer of the products, sales invoicesfor the retail customers of the products, as well as manage product stocklevels in the warehouse. We will need a number of reports, including:1. What products are in stock.2. What products are on order from the manufacturer.3. What products are needed to fulfill outstanding sales.4. Warehouse operations (e.g., receipt of delivery, inspection, add toinventory, pull from inventory, packing lists, invoices, return toinventory, etc.)5. Sales analysis (e.g., product velocity, sales by associate, etc.)My main question is regarding the managing of products in stock. As I see itthere are three ways of accomplishing this:1. Track only transactions (products received, products shipped, etc.) andcalculate the stock based on the sum of all transactions. But as transactionvolume accumulates over time, this would get very slow and cumbersome.2. Have a table of "units in stock" and add and subtract to it astransactions occur. This has the advantage of always providing an instantsnapshot of inventory levels. But it makes it more difficult to managechanges or corrections to a transaction once it has been entered.3. A combination of the above two concepts. Choose a point in time (forexample, when the warehouse inventory is audited) and capture that in a(semi) "static" table. After that, transactions are summed as needed againstthose static numbers. The next time the warehouse is audited, the "static"table is updated and all prior transactions are archived. New transactionsare once again summed against the most recent audit numbers. Of course, thiswould mean halting operations at the time of the audit (probably not anissue for my client's business).Recommendations? Suggestions? Comments?(Btw, I've tried to find this info in books and online, but so far have notfound anything that makes specific inventory system design recommendations.If you know of a good reference, please let me know.)Thanks in advance!Michael
View 4 Replies
View Related
Jan 12, 2008
Hi:
Trying to insert null value into sql table, but not working, if I use:
if (strMyText.Length == 0) command.Parameters.Add("@Text", DBNull.Value); // or using:("@Text", null), or using:("@Text", DBNull) else command.Parameters.AddWithValue("@Text", strMyText);
When I go back to table, I see the value is: 'NULL', has single quotation mark, suppose to be: NULL
Where is the problem?
Thanks a lot.
Jt
View 3 Replies
View Related
Mar 3, 2008
When i try to insert new rows using SSIS into an emty table in my database, SSIS freezes. The same happens when i use a lookup on an empty table.
The only solution i have found is to manualy insert a row and remove it afterwards. When i have done this SSIS works without a glitch.
I start off by taking a script of a existing database and applying this script on a new database. So that i create an empty duplicate of my current database.
Any ideas why SSIS freezes? Do i have to initialize something first in my database? It is really annoying that i have to insert a row and delete a row into every table i want to use.
View 9 Replies
View Related
Jun 22, 2007
Are there generalized best practices with regards to which method/provider to use when accessing an Oracle database? I have used both the "Native OLE DBMicrosoft OLE DB Provider for Oracle" and the "Native OLE DBOracle Provider for OLE DB" and both seem to have their own quirks (requirement to convert to Unicode, etc) but I also have heard that I shouldn't be using an "OLE DB" source at all, but to set it up as an ADO .Net connection.
We are just beginning to implement SSIS, and are trying to establish Best Practices/Standards etc.
Are there any gotchas - performance and/or otherwise I should know about?
Thanks in advance!
View 1 Replies
View Related
Jul 20, 2005
Hello all,I just started a new job this week and they complain about the length oftime it takes to load data into their data warehouse,which they do once a month.From what I can gather, they rebuild the indexes before the insert with an80% Fillfactor, then insert the data (with theindexes enabled), then rebuild the indexes with a 100% Fillfactor.Most of my RDBMS experience is with a different product. We would havedisabled the indexes and Foreign Keys, loaded the data, thenre-enabled them, moving any records that violated the constraints into anappropriate audit table to be checked after.Can someone share with me what the accepted "best practices" are for loadingdata efficiently into a data warehouse?Any thoughts would be deeply appreciated.Steve
View 2 Replies
View Related
Jul 21, 2006
Greetings,
I think these should be rather simple questions, yet I spent a number of hours last night digging through the forums here and msdn and couldn't find any satisfactory answers. Basically, there tend to be types of information that are commonly saved in most databases, like names, addresses, phone numbers, email addresses, etc...and there are a variety of built in data types in SQL Server. What are the best built in datatypes for some of the common entries in a sql database. Also, there are a number of character based types and I am curious why one would be more useful in certain situations than another. Why is there char( ), nchar( ), varchar( ), nvarchar( ) and text datatypes? Why so many? Also, what is the "text" datatype and when is it most likely to be used? There is very little about the text type that I can find in the msdn or SQL Server docs...aside from the fact that it's text. On top of all this, there's numerous binary types as well. I'm really not getting the reason behind all these different basic types and why I would want to use one over the other in any specific instance.
TIA,
Mark
View 14 Replies
View Related
Aug 15, 2007
[This is one of those cases where I think I know the answer, but I hope I'm wrong!]
I have a data flow which is processing data from the XML Source. There are 16 outputs from the XML Source. I have to perform a variety of validations on these outputs: things like "column 1 is required if column 2 has value 'a' or 'b'", or "column 1 or column 2 may be present, but not both".
For lookups and such, I use the Lookup component and its error output, both to redirect rows that fail the lookup, and to capture the data, column number and error code.
But, how do I do the same for "normal" validations?
If I have to use the Conditional Split transform, then I'll have to have one output per validation, and use a Union All to combine the rows again for output to an error file. This will also cost an extra "Derived Column" transform per output, in order to get a column number and possible error code per failed validation.
Worse, it's a pain to have to maintain all the columns in such a large "Union All"!
If I had the time, I might write a "Conditional Error" transform. It might be fun. But I have to be done by the end of this month, and don't even have time to create the UI for evaluating expressions!
Any tips or tricks or pointers to such would be very welcome.
View 9 Replies
View Related
Aug 13, 2007
Dear All,
I have created a table in my SQL server database, the problem i am facing is my insert query fails if i leave any form field empty (leave it blank). On my back-end table, only one field is mandatory, and others have been set with the constraint "allow null".
As per our business requirement, except one value is complusory while others are optional. If I enter all values in the form it works perfectly fine. Can you see in the code below - where am i possibly going wrong ?
<script language="VB" runat="server" > Sub Page_Load(Src As Object, e As EventArgs) If Page.IsPostBack Then Dim ConLath As SqlConnection Dim comLath As SqlCommand Dim insertcmd conLath = New SqlConnection("Data Source=SQLas;Initial Catalog=settle;User ID=sa;Password=password") ConLath.Open() insertcmd = "Insert into His_set values (@t_d,@s_p,@p_s,@v_oq,@i_oq,@v_qn,@i_qn,@v_qw,@i_qw)" comLath = New SqlCommand(insertcmd, ConLath) comLath.Parameters.Add(New SqlParameter("@t_d", SqlDbType.DateTime, 12)) comLath.Parameters("@t_d").Value = trade_date.Text comLath.Parameters.Add(New SqlParameter("@s_p", SqlDbType.Decimal, 8)) comLath.Parameters("@s_p").Value = sett_price.Text comLath.Parameters.Add(New SqlParameter("@p_s", SqlDbType.Decimal, 8)) comLath.Parameters("@p_s").Value = post_close.Text comLath.Parameters.Add(New SqlParameter("@v_oq", SqlDbType.Int, 8)) comLath.Parameters("@v_oq").Value = vol_oq.Text comLath.Parameters.Add(New SqlParameter("@i_oq", SqlDbType.Int, 8)) comLath.Parameters("@i_oq").Value = oi_oq.Text comLath.Parameters.Add(New SqlParameter("@v_qn", SqlDbType.Int, 8)) comLath.Parameters("@v_qn").Value = vol_qn.Text comLath.Parameters.Add(New SqlParameter("@v_qw", SqlDbType.Int, 8)) comLath.Parameters("@v_qw").Value = vol_qw.Text comLath.Parameters.Add(New SqlParameter("@i_qn", SqlDbType.Int, 8)) comLath.Parameters("@i_qn").Value = oi_qn.Text comLath.Parameters.Add(New SqlParameter("@i_qw", SqlDbType.Int, 8)) comLath.Parameters("@i_qw").Value = oi_qw.Text
Try comLath.ExecuteNonQuery() Catch ex As SqlException If ex.Number = 2627 Then Message.InnerHtml = "ERROR: A record already exists with " _ & "the same primary key" Else Message.InnerHtml = "ERROR: Could not add record, please " _ & "ensure the fields are correctly filled out" Message.Style("color") = "red" End If End Try
comLath.Dispose() ConLath.Close() End If End Sub
</script>
View 6 Replies
View Related
Jul 13, 2015
I have a requirement where i have to insert empty string in column whose datatype is decimal.
I have to replace the column value if it is null then insert it as ' '.
Obviously its generate error msg for conversion, is there any workaround for this. I cannot add 0 or other value as this column is used to generate some output value.
IIF(Column1 IS NULL, ' ', Column1))
I used TRY_PARSE but it insert null value if there is conversion error.
View 3 Replies
View Related
Apr 15, 2007
Hi,
I have two SQL Express database and I want to do two things. One is to transfer a table over to the other database. Two, move the files from one table in one database to another. Please let me know when you get a chance.
Thanks,
Kyle
View 8 Replies
View Related
Aug 28, 2007
I apologize if this has been asked, but I can't find a complete answer.
We have a situation with parent/child tables which have an identity column as their PK. We need to be able to insert into the live tables from staging tables. The data in the staging tables are related via a surrogate key.
I have found the OUTPUT clause, but that can only refer to columns of the actual table (since there is no FROM clause in an INSERT). Our current best solution to this problem involves adding bogus "staging" columns to the destination tables, and removing them after we've inserted everything from staging. This is an unattractive solution to say the least.
I'll give an example that mirrors our actual solution, and ask if anyone has a better solution?
----------
Code Snippet
CREATE TABLE [dbo].[TABLE_A](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DATA] [nchar](10) NOT NULL,
[STAGING_COLUMN] [bigint] NULL,
CONSTRAINT [PK_TABLE_A] PRIMARY KEY ([ID] ASC)
)
GO
CREATE TABLE [dbo].[TABLE_B](
[ID] [int] IDENTITY(1,1) NOT NULL,
[A_ID] [int] NOT NULL,
[DATA] [nchar](10) NOT NULL,
[STAGING_COLUMN] [bigint] NULL,
CONSTRAINT [PK_TABLE_B] PRIMARY KEY ([ID] ASC)
)
GO
ALTER TABLE [dbo].[TABLE_B]
ADD CONSTRAINT [FK_TABLE_A_TABLE_B] FOREIGN KEY([A_ID]) REFERENCES [dbo].[TABLE_A] ([ID])
GO
CREATE TABLE [dbo].[STAGE_TABLE_A](
[A_Key] [bigint] NOT NULL,
[DATA] [nchar](10) NOT NULL
)
GO
CREATE TABLE [dbo].[STAGE_TABLE_B](
[B_Key] [bigint] NOT NULL,
[DATA] [nchar](10) NOT NULL,
[A_Key] [bigint] NOT NULL
)
GO
The STAGING_COLUMN columns are the ones that will be added before, and dropped after.
Code Snippet
DECLARE @TABLE_A_MAP TABLE (
A_ID INT,
A_Key BIGINT
)
INSERT INTO TABLE_A (DATA, STAGING_COLUMN)
OUTPUT INSERTED.ID, INSERTED.STAGING_COLUMN INTO @TABLE_A_MAP
SELECT DATA, A_Key FROM STAGE_TABLE_A
INSERT INTO TABLE_B (A_ID, DATA)
SELECT TAM.A_ID, STB.DATA
FROM STAGE_TABLE_B STB INNER JOIN @TABLE_A_MAP TAM ON TAM.A_Key = STB.A_Key
This seems to work, but I'd really like another alternative. Even though this is happening when nobody else is using the database, I cringe at the thought of adding and removing columns just to make this work.
Here are a few of my constraints:
The above is a simplification of the actual problem. The actual problem goes about five levels deep (hence the B_Key in STAGE_TABLE_B). At the top level, our larger customer will have 100,000 rows to insert. Each level will average 3 times as many rows as the next higher level, so we're talking about real volumes here.
This has to finish over the course of a weekend.
This has to be delivered to QA this Friday
Thanks for any help or insight.
View 3 Replies
View Related
Feb 27, 2007
What is wrong with this code the dropdowlist mainlyusing System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class NewAccount : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { } protected void NaccountButton_Click(object sender, EventArgs e) { if (Page.IsValid) { //Define data objects SqlConnection conn; SqlCommand comm; //read from web config string connectionString = ConfigurationManager.ConnectionStrings["OneBank"].ConnectionString; //Initialize connection conn = new SqlConnection(connectionString); //create command comm =new SqlCommand( "INSERT INTO Customer (FirstName, LastName, Street, City, State," + "Zip, Phone, Payee,AccountType)" + "VALUES(FirstName, LastName, Street, City," + "State, Zip, Phone, Payee,AccountType)", conn); //add parameters comm.Parameters.Add("@FirstName", System.Data.SqlDbType.NVarChar, 50); comm.Parameters["@FirstName"].Value=Firstname.Text; comm.Parameters.Add("@LastName", System.Data.SqlDbType.NVarChar, 50); comm.Parameters["@LastName"].Value=lastname.Text; comm.Parameters.Add("@Street", System.Data.SqlDbType.NVarChar, 50); comm.Parameters["@Street"].Value=street.Text; comm.Parameters.Add("@City", System.Data.SqlDbType.NVarChar, 50); comm.Parameters["@City"].Value=city.Text; comm.Parameters.Add("@State", System.Data.SqlDbType.NVarChar, 50); comm.Parameters["@State"].Value=state.Text; comm.Parameters.Add("@Phone", System.Data.SqlDbType.Int); comm.Parameters["@Phone"].Value=phone.Text; comm.Parameters.Add("@AccountType", System.Data.SqlDbType.NVarChar, 50); comm.Parameters["AccountType"].Value = dropdownlist1.SelectedValue.ToString(); //Enclose database in try catc finally try { //open connection conn.Open(); //execute the command comm.ExecuteNonQuery(); //reload query Response.Redirect("NewAccount.aspx"); } catch { //Display error Errormessage.Text= "Error submitting request!"; } finally { conn.Close(); } } }}
This is the table where thisis going
customer ------------- customerID pk generated automatically firtsname lastname street city statezipphoneaccountType
View 3 Replies
View Related
Jul 21, 2005
I have a table changereport and network info.i insert a record with date of insertion plus chagereport id.then I have a xml file
<ChangeReport> <Network-Info> <Version> 2.0</Version> <Highest-Ver> 2.0</Highest-Ver> <Description> WinSock 2.0</Description> <System-Status> Running</System-Status> <Max> 2.0</Max> <IP-address> 192.168.142.1</IP-address> <Domain-Name> samin</Domain-Name> <UDP-Max> 2.0</UDP-Max> <Computer-Name> SAMIN</Computer-Name> <User-Name> samin</User-Name> </Network-Info></ChangeReport>
I want's to insert a record in network info table where field name are nodes name data should be the one against those nodes in xml file .How can I do it I am using sql server
View 2 Replies
View Related
Feb 21, 2006
What have I done wrong with this script?I'm getting an error The ConnectionString property has not been initialized.
Description: An
unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the
error and where it originated in the code.
Exception Details: System.InvalidOperationException: The ConnectionString property has not been initialized.
Source Error:
Line 73: myCommand.Parameters.Add(New SqlParameter("@Activationcode", SqlDbType.nVarChar, 50))Line 74: myCommand.Parameters("@Activationcode").value = activecode.valueLine 75: myCommand.Connection.open()Line 76: tryLine 77: myCommand.ExecuteNonQuery()
Dim loConn as New SqlConnection(ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_HWB"))Dim myCommand as SqlCommandDim InsertCmd as StringinsertCmd = "insert into Login values (@Username, @Password, @email, @Activationcode);"myCommand = New SqlCommand(InsertCmd, loConn)myCommand.Parameters.Add(New SqlParameter("@Username", SqlDbType.nVarChar, 50))myCommand.Parameters("@Username").value = Username.valuemyCommand.Parameters.Add(New SqlParameter("@Password", SqlDbType.nVarChar, 50))myCommand.Parameters("@Password").value = Password.valuemyCommand.Parameters.Add(New SqlParameter("@email", SqlDbType.nVarChar, 50))myCommand.Parameters("@email").value = email.valuemyCommand.Parameters.Add(New SqlParameter("@Activationcode", SqlDbType.nVarChar, 50))myCommand.Parameters("@Activationcode").value = activecode.valuemyCommand.Connection.open()myCommand.ExecuteNonQuery()myCommand.Connection.Close()
View 1 Replies
View Related
Apr 10, 2006
hi
It seems that my code can insert data into memory, but not into the database. What I mean is that after "insert data", I can "read data",
which I just insert. When I check the actual database table, it didn't
get updated.
I am using VS 2005 and table designer. Regarding to this problem, is
it related to any setting of setup of the database? I check the code,
and I have no idea how it occurs.
private static string connectionString = null;
private static SqlConnection connection = null;
private static string commandString = null;
private static SqlCommand command = null;
private static SqlDataReader reader = null;
static void Main(string[] args)
{
connectionString = ConfigurationManager
.ConnectionStrings["appDatabase.Properties.Settings.databaseConnection String"]
.ConnectionString;
connection = new SqlConnection(connectionString);
try
{
// Insert data
commandString = @"INSERT INTO userTable
(userID, permissionLevel, mobile, emailAddress, mailAddress, pager) VALUES(1, 2, '123', 'aa@a.com', 'oz', 'no')";
SqlCommand command = new SqlCommand(commandString, connection);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
// Read data
commandString = @"select * from userTable";
command = new SqlCommand(commandString, connection);
connection.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(reader["permissionLevel"].ToString());
}
connection.Close();
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
regards
figo2476
View 5 Replies
View Related
Apr 8, 2008
how to insert data from asp page into sql database using visual basic?????
View 3 Replies
View Related
Nov 11, 2014
I have 2 tables in my database.
one is Race table and 2nd one is Age Range.
I want to write a query where I can see all races and age range as column.
TblRace
ID, RaceName
TblAgeRange
ID,AgeRange.
There is no connection between this two table. I need to display result like below.
Race 17-20 21-30 31-40
A
B
I
W
How do i get this kind of empty data set so that I can fill it out in front end or any better solution. The age range will be displayed as many row as they have. It's not static. Above is just an example.
View 1 Replies
View Related
Sep 18, 2007
Ok what i am looking to do i cannot figure out.
What i want to do is have a simple script that when a user logs onto the website (via windows auth) to get there username somehow llike with
Request.ServerVariables("LOGON_USER")
that should display there username either "domain/name" or "username"
and then insert that into the UserLogs Table under my database with the date with the GETDATE() command..
But when i do this i cannot get the page to auto submit the values. Actually i cannot get anything to write to the DB unless i am doing it under the query builder.
Here is my Query that i was using.
INSERT INTO UserLogs([User], Date) VALUES (@UserName, GETDATE())
then in the Code of the page i have
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="SubmitForm.aspx.vb" Inherits="Template_SubmitForm" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server"><title>Untitled Page</title>
</head>
<body><% Dim name
name = Request.ServerVariables("LOGON_USER")%>
<form id="form1" runat="server">
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:REPCOMConnectionString %>"
InsertCommand="INSERT INTO UserLogs([User], Date) VALUES (@name, GETDATE())"
SelectCommand="SELECT [User], Date FROM UserLogs" CancelSelectOnNullParameter="False">
<InsertParameters>
<asp:SessionParameter DefaultValue="test1234" Name="name" SessionField="name" />
</InsertParameters>
</asp:SqlDataSource>
</form>
</body>
</html>
So i know i am doing something wrong but what?
Thank You,
Corey
View 1 Replies
View Related
Dec 26, 2007
Hallow
My code does not insert Data into Database, please can someone look on it and give a technical problem over here please
It does not generate any error please, when I CLICK THE BUTTON IT DOES NOT GENERATE ERROR, IT GIVE ME THE MESSAGE THAT ITEM ADDED, BUT WHEN I LOOK MY TABLE NOTHING ID INSIDE Sub Add_To_Cart(ByVal Src As Object, ByVal Args As EventArgs)
Dim FVProductID As Label = FormView1.FindControl("ProductID")
Dim FVProductName As Label = FormView1.FindControl("ProductName")Dim FVProductPrice As Label = FormView1.FindControl("ProductPrice")
Dim DBConnection As SqlConnection Dim DBCommand As SqlCommand
Dim sql As String
Dim SQLAddString As String
DBConnection = New SqlConnection("Data Source=MANDARISQLEXPRESS;Initial Catalog=SHOES;Integrated Security=True")
DBConnection.Open()
If Not Session("OrderID") Is Nothing Then
sql = "SELECT Count(*) FROM ShoppingCart " & _ "WHERE OrderID = '" & CType(Session("OrderID"), String) & "' " _
& "AND ProductID = '" & FVProductID.Text & "'"
DBCommand = New SqlCommand(sql, DBConnection)
If DBCommand.ExecuteScalar() = 0 Then
SQLAddString = "INSERT INTO ShoppingCart (OrderID, ProductID, OrderDate, ProductName, ProductPrice, ProductQnty) VALUES (" & _
"'" & CType(Session("OrderID"), String) & "', " & _"'" & FVProductID.Text & "', " & _
"'" & Today() & "', " & _"'" & FVProductName.Text & "', " & _
"'" & FVProductPrice.Text & "', 1)"DBCommand = New SqlCommand(SQLAddString, DBConnection)
DBCommand.ExecuteNonQuery()
End If
End If
DBConnection.Close()
Src.Text = "Item Added"Src.ForeColor = Color.FromName("#990000") Src.BackColor = Color.FromName("#E0E0E0")
Src.Font.Bold = True
End Sub
View 3 Replies
View Related
Jan 3, 2008
Hii Folks
This is my Table Order(OrderNo, CartID, TotalAmount, Name, City, Email, Zip, Date), Then I have my code which I need to insert data into database, but OrderNo is automatically inserted
this is my code, but when I run it it shows the error page, if I remove the direction to my error page, it does not show anything and I don't see any error, could any one check for it please
Imports System
Imports System.Data.SqlClientPartial Class Checkout
Inherits System.Web.UI.PageProtected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.LoadAmountLabel.Text = Session("OrderTotal").ToString()
SessionLabel.Text = Session.SessionID.ToString()
End SubProtected Sub ContinueButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ContinueButton.Click
Dim shopp As New SqlDataSource()shopp.ConnectionString = ConfigurationManager.ConnectionStrings("SHOESConnectionString").ConnectionString
shopp.InsertCommandType = SqlDataSourceCommandType.Text
shopp.InsertCommand = "INSERT INTO Order(CartID, TotalAmount, Name, City, Email, Zip, Date) VALUES (@CartID, @TotalAmount, @Name, @City, @Email, @Zip, @Date)"shopp.InsertParameters.Add("CartID", SessionLabel.Text)
shopp.InsertParameters.Add("TotalAmount", AmountLabel.Text)shopp.InsertParameters.Add("Name", NameTextBox.Text)
shopp.InsertParameters.Add("City", CityTextBox.Text)shopp.InsertParameters.Add("Email", EmailTextBox.Text)
shopp.InsertParameters.Add("Zip", ZipTextBox.Text)shopp.InsertParameters.Add("Date", DateTime.Now()) Dim rowaffected As Integer = 0
Try
rowaffected = shopp.Insert()Catch ex As Exception Server.Transfer("ErrorPage.aspx")
End Try
shopp = Nothing
If rowaffected <> 1 ThenServer.Transfer("ErrorPage.aspx")
ElseServer.Transfer("success_shopping.aspx")
End IfEnd Sub
End Class
View 6 Replies
View Related
Mar 25, 2008
HI all
I've used textboxes to insert data to database but when i click save button everything is ok but when i check in the database the values are null evrywhere below is my code. i am trying to save to different databases pls help!!
</table>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 157%; height: 32px;" bordercolor="#111111">
<tr><td width="100%" colspan="6" bgcolor="#eeeddb" align="center" style="height: 36px">
</td><tr>
<tr><td width="100%" colspan="6" bgcolor="#ffcc33" align="center" style="height: 41px">
<font color="#000000">Passenger's Details</font></td><tr>
<td bgcolor="#eeeddb" style="width: 164px; height: 16px;">Surname</td>
<td bgcolor="#eeeddb" style="width: 160px; height: 16px;">
Name</td>
<td bgcolor="#eeeddb" style="width: 129px; height: 16px;">
Initials</td>
<td bgcolor="#eeeddb" style="width: 17%; height: 16px;">
Title</td>
<td bgcolor="#eeeddb" style="width: 148px; height: 16px;">
Tel</td>
<td bgcolor="#eeeddb" style="width: 234px; height: 16px;">
Fax</td>
</tr>
<tr>
<td style="width: 164px">
<asp:TextBox ID="TextBox21" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 160px">
<asp:TextBox ID="TextBox22" runat="server" Enabled="False"></asp:TextBox></td>
<td>
<asp:TextBox ID="TextBox24" runat="server" Enabled="False"></asp:TextBox></td>
<td>
<asp:TextBox ID="TextBox26" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 148px">
<asp:TextBox ID="TextBox27" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 234px">
<asp:TextBox ID="TextBox28" runat="server" Enabled="False"></asp:TextBox></td>
</tr>
<tr>
<td bgcolor="#eeeddb" style="width: 164px; height: 16px;">Frequent Flyer Number</td>
<td bgcolor="#eeeddb" style="width: 160px; height: 16px;">
Seating Preference</td>
</tr>
<tr><td style="width: 164px">
<asp:TextBox ID="TextBox54" runat="server" Enabled="False"></asp:TextBox></td><td style="width: 160px">
<asp:TextBox ID="TextBox55" runat="server" Enabled="False"></asp:TextBox></td></tr>
</table>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 157%;" bordercolor="#111111" height="32">
<tr><td width="100%" colspan="7" bgcolor="#eeeddb" align="center" style="height: 32px">
</td><tr>
<tr><td width="100%" colspan="7" bgcolor="#ffcc33" align="center" style="height: 37px">
<font color="#000000">Flight's Details</font></td>
</tr>
<tr>
<tr >
<td bgcolor="#eeeddb" style="width: 154px;" height="16">
Routingļ¼</td>
<td style="width: 151px" bgcolor="#eeeddb" height="16" >
From</td>
<td style="width: 14%" bgcolor="#eeeddb" height="16">
To</td>
<td bgcolor="#eeeddb" style="width: 17%;" height="16" >
Dept Time</td>
<td style="width: 148px" bgcolor="#eeeddb" height="16">
Arriv Time</td>
<td style="width: 227px" bgcolor="#eeeddb" height="16" >
Flight</td>
<td bgcolor="#eeeddb" height="16" style="width: 137px" >
Class</td>
</tr>
<tr>
<td style="width: 154px">
<asp:Label ID="Label16" runat="server" Enabled="False" Font-Bold="True" Text="Leg 1"></asp:Label></td>
<td style="width: 151px">
<asp:TextBox ID="TextBox38" runat="server" Width="120px" Enabled="False"></asp:TextBox></td>
<td>
<asp:TextBox ID="TextBox41" runat="server" Enabled="False"></asp:TextBox></td>
<td>
<asp:TextBox ID="TextBox44" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 148px">
<asp:TextBox ID="TextBox47" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 227px">
<asp:TextBox ID="TextBox35" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 137px">
<asp:TextBox ID="TextBox82" runat="server" Enabled="False"></asp:TextBox></td></tr>
<tr>
<td style="width: 154px">
<asp:Label ID="Label5" runat="server" Enabled="False" Font-Bold="True" Text="Leg 2"></asp:Label></td>
<td style="width: 151px">
<asp:TextBox ID="TextBox39" runat="server" Width="120px" Enabled="False"></asp:TextBox></td>
<td>
<asp:TextBox ID="TextBox43" runat="server" Enabled="False"></asp:TextBox></td>
<td>
<asp:TextBox ID="TextBox45" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 148px">
<asp:TextBox ID="TextBox48" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 227px">
<asp:TextBox ID="TextBox36" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 111px">
<asp:TextBox ID="TextBox83" runat="server" Enabled="False"></asp:TextBox></td></tr>
<tr>
<td style="width: 154px; height: 25px;">
<asp:Label ID="Label8" runat="server" Enabled="False" Font-Bold="True" Text="Leg 3"></asp:Label></td>
<td style="width: 151px; height: 25px;">
<asp:TextBox ID="TextBox40" runat="server" Width="120px" Enabled="False"></asp:TextBox></td>
<td style="height: 25px">
<asp:TextBox ID="TextBox42" runat="server" Enabled="False"></asp:TextBox></td>
<td style="height: 25px">
<asp:TextBox ID="TextBox46" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 148px; height: 25px;">
<asp:TextBox ID="TextBox49" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 227px; height: 25px;">
<asp:TextBox ID="TextBox37" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 137px; height: 25px;">
<asp:TextBox ID="TextBox84" runat="server" Enabled="False" Height="14px" Width="147px"></asp:TextBox></td></tr>
</table>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 157%;" bordercolor="#111111" height="32" id="TABLE2">
<tr><td width="100%" colspan="6" bgcolor="#eeeddb" align="center" style="height: 38px">
</td><tr><tr>
<td colspan="7" bgcolor="#ffcc33" align="center" style="height: 37px; width: 107%;"><font color="#000000">Accomodation's Details</font></td>
</tr><tr>
<td bgcolor="#eeeddb" style="width: 41px; height: 29px;">Routingļ¼</td>
<td bgcolor="#eeeddb" style="width: 76px; height: 29px;">
Hotel Name</td>
<td bgcolor="#eeeddb" style="width: 14%; height: 29px;">
Check-in Date</td>
<td bgcolor="#eeeddb" style="width: 17%; height: 29px;">
Check-out Date</td>
<td bgcolor="#eeeddb" style="width: 113px; height: 29px;">
Room Type</td>
<td bgcolor="#eeeddb" style="width: 113px; height: 29px;">Included</td>
</tr>
<tr>
<td style="width: 41px; height: 31px;">
<asp:Label ID="Label9" runat="server" Enabled="False" Font-Bold="True" Text="Leg 1"></asp:Label></td>
<td style="width: 76px; height: 31px;">
<asp:TextBox ID="TextBox30" runat="server" Enabled="False"></asp:TextBox></td>
<td style="height: 31px">
<asp:TextBox ID="TextBox50" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 148px; height: 31px;">
<asp:TextBox ID="TextBox53" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 232px; height: 31px;">
<asp:TextBox ID="TextBox29" runat="server" Enabled="False"></asp:TextBox></td>
<td>
<asp:TextBox ID="TextBox85" runat="server" Enabled="False"></asp:TextBox>
</td>
</tr>
<tr>
<td style="width: 41px; height: 26px">
<asp:Label ID="Label10" runat="server" Enabled="False" Font-Bold="True" Text="Leg 2"></asp:Label></td>
<td style="width: 76px; height: 26px">
<asp:TextBox ID="TextBox33" runat="server" Enabled="False"></asp:TextBox></td>
<td style="height: 26px">
<asp:TextBox ID="TextBox51" runat="server" Enabled="False"></asp:TextBox></td>
<td style="height: 26px">
<asp:TextBox ID="TextBox56" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 148px; height: 26px;">
<asp:TextBox ID="TextBox31" runat="server" Enabled="False"></asp:TextBox></td>
<td>
<asp:TextBox ID="TextBox86" runat="server" Enabled="False"></asp:TextBox>
</td></tr>
<tr>
<td style="height: 20px; width: 41px;">
<asp:Label ID="Label11" runat="server" Enabled="False" Font-Bold="True" Text="Leg 3"></asp:Label></td>
<td style="height: 20px; width: 76px;">
<asp:TextBox ID="TextBox32" runat="server" Enabled="False"></asp:TextBox></td>
<td style="height: 20px">
<asp:TextBox ID="TextBox52" runat="server" Enabled="False"></asp:TextBox></td>
<td style="height: 20px">
<asp:TextBox ID="TextBox57" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 148px; height: 20px;">
<asp:TextBox ID="TextBox34" runat="server" Enabled="False"></asp:TextBox></td>
<td>
<asp:TextBox ID="TextBox87" runat="server" Enabled="False"></asp:TextBox>
</td></tr>
</table>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 157%;" bordercolor="#111111" height="32" id="TABLE3">
<tr><td width="100%" colspan="6" bgcolor="#eeeddb" align="center" style="height: 38px">
</td><tr><tr>
<td colspan="7" bgcolor="#ffcc33" align="center" style="height: 37px; width: 107%;"><font color="#000000">Vehicle's Details</font></td>
</tr><tr>
<td bgcolor="#eeeddb" style="width: 130px; height: 26px;">Company</td>
<td bgcolor="#eeeddb" style="width: 20%; height: 26px;">
Group</td>
<td bgcolor="#eeeddb" style="width: 129px; height: 26px;">
Pick-up Date</td>
<td bgcolor="#eeeddb" style="width: 17%; height: 26px;">
Pick-up Time</td>
<td bgcolor="#eeeddb" style="width: 113px; height: 26px;">Pick-up Addresss</td>
</tr><tr>
<td style="height: 20px">
<asp:TextBox ID="TextBox58" runat="server" Width="169px" Enabled="False"></asp:TextBox></td>
<td style="height: 20px">
<asp:TextBox ID="TextBox59" runat="server" Width="163px" Enabled="False"></asp:TextBox></td>
<td style="height: 20px">
<asp:TextBox ID="TextBox61" runat="server" Enabled="False"></asp:TextBox>
</td>
<td style="height: 20px">
<asp:TextBox ID="TextBox62" runat="server" Enabled="False"></asp:TextBox>
</td>
<td style="height: 20px">
<asp:TextBox ID="TextBox60" runat="server" Enabled="False"></asp:TextBox></td>
</tr><tr>
<td style="height: 22px">
<asp:TextBox ID="TextBox63" runat="server" Width="169px" Enabled="False"></asp:TextBox></td>
<td style="height: 22px">
<asp:TextBox ID="TextBox64" runat="server" Width="163px" Enabled="False"></asp:TextBox></td>
<td style="height: 22px">
<asp:TextBox ID="TextBox65" runat="server" Enabled="False"></asp:TextBox>
</td>
<td style="height: 22px">
<asp:TextBox ID="TextBox66" runat="server" Enabled="False"></asp:TextBox>
</td>
<td style="height: 22px">
<asp:TextBox ID="TextBox67" runat="server" Enabled="False"></asp:TextBox></td>
</tr><tr>
<td style="height: 20px">
<asp:TextBox ID="TextBox68" runat="server" Width="169px" Enabled="False"></asp:TextBox></td>
<td style="height: 20px">
<asp:TextBox ID="TextBox69" runat="server" Width="163px" Enabled="False"></asp:TextBox></td>
<td style="height: 20px">
<asp:TextBox ID="TextBox70" runat="server" Enabled="False"></asp:TextBox>
</td>
<td style="height: 20px">
<asp:TextBox ID="TextBox71" runat="server" Enabled="False"></asp:TextBox>
</td>
<td style="height: 20px">
<asp:TextBox ID="TextBox72" runat="server" Enabled="False"></asp:TextBox></td>
</tr>
<tr>
<td bgcolor="#eeeddb" style="width: 14%; height: 16px;">
Drop-off Date</td>
<td bgcolor="#eeeddb" style="width: 17%; height: 16px;">
Drop-off Time</td>
<td bgcolor="#eeeddb" style="width: 129px; height: 16px;">Drop-off Addresss</td></tr>
<tr><tr>
<td><asp:TextBox ID="TextBox74" runat="server" Enabled="False"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox75" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 129px"><asp:TextBox ID="TextBox73" runat="server" Width="183px" Enabled="False"></asp:TextBox></td>
</tr>
<tr>
<td style="height: 19px"><asp:TextBox ID="TextBox76" runat="server" Enabled="False"></asp:TextBox>
</td>
<td style="height: 19px">
<asp:TextBox ID="TextBox77" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 129px; height: 19px;"><asp:TextBox ID="TextBox78" runat="server" Width="183px" Enabled="False"></asp:TextBox></td>
</tr>
<tr>
<td><asp:TextBox ID="TextBox79" runat="server" Enabled="False"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox80" runat="server" Enabled="False"></asp:TextBox></td>
<td style="width: 129px"><asp:TextBox ID="TextBox81" runat="server" Width="183px" Enabled="False"></asp:TextBox></td>
</tr>
</table><table>
<tr>
<td style="width: 731px">
<br />
<br />
<asp:Button id="Button5" Text="Previous step" OnClick="PrevStep" runat="server"/>
<asp:Button ID="Save" runat="server" Text="Save" />
<input id="Button3" hidefocus="hidefocus" onclick="printpage(this)" type="button" value="Print" />
<input id="Button4" onclick="exit()" type="button" value="Cancel" /></td>
</tr>
</table>
</asp:Panel>
<!--/fieldset-->
</div>
<br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Travel BookingConnectionString7 %>"
DeleteCommand="DELETE FROM [Accomodation] WHERE [AccID] = @AccID" InsertCommand="INSERT INTO [Accomodation] ([Routing], [Hotel Name], [Check in date], [Check out date], [Included], [Room Type]) VALUES (@Routing, @Hotel_Name, @Check_in_date, @Check_out_date, @Included, @Room_Type)"
SelectCommand="SELECT [AccID], [Routing], [Hotel Name] AS Hotel_Name, [Check in date] AS Check_in_date, [Check out date] AS Check_out_date, [Included], [Room Type] AS Room_Type FROM [Accomodation]"
UpdateCommand="UPDATE [Accomodation] SET [Routing] = @Routing, [Hotel Name] = @Hotel_Name, [Check in date] = @Check_in_date, [Check out date] = @Check_out_date, [Included] = @Included, [Room Type] = @Room_Type WHERE [AccID] = @AccID">
<DeleteParameters>
<asp:Parameter Name="AccID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Routing" Type="String" />
<asp:Parameter Name="Hotel_Name" Type="String" />
<asp:Parameter Name="Check_in_date" Type="String" />
<asp:Parameter Name="Check_out_date" Type="String" />
<asp:Parameter Name="Included" Type="String" />
<asp:Parameter Name="Room_Type" Type="String" />
<asp:Parameter Name="AccID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:FormParameter Name="Routing" FormField="Label9" />
<asp:FormParameter Name="Hotel_Name" FormField="Textbox30" />
<asp:FormParameter Name="Check_in_date" FormField="Textbox50" />
<asp:FormParameter Name="Check_out_date" FormField="Textbox53" />
<asp:FormParameter Name="Included" FormField="Textbox85" /><asp:FormParameter Name="Room_Type" FormField="Textbox29" />
</InsertParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:Travel BookingConnectionString8 %>"
DeleteCommand="DELETE FROM [Flights] WHERE [FlightID] = @FlightID" InsertCommand="INSERT INTO [Flights] ([Routing], [Date], [From Date], [To Date], [Dept Time], [Arrive Time], [Flight], [Class]) VALUES (@Routing, @Date, @From_Date, @To_Date, @Dept_Time, @Arrive_Time, @Flight, @Class)"
SelectCommand="SELECT [FlightID], [Routing], [Date], [From Date] AS From_Date, [To Date] AS To_Date, [Dept Time] AS Dept_Time, [Arrive Time] AS Arrive_Time, [Flight], [Class] FROM [Flights]"
UpdateCommand="UPDATE [Flights] SET [Routing] = @Routing, [Date] = @Date, [From Date] = @From_Date, [To Date] = @To_Date, [Dept Time] = @Dept_Time, [Arrive Time] = @Arrive_Time, [Flight] = @Flight, [Class] = @Class WHERE [FlightID] = @FlightID">
<DeleteParameters>
<asp:Parameter Name="FlightID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Routing" Type="String" />
<asp:Parameter Name="Date" Type="DateTime" />
<asp:Parameter Name="From_Date" Type="String" />
<asp:Parameter Name="To_Date" Type="String" />
<asp:Parameter Name="Dept_Time" Type="DateTime" />
<asp:Parameter Name="Arrive_Time" Type="DateTime" />
<asp:Parameter Name="Flight" Type="String" />
<asp:Parameter Name="Class" Type="String" />
<asp:Parameter Name="FlightID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="Routing" Type="String" />
<asp:Parameter Name="Date" Type="DateTime" />
<asp:Parameter Name="From_Date" Type="String" />
<asp:Parameter Name="To_Date" Type="String" />
<asp:Parameter Name="Dept_Time" Type="DateTime" />
<asp:Parameter Name="Arrive_Time" Type="DateTime" />
<asp:Parameter Name="Flight" Type="String" />
<asp:Parameter Name="Class" Type="String" />
</InsertParameters></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:Travel BookingConnectionString4 %>"
DeleteCommand="DELETE FROM [Passenger] WHERE [PassengerID] = @PassengerID" InsertCommand="INSERT INTO [Passenger] ([Surname], [Name], [Initials], [Title], [Tel], [Fax], [FrequentFlyerNumber], [SeatingPreference], [Account Number], [OrderNo], [VehicleID], [AccomodationID], [FlightID], [Travel Consultant]) VALUES (@Surname, @Name, @Initials, @Title, @Tel, @Fax, @FrequentFlyerNumber, @SeatingPreference, @Account_Number, @OrderNo, @VehicleID, @AccomodationID, @FlightID, @Travel_Consultant)"
SelectCommand="SELECT [PassengerID], [Surname], [Name], [Initials], [Title], [Tel], [Fax], [FrequentFlyerNumber], [SeatingPreference], [Account Number] AS Account_Number, [OrderNo], [VehicleID], [AccomodationID], [FlightID], [Travel Consultant] AS Travel_Consultant FROM [Passenger]"
UpdateCommand="UPDATE [Passenger] SET [Surname] = @Surname, [Name] = @Name, [Initials] = @Initials, [Title] = @Title, [Tel] = @Tel, [Fax] = @Fax, [FrequentFlyerNumber] = @FrequentFlyerNumber, [SeatingPreference] = @SeatingPreference, [Account Number] = @Account_Number, [OrderNo] = @OrderNo, [VehicleID] = @VehicleID, [AccomodationID] = @AccomodationID, [FlightID] = @FlightID, [Travel Consultant] = @Travel_Consultant WHERE [PassengerID] = @PassengerID">
<DeleteParameters>
<asp:Parameter Name="PassengerID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Surname" Type="String" />
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="Initials" Type="String" />
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="Tel" Type="String" />
<asp:Parameter Name="Fax" Type="String" />
<asp:Parameter Name="FrequentFlyerNumber" Type="String" />
<asp:Parameter Name="SeatingPreference" Type="String" />
<asp:Parameter Name="Account_Number" Type="String" />
<asp:Parameter Name="OrderNo" Type="Int32" />
<asp:Parameter Name="VehicleID" Type="Int32" />
<asp:Parameter Name="AccomodationID" Type="Int32" />
<asp:Parameter Name="FlightID" Type="Int32" />
<asp:Parameter Name="Travel_Consultant" Type="String" />
<asp:Parameter Name="PassengerID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:formParameter Name="Surname" formfield="Textbox21" />
<asp:formParameter Name="Name" formfield="Textbox22" />
<asp:formParameter Name="Initials" formfield="Textbox24" />
<asp:formParameter Name="Title" formfield="Textbox26" />
<asp:formParameter Name="Tel" formfield="Textbox27" />
<asp:formParameter Name="Fax" formfield="Textbox28" />
<asp:formParameter Name="FrequentFlyerNumber" formfield="Textbox29" />
<asp:formParameter Name="SeatingPreference" formfield="Textbox55" />
<asp:formParameter Name="Account_Number" formfield="Textbox18" />
<asp:formParameter Name="OrderNo" formfield="Label2" />
<asp:Parameter Name="VehicleID" Type="Int32" />
<asp:Parameter Name="AccomodationID" Type="Int32" />
<asp:Parameter Name="FlightID" Type="Int32" />
<asp:formParameter Name="Travel_Consultant" formfield="Textbox19" />
</InsertParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:Travel BookingConnectionString5 %>"
DeleteCommand="DELETE FROM [Vehicle] WHERE [VehicleID] = @VehicleID" InsertCommand="INSERT INTO [Vehicle] ([Company Name], [Group], [Pick Up Time], [Pick Up Date], [Drop Off Address], [Drop Off Time], [Drop Off Date], [Pick up Address]) VALUES (@Company_Name, @Group, @Pick_Up_Time, @Pick_Up_Date, @Drop_Off_Address, @Drop_Off_Time, @Drop_Off_Date, @Pick_up_Address)"
SelectCommand="SELECT [VehicleID], [Company Name] AS Company_Name, [Group], [Pick Up Time] AS Pick_Up_Time, [Pick Up Date] AS Pick_Up_Date, [Drop Off Address] AS Drop_Off_Address, [Drop Off Time] AS Drop_Off_Time, [Drop Off Date] AS Drop_Off_Date, [Pick up Address] AS Pick_up_Address FROM [Vehicle]"
UpdateCommand="UPDATE [Vehicle] SET [Company Name] = @Company_Name, [Group] = @Group, [Pick Up Time] = @Pick_Up_Time, [Pick Up Date] = @Pick_Up_Date, [Drop Off Address] = @Drop_Off_Address, [Drop Off Time] = @Drop_Off_Time, [Drop Off Date] = @Drop_Off_Date, [Pick up Address] = @Pick_up_Address WHERE [VehicleID] = @VehicleID">
<DeleteParameters>
<asp:Parameter Name="VehicleID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Company_Name" Type="String" />
<asp:Parameter Name="Group" Type="String" />
<asp:Parameter Name="Pick_Up_Time" Type="DateTime" />
<asp:Parameter Name="Pick_Up_Date" Type="String" />
<asp:Parameter Name="Drop_Off_Address" Type="String" />
<asp:Parameter Name="Drop_Off_Time" Type="DateTime" />
<asp:Parameter Name="Drop_Off_Date" Type="String" />
<asp:Parameter Name="Pick_up_Address" Type="String" />
<asp:Parameter Name="VehicleID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="Company_Name" Type="String" />
<asp:Parameter Name="Group" Type="String" />
<asp:Parameter Name="Pick_Up_Time" Type="DateTime" />
<asp:Parameter Name="Pick_Up_Date" Type="String" />
<asp:Parameter Name="Drop_Off_Address" Type="String" />
<asp:Parameter Name="Drop_Off_Time" Type="DateTime" />
<asp:Parameter Name="Drop_Off_Date" Type="String" />
<asp:Parameter Name="Pick_up_Address" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:Travel BookingConnectionString6 %>"
DeleteCommand="DELETE FROM [Order] WHERE [OrderNo] = @OrderNo" SelectCommand="SELECT * FROM [Order]" InsertCommand="INSERT INTO [Order] ([Date]) VALUES (@Date)" UpdateCommand="UPDATE [Order] SET [Date] = @Date WHERE [OrderNo] = @OrderNo">
<DeleteParameters>
<asp:Parameter Name="OrderNo" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Date" Type="DateTime" />
<asp:Parameter Name="OrderNo" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="Date" Type="DateTime" />
</InsertParameters>
</asp:SqlDataSource>Protected Sub Save_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Save.Click
SqlDataSource1.Insert()
SqlDataSource2.Insert()
SqlDataSource3.Insert()
SqlDataSource4.Insert()
End Sub
thanx in advance
View 7 Replies
View Related
Apr 21, 2008
hello,
i have two datasets. i want to insert all data from one dataset to other.
i am using this:DataSet old = new DataSet();
download dd = new download();old = dd.contactlist("select", "admin", "001");
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Project1ConnectionString"].ToString());
try
{string cmd = "select * from contact";
SqlDataAdapter danew = new SqlDataAdapter(cmd, conn);DataSet dsOld = new DataSet();DataSet dsNew = new DataSet();
dsOld = old.Copy();
danew.Fill(dsNew);
DataTable dtOld = dsOld.Tables[0];DataTable dtNew = dsNew.Tables[0];
//int i;foreach (DataRow objRow in dtOld.Rows)
//for(int i=0; i<dtOld.Rows.Count; i++)
{DataRow row;
row = dtNew.NewRow();
row["company"] = objRow["company"];
row["cust_no"] = objRow["cust-no"];row["sman"] = objRow["sman"];
row["first_name"] = objRow["first-name"];row["contact_title"] = objRow["contact-title"];
row["type"] = objRow["type"];row["contact_loc"] = objRow["contact-loc"];
row["cust_name"] = objRow["cust-name"];row["addr1"] = objRow["addr1"];
row["addr2"] = objRow["addr2"];row["city"] = objRow["city"];
row["state"] = objRow["state"];row["zip"] = objRow["zip"];
row["territory"] = objRow["territory"];row["phone"] = objRow["phone"];
row["fax"] = objRow["fax"];row["extension"] = objRow["extension"];
row["email"] = objRow["email"];row["rec_key"] = objRow["rec_key"];
dtNew.Rows.Add(row);
}DataSet nds = dsNew.GetChanges();SqlCommandBuilder bld = new SqlCommandBuilder(danew);
danew.Update(nds);
}
here rec_key is the primary key.
this code works fine but it will insert all data from one dataset to other each time i click a button but i wanted that if data with a rec_key already exists will not insert. only unique values of rec_key will be inserted.
i am using this code for this:foreach(DataRow rr in dtNew.Rows)
{
if (rr["rec_key"] == objRow["rec_key"])
{
Response.Write("same");
}
else
{
dtNew.Rows.Add(row);
}
}
but this doesn't work.
please guide me how can i do this.
thanks
View 1 Replies
View Related
Dec 24, 2006
Hello to All,
I'm searching a way get Excel data into SQL database and tried this "insert" process that given me error. Already create a table call "original_purged" contain column fields. Can anyone give me some tips to show the problem?
INSERT Original_Purged
SELECT OP_ID,RBDI,Title,Address,City,State,Zip,Plus4,Walkseq,Crrt,Endorse,City_rural,Dpb,Dpbc,updatedate
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="C:Original_Purged.xls";User ID=Ryan;Password=dellonee1405;Extended properties=Excel 5.0')...[52117639]
==========================================================
Error occur.............
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication failed.
[OLE/DB provider returned message: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.].
thank you
ryan,
RV
View 5 Replies
View Related
