ADO.NET :: Insert Custom Data Format Into Sql Server 2005
Dec 17, 2010
i have a string like "13-9-10" i want to insert this as date into sql server 2005 in to a coumn "custdate" as type as datetime i added a sql paramater like this
Private Sub demoinsert(ByVal arr_data() As String)
DbCmd.CommandText = "INSERT INTO TBL_enqloan(cusdate) VALUES(@cusdate,)"
With DbCmd.Parameters
.Add("", SqlDbType.Date).Value=Convert.ToDateTime("arr(0).tostring")
end sub
I want to generate 30,000 cards and each card must be duplicate check with database. In my card, there are 2 things. Serial No and CardID. If any card already exists then I generate another card id but with the same serial no.
So how faster way I can generate 30,000 card with duplicate check? Which one I have made application, it takes about 25 minutes to insert.
I send a date parameter (@fdt and @Tdt) like "DD/MM/YYYY" format through Sql reporting servicesy query is select * from deposits where Depdate >= @fdt and Depdate <=@tdtin the aove query there is no record has been fetcheBut i give like this, Inthis case i get a resultselect * from deposits where Depdate >= '2010/04/01' and Depdate <= '2010/08/31'
I m just wondering is there any setting in sql server 2005 to change date format . I want to change it from US date format to normal one....i have seen some examples of changing it in while fetching data but than i have to change it for all sqldatasource strings...i m using sql server 2008 r2 but my hosting provider got sql server 2005
I'm completely new to both VB.NET and JSON, and I'm trying to figure out how to do SQL queries towards an SQL 2005 Express server and format the return value to JSON. I got the queries working using this (perhaps very newbie-like) code;
Imports System Imports System.Data Imports System.Data.SqlClient Imports System.Web.UI Imports System.Web.UI.WebControls Partial Public Class SQLConnect Inherits System.Web.UI.Page 'Defines SQL variables Dim con As New SqlConnection Dim cmd As New SqlCommand Dim dr As SqlDataReader Dim ReadData As String Dim i As Integer Sub Click(ByVal s As Object, ByVal e As EventArgs) 'Define SQL address, database, username and password con.ConnectionString = "Data Source=localhostSQLEXPRESS;Initial Catalog=tempdb;User ID=tesst;Password=test" Try 'Initialize connection con.Open() 'Specify SQL query cmd = New SqlCommand("SELECT * FROM Member", con) 'Execute query, dump result array into variable dr = cmd.ExecuteReader() messageLabel.Text = "<br />Connection established<br />" While (dr.Read) i = 0 For i = 0 To dr.FieldCount - 1 'Dump query results into a variable ReadData += dr.Item(i).ToString Next End While 'Print query results messageLabel2.Text = ReadData 'Close connection con.Close() Catch ex As Exception messageLabel.Text = "<br />Connection failed<br />" End Try End Sub End Class
I have been looking at this, and I would love to see some code examples using this class or any other good method.
I'm using stored procedures and DataContext to insert data to SQL Server database (ASP.NET 4 + SQL Server 2005 database, GoDaddy hosting)But after inserting russian text I see smth like this - '??????'If I insert constant text I'm using following construction - N'russian_text' and it works fine.Of course, I need to use variables as procedure parameters BUT I can't use it (for example - N@var fails)ALTHOUGH I'm using N-type fields in tables (nvarchar etc.)
I am designing a social networking site that has a "wall" feature like the others out there today. The database has an alerts table that stores some user action worthy of sharing with his friends. For example, when a user updates his status, all of his friends are notified. The below table shows two status updates from two unique users. The first (AlertId 689 and 690) is submitted by AccountId 53. Since he has one frinend - AccountId 57 - that row is added to the table so when this user logs on, he will see Account 53's update on his wall. In the same manner, the other user's status update has four rows because he has three friends.
[AlertId] [AccountId] [CreateDate] [Timestamp] [AlertTypeId] [IsHidden] [Body] 689 57 2010-08-10 0x0000000000018725 10 0 HTML 690 53 2010-08-10 0x0000000000018726 10 0 HTML 691 53 2010-08-10 0x000000000001872B 10 0 HTML 692 52 2010-08-10 0x000000000001872C 10 0 HTML 693 51 2010-08-10 0x000000000001872D 10 0 HTML 694 57 2010-08-10 0x000000000001872E 10 0 HTML
Now, a user can comment on any given item, in this case a statusupdate. When AddComment is submitted, we are using ObjectRecordId (which is the primary key of the alert being commented on) in order to identify which statusupdate is being commented on (fyi - the objectId tells us its a statusupdate):
public void AddComment(string comment) { if (_webContext != null) { var c = new Comment { Body = comment, CommentByAccountId = _webContext.CurrentUser.AccountId, CommentByUserName = _webContext.CurrentUser.UserName, CreateDate = DateTime.Now, SystemObjectId = _view.ObjectId, SystemObjectRecordId = _view.ObjectRecordId }; _commentRepository.SaveComment(c); } _view.ClearComments(); LoadComments(); }
Now, the problem is that when a user wants to comment on a friend's status update, he will be using the AlertId (or ObjectRecordId in the Comments table) corresponding to his account in the alerts table. The result is that comments are only viewable by the commenter and none of his friends:
Of course the solution to this is to do something similar to what I did in the alerts table - when somebody makes a comment, make a corresponding row for every friend in the comments table. But how do I access the AlertIds of all of my friend's status updates in the Alerts table and map them to the ObjectRecordId column in the comments table? Since I can only access the status updates corresponding to my account (and their corresponding alertids), I don't know what the alertids are for the same statusupdate in my friend's accounts.
How to store the datetime value in dd/mm/yyyy format to the sqlserver database,,,,,this is mycode
 connection.Open() cmd = New SqlCommand("insert into datecheck(id,fromdate,todate)values(@id,@fromdate,@todate)", connection) cmd.Parameters.Add("id", SqlDbType.Int).Value = TextBox1.Text cmd.Parameters.Add("fromdate", SqlDbType.DateTime).Value = DateTime.Parse(txtdob.Text) cmd.Parameters.Add("todate", SqlDbType.DateTime).Value = DateTime.Parse(txtdoj.Text) cmd.ExecuteNonQuery() Response.Write("ok") End Sub
