I am trying to retrieve the ID (auto incremented) form a Table after I do an insert. I have tried using one of the Variable I used to insert with no success. I am inserting a record with Todays Date (if one does not allready exsist) then trying to read that record to get the AutoInc number (DailyTimeRecordID). Where am I going wrong?
Here is my code
[Code]....
I am workining in vb.net and sql. In DB have a uniqueidentifier field and want to insert in it,
When try to send data, some thing parameter: ByVal value as GUID
In the query : '"& Value &"' then errors occurs " Operator & not define or supporting and System.GUID "
If do like that : '"& CAST(Value as uniqueidentifier) &"' then Says CAST undefined same with Convert.
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 have 2 table's
Table 1: Daily_item
Fields: Key_Guid Drescription Count
1 test 3
3 new item 2
I want to insert records form table 1 into table 2 but using the count field to duplicate the Key_guid record the new table.
New table example:
Table 2
Key_guid
1
1
1
3
3
I am using Visual studio 2010 express and I have a details view databinded to an sql database table. When I use the Insert option on the view it causes an error due to it trying to insert a null into the primary key field. If the Insert function does not create a new primary key entry how is it created?
View 9 RepliesI have a form with many form fields and controls, with some offering an "other" if a value does not meet the needs for the user. How can I bind the sql insert so that it will take the ddl selection along with the txt field selection for the "other" value? Even if the txt field is empty it should not be a big deal since the ddl would provide something other than null. Since the column in the db does not allow nulls. I'm using asp.net (vb) 3.5 sp1
View 3 RepliesI store images in mysql as a longblob. The image control only takes an imageurl, so I have to have an ashx page serve up the images and then the image control uses that page as the imageurl. It works, but does that mean I have to do this for each image, kinda gets complicated for a lot of images.
Or should I just store the images on the hard disk? I am worried though about the space I would need if my site grows, as I want it scalable.
I want to retrieve the "RowID" for a new Row after an Insert. I am using DetailsView and EntityDataSource. Here is the code I was trying to use:
[Code]....
[Code]....
I have a SQL Server table with a number of fields that are defined with the "Float" data type. I'm running a simple query to retrieve the data from this table and use it to populate a Data Table in my C#.net application.
I just discovered that the data type of the Data Table fields is Double, not Float as I expected. As such, when I store a value like 0.157 it ends up getting stored like this: 0.15700000524520874
I'm aware that such extra "noise" occurs when such a conversion occurs. My major question has to do with why .Net didn't set the Data Type to Float (ie. Single) when the table was first populated?
I have some issues about retrieveing and storing date information to my database (ms sql server 2005).My data column is a DateTime, and i have set my web.config globalization culture is set to "en-gb"
When i retrieve date from the datebase it appears as dd/MM/yy, that's fine. But i cannot insert a new date as same format?! It will only accept MM/dd/yy or yy/mm/dd.Right now i'm using this code to correct the error:
[Code]....
Is it possible to change the date format on the database or something, so i dont need to use this code?
how can insert null value into integer field
View 3 Repliesi need to insert multiple rows at a time into database table(sqlserver) from datatable or gridview. Actually iam looping through the rows of gridview and inserting each row. Is there any method to insert entire table of rows at a time into database table. Both datatable columns and database table coulmns are similar.
View 2 RepliesI am new to .NET and MVC, so this is most likely a simple question: How can I have a default value appear for an Html.TextBox or TextArea field, for example if the code is currently - <%=Html.TextBox("ApplyToFax", Model.Competition.ApplyToFax, New With {.class = "regular", .maxlength = "50"})%>. I am looking to have a default fax number appear in the box when the page loads, for example (999) 999-9999.
View 5 RepliesFor example: INSERT INTO table (col1, col2, col3) VALUES ('value1','value2,'value3')But I would only like to insert the row if value3 isnt already present in col3 in some previous row. What is the best way to do that?And the insert command is run 50+ times in a loop (with different values each time for value3)
View 4 Replieshow to use database return many field and insert in a object(like any Collection ,Array,Hashtable etc)
[code]....
.NET newbie. I know there has to be a way to do this.I have a details view with it's default mode set to Insert. This is to be used as a form for users to enter records into a database. For two of the fields, I want to pre-populate the field with information. Specifically, I have a vb script with a few functions to query Active Directory to return the user's name based upon their user id. This script works fine.I call the functions for the user name like this:
<InsertItemTemplate>
<asp:TextBox ID="txtUserID" runat="server" Text='<%#CurrentUID() %>'></asp:TextBox>
</InsertItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="txtUserName" runat="server" Text='<%# GetUserName(CurrentUID()) %>'></asp:TextBox>
</InsertItemTemplate>
When the page loads, this populates the text boxes with the user id and the user name.But when the form is submitted, the values in the text boxes are not inserted in to the database.How can I set default values for the fields when the values come from functions?
I have a column in my database which contains null value. Now after retrieving value from database i want to store that value in my txtbox. I am getting
[DBTableFieldIsNullException: Field 'Title' is NULL] exception.
I have a form and stored procedure that inserts the data from the form. It works fine except that if a field isn't filled in it doesn't insert a NULL into sql it inserts "".
I've tried a few different ways but none seem to insert NULL, the one below still inserts "", can anyone point me in the right direction.
Here is the required part of the code, if you require more just let me know.
[code]....
So if I enter nothing into address1 field it should write NULL to screen but it always writes NOT NULL.
I'm trying to insert userid that is a System.Guid into an additional table into the same userid field that is uniqueidentifier. It seems as it cannot insert the System.Guid type there wether I'm passing it directly as the System.Guid or as a String then converting.
<System.ComponentModel.DataObjectMethodAttribute _
(System.ComponentModel.DataObjectMethodType.Insert, True)> _
Public Function InsertUserInterests( _
ByVal strUserId As String, ByVal strCode As String) _
As Boolean
Dim userInter As New DS1.tblUserInterestsDataTable
Dim userInterRow As DS1.tblUserInterestsRow = userInter.NewtblUserInterestsRow
Dim ug As System.Guid = New Guid(strUserId)
userInterRow.UserId = ug ' This didn't go through I beleive
userInterRow.InterestCode = strCode
userInter.AddtblUserInterestsRow(userInterRow)
Dim rowsAffected As Integer = Adapter.Update(userInter)
Return rowsAffected = 1
End Function
I have the following code in a stored procedure to retrieve all posts:
[Code]....
However, I am having trouble selecting posts by their tag..
how do i insert date and time together ? what is the format for this. i tried like this but its not working.
string startDtime = TextFromDate.Text + " " + Stime;
sql_comm.Parameters.AddWithValue("@StartDate",
DateTime.Parse(startDtime));
is this the right way ? dd/mm/yyy +" "+ 00:00
or i need to make a string that contain this : dd/mm/yyy00:00
its not writing any eror it just do nothing .
How can we insert a picture into an image field PictureBinary?
how to do it in C# and/or T-SQL.
How can I get the login username to be passed to a field in a gridview on edit or insert? Do I need to convert the gridview field to a template? I have been able to pass the login name to the database in a form by using "AddWithValue("UserId", Data.SqlDbType.VarChar).Value = User.Identity.Name" but I can't figure how to bind the login name to a template field.
InsertCommand="INSERT INTO [Address] (AssocId, [AddrType], [PreAddr1], [PreAddr2], [Address1], [Address2], [City], [State], [Zip], [Country], [PreferredAddr], [ActiveStatus], [EditDate], [Editor]) VALUES (@AssocId, @AddrType, @PreAddr1, @PreAddr2, @Address1, @Address2, @City, @State, @Zip, @Country, @PreferredAddr, @ActiveStatus, GETDATE(), @Editor)"
[code]...
My database includes a table with sever filds which are defined as (varchar(1),null), I tried using DBNull.Value, null, ' ' but cannot get a null inserted in that field of the database,
[Code]....
i wants to insert below all the data in a sql table called studentbackup in a single field called descfield and retrive the information
through parsing.
<?xml version="1.0" encoding="ISO-8859-1"?><studentbkup>
<studMstrDetails version = "0">
<row>
<studId>101</studId>
<studNo>Mar-10-1</studNo>
<enrolldate>20100322</enrolldate>
<title>1</title>
<initial>A</initial>
<firstName>Joseph</firstName>
<lastName>Ambrose</lastName>
<sex>1</sex>
<dob>19000101</dob>
<qualification>BE</qualification>
<college>JJ</college>
<courseId>101</courseId>