I get the following error when I try to save a date:
When converting a string to DateTime, parse the string to take the date before putting each variable in the DateTime object.I was using a calendar control thinking that might have been the problem so I am using just a text box for entry. In the ASP code for the Insert statement, I have this:
<asp:controlParameter Name="InDate" Type="DateTime" ControlID="txtInDate" />I have double checked the SQL table to make sure that the field is DateTime and it is. Also, if I have not selected a date or the textbox contains no information then it does not error and just saves the field blank.What do I need to do to store this date?Thanks for the information.
Hi, I want to save date into SQL server pls help me how to save this date into server. its give me syntax error that converting datetime to character string. and also I want to save date only in mm/dd/yy format in a sql not including time. The following code I am using sub SaveEvent(sender as object, e as EventArgs) Dim dt As DateTime = DateTime.Parse(eventdate.Text) lbl.text=dt dim con as new SQLConnection("server=london-home; Database=tony; uid=rashid2; pwd=test; ") dim cmd as new SQLCommand("insert into events values('" & dt & "','" & desc.text & "')",con) con.open() cmd.executenonquery() con.close() end sub
I have a calendar control on a page that is saving the date to a SQL Server 2005 table and this works fine; but how do I also save it with the current time? It is always saving as 12:00:00 AM. Thanks for the help.
I am trying to automate a basic task using SQL Server 2005 Express.
Currently I have a query script that I run and then save the results as a CSV file. I need to do this on a daily basis and so I am looking to find out how best to go about this. There are a multitude of third party tools that claim to be able to do this - can anyone recommend this or enlighten me of the best way to set up this automation.
HiI am using SQL 2005, VB 2005I am trying to insert a record using parameters using the following code as per MotLey suggestion and it works finestring insertSQL; insertSQL = "INSERT INTO Issue(ProjectID, TypeofEntryID, PriorityID ,Title, Area) VALUES (@ProjectID, @TypeofEntryID, @PriorityID ,@Title, @Area)"; cmdInsert SqlCommand; cmdInsert=new SqlCommand(insertSQL,conn); cmdInsert.Parameters.Add("@ProjectID",SqlDbType.Varchar).Value=ProjectID.Text; My query is how to detail with dates my previous code wasinsertSQL += "convert(datetime,'" + DateTime.Now.ToString("dd/MM/yy") + "',3), '";I tried the code below but the record doesn't save?string date = DateTime.Now.ToString("dd/MM/yy"); insertSQL = "INSERT INTO WorkFlow(IssueID, TaskID, TaskDone, Date ,StaffID) VALUES (@IDIssue, @IDTask, @TaskDone, convert(DateTime,@Date,3),@IDStaff)"; cmdInsert.Parameters.Add("IDIssue", SqlDbType.Int).Value = IDIssue.ToString();cmdInsert.Parameters.Add("IDTask",SqlDbType.Int).Value = IDTask.Text;cmdInsert.Parameters.Add("TaskDone",SqlDbType.VarChar).Value = TaskDoneTxtbox.Text;cmdInsert.Parameters.Add("Date",SqlDbType.DateTime).Value = date;cmdInsert.Parameters.Add("IDStaff",SqlDbType.Int).Value = IDStaff.Text;Could someone point to me in the right direction?Thanks in advance
Please i need to save records using DataSet. I created the connectionstring as a global variable. In th button_Click event i have this : Protected Sub btnAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Dim InsAdapter As New SqlDataAdapter Dim StrInsert As String = "insert into Products(CategoryId,ProductName,ProductCode,ProductPrice,) values(@CategoryId,@ProductName,@ProductCode,@ProductPrice)" Dim ObjComm As New SqlCommand(StrInsert, ObjConn) ObjComm.Parameters.Add("@CategoryId", SqlDbType.Int).Value = drpCategory.SelectedValue ObjComm.Parameters.Add("@ProductName", SqlDbType.NVarChar, 30).Value = txtName.Text ObjComm.Parameters.Add("@ProductCode", SqlDbType.NVarChar, 10).Value = txtCode.Text ObjComm.Parameters.Add("@ProductPrice", SqlDbType.Int).Value = txtPrice.Text InsAdapter.InsertCommand = ObjComm End Sub But on clicking the button, the record is never saved. Please help
I am currently migrating my application from Access to SQL. It looks like it's working good but one thing I cannot understand is why when I have created a varchar(40) field and after I insert a field that is less then 40 characters long, the rest of the string is filled with the leading spaces. I have also create an nchar(40) that did not solve it ether. For example: the text is "Hello World". The text is 11 characters long but the data saved to the table is: "Hello Wolrd" + 29 spaces. Am I doing something wrong?Thanks for your help in advance.
When I open a DTS package, save it as a bas file, make changes, close the package and save it when prompted, where are my changes saved?
The answer appears to be nowhere. When I reopen the package it's back to it's original setup. When I check the bas file it's as it was when I originally saved it.
We have a table with 3.5 million records in it. We have been forced to add two fields and set indexes on those fields. But when we try to save the changes it times out. When we try to generate a change script it also times out. Is this a memeory issue? Any ideas on whats causing this or how to fix it woudl be greatly appriciated.
Hi, all.This might be a silly question... but I am very new to programming inSQL so please bear with me :)So. I'm using MS SQL Server 2005 Management Studio Express. I have atable that was created via an existing .sql file. Included were abunch of stored procedures. I went in to re-format these procedures.(They were written in haste by another programmer. It is my task to goback and improve their readabilities.) However, I am having difficultyfiguring out how to save the changes to these stored procedures. Thusfar, I have been individually saving each stored procedure in itsown .sql file. This is obviously not the way to go... but it's atemporary solution (so as not to lose the changes I have made todozens of procedures).Can someone please explain to me how I commit these changes to thedatabase?Thanks,Allie
Using vb 2005 express I have my grid veiw on the form and a icon to click to save my work.
But is there a passage of code I can write to pop up a message box to remind me to save my work when I close my form. Similar to ms office forms when you close they ask you if you want to save any changes.
Is it better to have users that upload pictures have them saved to SQL server or to a folder? I have a site where users enter things that they own (and each item has a unique id) and now I would like to add the functionality to add a picture. I am sure I should use the fileUpload control, but should this save to a folder created for each user or to the SQL record itself? Or possibly a separate SQL table just for pictures?Thanks for the help.
Hello Im having a little problem getting some values from a database..... What I need is to get the value of the keyfield of the last entry introduced, I know how to to do the SQL statement for this, the problem is that i dont know how to save this value in a variable. I need to save this value in a variable in the session object or in a hidden field, and then use this variable in another different page. That's way i need to save this ID value, later in the other page I introduce data in a different table and one of the fields has to be this ID value which I have as a foreign key in the table so I need to use the same value in all the rows i introduce(Id value). If you know how to accomplish this let me know, many thanks, Sergio
In my system, I generate invoices as PDF for my clients and I need to email them and save them on the database. What is the best approach for achieving that?!
Shall I save the files path in the SQL server 2000 as ( varchar ) and save files in a folder in the server or there is another approach?! is there any recommendation or advice about the procedure to send emails shall i save them first then send them or ...!??
Hi All 2 post in a row first time in ages so i must be getting better but i get stuck on crappy little things like this hopefully I have data in the following format 4.1399999999999997 4.2400000000000002 5.4800000000000004 5.1799999999999997 6.7699999999999996 i want to select the data as such 4.13 4.24 5.48 5.17 6.76 I keep chasing my tale on this one around and around any one got a simple idea i am missing, you would not believe how much time i have spent on this. Cheers Phil
database file is not full and not limited to growth. As a matter of fact batch transactions are done but our proble is very slow. 28 records has been successfully save after 45 mins. Before it's just 5 minutes. Then some other process are not working. Is there anything that I must do? We have 460 tables in our software using SQL server 2000 and our application is using VB 6.0
Im not really sure if this is the right thing to do. But i want to save a copy of the html from my invoice to sql so that i can keep a history of the invoices in case their are changes done to them. Anybody know what would be the best way to do this?
Hello,I use SQL Server 2005 Express and I would liketo save on db of mine...Have I only to save the .mdf and .ldf data fileor I need to stop some service or other programs?Can I use some utility to schedule this?ThanksM.
If you use the command UPDATE <tablename> SET <fieldname> = ' ... ' toupdate a CHAR or TEXT field there are some characters that can causeproblems such as a single quote. Are there any other type of charaters likethat?TIA
i created two tables. I placed both tables in a single form. When i run the application and enter some data in both table only data entered in first table is saved when i press the save button. As such when i run the application again and browse through the records of the first tables i cannot see the respective data in the second table though there is a relationship between both tables.
My install of SQL Server 2005 runs like a dog. The SQL Management Studio splash screen lasts for 10 minutes, then when the Studio window appears it takes another 5 minutes to initialize.
I have SQL server installed on a Germane Server running Windows Server 2K, SP4. It has quad Xeon 2.8 GHz processors with 2GB RAM. 4 300GB drives in a RAID 5 configuration.
I have created 2 databases which I would like to save, uninstall SQL, then reinstall it. (I didn't install it the first time.)
SAVING PROBLEM Now i know that my database is really saving but it is being saved on the copy database in bin folder of the project folder. But i want it to be saved on databse of the project folder. Everytime I execute the program, the database on the project folder copies itself to the bin folder which overwrites the updated database.
I agree with Antoine (Software Design Engineer, Visual Studio Data Design-time) that SSE database has 2 copies (http://blogs.msdn.com/smartclientdata/archive/2005/08/26/456886.aspx). He or she suggested to set the property of the databse to "Copy Never", on my SSE it's "Do not copy". i cant find "Copy Never", i supposed its the equivalent. When i executed the program i got an error "An attempt to attach an auto-named database for file C:[app_path]addressbook.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share". I tried her/his 2nd suggestion, leave the data file outside the project and create a connection to it in Database Explorer, but I got the same error message.
Someone from other website suggested to delete the SQLExpress folder in "c:Documents and Settings[user name]Local SettingsApplication DataMicrosoftMicrosoft SQL Server DataSQLEXPRESS" but this didnt solve the issue.
I just started using Visual Studio 2005. How do you actually save your queries to use again? Also, is there a way to export results in a user friendly format?
Ok. So I have this ASP.NET page and I've programmatically taken a report from the report server and rendered it in PDF. Now I would like to take this a step further and save the report as a pdf document on the local machine.
So at this point I have a byte array representing the document, now how would I save this as a pdf on the local machine? I'm unaware of an ASP Response method to allow this and I'm unaware of a SSRS ReportingService method, but as I said I'm unaware...
Hi. I am new to SQL Server management. I created a new database and also a table names customer. Saved my works. Want ot know where the SQL database file has been saved because i cant find in the the sql server management folder located in my documents. Also i tried to connect to that database from vb 2008 but in vain. i just cant see the database.
Hi.. I'm trying to save text into SQL 2000 database. When user enter text in text box , the text save into variable , and show it in confirm page , after save the text to database, all the text turned into "??" I try to view the data in SQL enterprise Manager / Web Matrix / ASP web page gridview , all of them showing the text fields in "??" Then I try to add record which come with SQL 2000 enterprise Manager.After save the record , the chinese also turned into "??" Is there something I need to set for database or server?
I have 3 strings delimitted by a * character that I would like to save to a database. Each string will always have the same number of elements. strUserID = "1*2*3" strCompanyID="12931*12937*12945" strCompanyName="International Business Machines, Inc*Ford Motor Company*Delta Airlines" What I need to do is to save each record like this INSERT INTO tableA (UserID, CompanyID, CompanyName) VALUES (1, 12931, 'International Business Machines, Inc') INSERT INTO tableA (UserID, CompanyID, CompanyName) VALUES (2, 12937, 'Ford Motor Company') INSERT INTO tableA (UserID, CompanyID, CompanyName) VALUES (3, 12945, 'Delta Airlines') I've done something like this before with a single string, but don't know how to handle 3 of them. Dim strAlerts As String() = NothingstrAlerts = values.Split(",")Dim s As String For Each s In strAlerts SqlText = "INSERT INTO tableA (UserID, CompanyID, CompanyName) VALUES (" & lblUserID.Text & ", '" & lblCompanyID.Text & "','" & s & "')" cmd = New SqlCommand(SqlText, strSQLConn) cmd.ExecuteNonQuery() Next s Thanks for any help
Hi,There are 3 tablesTable,TableDetails,TableDaily.With structureTABLE:TableID UserID Money---------- ---------- ----------(int) (int) (money)TABLEDETAILS:TableDetailsID TableID ItemID PaidForItem DayID---------- ---------- ---------- ---------- ----------(int) (int) (int) (money) (int)TABLEDAILY:TableDailyID TableID PaidForItem Money Total Change---------- ---------- ---------- ---------- ---------- ----------(int) (int) (money) (money) (PaidForItem + Money) (money)"Table" holds id for user and his money amount, which changes during time. "TableDetails" holds data about items user bought, amount paid for them and dayid which relates to one particular day."TableDaily" holds history. I do not know how to update this table.I created job whish runs stored procedure. This procedure sums "PaidForItem" using group by TableID and WHERE DAYID = '11'.Problem is with Change column. This column sould hold difference between today's Total and previous one etc.Current procedure looks like this:INSERT INTO TableDaily (TableID, PaidForItem, Money, DayID)SELECT TableDetails.TableID, SUM(PaidForItem) AS PaidForItem, Table.Money, (SELECT DayID FROM Days WHERE (Aktive = 1)) AS DayIDFROM TableDetails INNER JOIN Table ON TableDetails.TableID = Table.TableID GROUP BY TableDetails.TableID, Table.Money
has anyone got any opinions on the pros/cons of storing mp3 files in the database instead of the file system ? How could this be done ? Would it be a binary data type ?
Hi I’m making a very primitive shopping cart. I’ve created a table containing a list of products and using an SQLdataSource with a GridView I’ve got the products displayed – simple. What I now need is to add a button with an Insert command, but the SQL needs to add a row of data to a different table – tblShoppingBasket. I’ve tried adding in the insert command and changing the SQL but it doesn’t add a new record, although is also doesn’t through and error. The second part of the problem is need to pass the productID from the row they selected (pressed the button that triggered the insert command) and add this to the shoppingBasket table via the insert SQL. I’d really be grateful for any help (code below). ThanksRichard <asp:SqlDataSource ID="SqlDataSource_GenralProducts" runat="server" ConnectionString="<%$ ConnectionStrings:AquilaConnectionString %>" SelectCommand="SELECT * FROM [tblProducts] WHERE ([productAgeGroup] = @productAgeGroup)" InsertCommand="INSERT INTO [tblShoppingBasket] ([userID], [productID]) VALUES (@userID, @productID)"> <SelectParameters> <asp:Parameter DefaultValue="3" Name="productAgeGroup" Type="Int32" /> </SelectParameters> <InsertParameters> <asp:Parameter Name="userID" Type="Object" DefaultValue="123"/> <asp:Parameter Name="productID" Type="Int32" /> </InsertParameters> </asp:SqlDataSource> <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" DataKeyNames="productsID" DataSourceID="SqlDataSource_GenralProducts"> <Columns> <asp:ImageField DataImageUrlField="productThumbNail" DataImageUrlFormatString="../images/shop/thumbNails/{0}"> </asp:ImageField> <asp:BoundField DataField="productLabel" HeaderText="Product:" SortExpression="productLabel" /> <asp:BoundField DataField="productDescription" HeaderText="Description:" SortExpression="productDescription" /> <asp:BoundField DataField="productCost" HeaderText="Cost:" SortExpression="productCost" /> <asp:ButtonField ButtonType="Button" CommandName="insert" Text="Add to Shopping Basket" /> </Columns> </asp:GridView>