I have a select statement and want to be able to insert some spaces in the returned data:
[Code]....
For the parts with ' - ', I want to remove the dash and simply put spaces now. But when I remove the dash and put 4 spaces, I only get one space. How do I put in those 4 spaces?
moving some tables & stored procedures from SQL Server 2000, to SQL Server 2005.So far so good, but I've come across a problem with this stored procedure:
I am selecting the date field in the 'dd-mm-yyyy' format by using SQL Codes(103,105...).While inserting I want the userto insert the date in same format(dd-mm-yyyy) but it will not happening as in SQL Server we need to insert the date in'mm-dd-yyyy' format.Pls send me insertion query in sql to achieve this.Pls respond me ASAP.
I want to read date field from Excel sheet and insert it into SQL Server2005.When I read date field it gives me a number say '40160' when the date feild is "08/01/2010"
How should to Read a date field from Excel Sheet Cells?
I used SQL SERVER 2008 R2 express as my web development database and I set its compatibility level to 2005. Unfortunately this database cannot be be attached to SQL server 2005. Are there any other options?
i had the sql 2008 enterprise and i want to go back to sql server 2005 because in 2008 i created new database but when i did some changes in the table , it gave me an eror that i cant save thins and i need to creat new one if some one know what i'm talking aboutif not i need the sql server installation tutorial i tried by myself but probebly i did it wrong and now i cant connect well to the sql
My problem is that I have a different format table for each section in my form. And I would like to bind data to these tables. A repeater I don't think is going to work. It would be great if I can do it like this:
[Code]....
Where the "+ 1" is the next record from that datasource --which is bound in code behind. Is there anyway, I can accomplish this without resorting to dynamically created tables.