I have a stringvariabel in a form I shall insert in a SQL database in a integer field. I try to convert it in the parameterlist:
myComm.Parameters.Add("@UtstyrID",
SqlDbType.Int).Value =
Convert.ToInt32(e.Record["UtstyrID)"]);
but it only store the value 0 and not the value of the e.Record["UtstyrID)"])
I'm trying to add a parameter at the end of a url obtained from the database as follows:
This is giving error because of the ID value, which is an integer...how can I convert it to string here? I can do it in code behind, but I just want to know how it can be done within the Eval function...
NavigateUrl
='<%#Eval("Filepath") + "&ID="+DataBinder.Eval(Container.DataItem,"ID")%>'
How can I change the parameter value from Interger to String.
Here below is the part of the code that creates problem; the constant "sqlStatement" is as string, but when the parameters "@ProdColor" read the value it returns an integer instead of the proper type which is a string. I have tried every ting like: CType(sqlStatement(splitItems(1)), string)
Or convert or parse, but it keeps returning the wrong type.
Const sqlStatement As String = "INSERT INTO ProductDetails (ProdID,ProdColor,ProdSize) VALUES"
If item.Contains(",") Then
splitItems = item.Split(",".ToCharArray)
cmd.Parameters.AddWithValue("@ProdID", SqlDBType.Int).Value = sqlStatement(splitItems(0))
cmd.Parameters.AddWithValue("@ProdColor", SqlDBType.NVarchar).Value = sqlStatement(splitItems(1))
cmd.Parameters.AddWithValue("@ProdSize", SqlDBType.NVarchar).Value = sqlStatement(splitItems(2))
Using the following quires, for select and Update,. Select qry is working fine ,but update qry throws 'conversion failed when converting datetime from character string' .
select * from table1 where CreatedDt >= convert(datetime,'12/23/2009',101) and createdDt < dateadd(d,1,convert(datetime,'12/23/2009',101))
Update Table1 set status = 'y' where CreatedDt>= convert(datetime,'12/23/2009',101) and CreatedDt < dateadd(d,1,convert(datetime,'12/23/2009',101)
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[SP_ORDER_LIST]
@EmailId nvarchar(50)
AS
begin
declare @Id int
set @Id = (select SellerId from cart_seller_master where EmailId = @EmailId )
select
CTD.OrderId,CTD.Product_code,
CPM.product_name,CTD.Quantity,CTD.Orderdate,
case when convert(datetime,isnull(CTD.DispatchedDate,null)) is null then 'Not Dispatched'
end DispatchedDate ,
case when convert(datetime,isnull(CTD.DeliveryDate,null)) is null then 'Not Dispatched'
end DeliveryDate
from cart_Product_master as CPM
left outer join cart_Transaction_details as CTD on ctd.product_code=cpm.product_code
where CPM.SellerId = 1
group by CTD.OrderId,CTD.Product_code,
CPM.product_name,CTD.Quantity,CTD.Orderdate,
CTD.DispatchedDate,CTD.DeliveryDate
end
we are using transactional replication on an sql 2008 server. we try now to add a table to the replication that only consists of 1 culomn of type date and we insert the dates to the table. when we then create the replication we are getting an error on the creation of the snapshot. here is the create table with the insert dates:
USE [Product]
GO
/****** Object: Table [TimeSlices].[BaseDate] Script Date: 05/03/2010 15:52:24 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TimeSlices].[BaseDate]') AND type in (N'U'))
DROP TABLE [TimeSlices].[BaseDate]
GO
USE [Product]
GO
/****** Object: Table [TimeSlices].[BaseDate] Script Date: 05/03/2010 15:52:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [TimeSlices].[BaseDate](
[TargetDate] [date] NOT NULL,
CONSTRAINT [PK_BaseDate] PRIMARY KEY CLUSTERED
(
[TargetDate] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT INTO [TimeSlices].[BaseDate] SELECT TargetDate FROM [TimeSlices].UDF_GetTravelDateRange(GETDATE()-2 , GETDATE()+1000)
attached is the UDF:
[Code]....
this is the add article:
use [Product]
exec sp_addarticle @publication = N'Product$(QuoteNumber)', @article = N'BaseDate', @source_owner = N'TimeSlices', @source_object = N'BaseDate', @type = N'logbased', @description = null, @creation_script = null, @pre_creation_cmd = N'drop', @schema_option =
0x000000000803509F, @identityrangemanagementoption = N'manual', @destination_table = N'BaseDate', @destination_owner = N'TimeSlices', @vertical_partition = N'false', @ins_cmd = N'CALL sp_MSins_TimeSlicesBaseDate', @del_cmd = N'CALL sp_MSdel_TimeSlicesBaseDate',
@upd_cmd = N'SCALL sp_MSupd_TimeSlicesBaseDate'
GO
this is the error we get:
Message: Query for data failed
Stack: at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException(CConnection* pNativeConnectionWrapper)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint, String strWhereClause,
Boolean useTableLockHint, Int32 bcpFileFormatVersion)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.BcpOutThreadProvider.DoWork(WorkItem workItem)
at Microsoft.SqlServer.Replication.WorkerThread.NonExceptionBasedAgentThreadProc()
at Microsoft.SqlServer.Replication.AgentCore.BaseAgentThread.AgentThreadProcWrapper() (Source: MSSQLServer, Error number: 0)
Message: Conversion failed when converting date and/or time from character string.
Stack: (Source: MSSQLServer, Error number: 241)
why we are getting the conversion error on the snapshot creation?
I have the following code reading in my xml file and sorting it by ID:
Dim ds As New DataSet
ds.ReadXml(Server.MapPath("/posts.xml"))
Dim dv As New DataView(ds.Tables(0))
dv.Sort = "id desc"
The only problem is that it isn't sorting it numerically (it's sorting it alphabetically 1, 10, 11, 2, 24, 3, 4...). It appears as though I have to convert that column into integers, but I haven't been able to figure out an efficient way to do that.
im ds As New DataSet
ds.ReadXml(Server.MapPath("/App_Data/posts.xml"))
'ds.Tables(0).Columns(0).DataType = TypeOf(Decimal)
Dim dv As New DataView(ds.Tables(0))
'dv.Sort = "date"
Trying simple delete against a Photo table but hitting error as conversion type error.
[Code]....
Is there a better way to write this sql statement? or convert the UserId to int32 before executing? Not sure how to do that.
When I m trying with my code to insert a name like "Cédric" the field in the Database is empty.Here is my code for the insert function :
[Code]....
Here is the code that call this function :
[Code]....
I have a table with casenum as primary number and Identity column turned on. I know that the casenum will only auto-generated after a record is written into a table.
The front end to this table is a FormView on an AJAX webform.
Table is linked to the webform via LinqDataSource.
Now, on the webform, how can I display nextval before the record is actually written into a table?
Whenever I run the following code to insert a record into database:
protected void Button1_Click(object sender, EventArgs e)
I have this code and not sure what is wrong.
csconnection = New OleDbConnection (Stringconnection)
cscommand = new OleDbCommand("INSERT INTO Login ([Username], [Password], [Name], [DOB], [Gender], [Nationality]) VALUES (@Username, @Password, @Name, @Dob, @Gender, @Nationality);") [code]...
it just says errorat bottom of page and is there a way to tell the webpage to show me the error.
I have an SQL datasource that successfully enters customer details into a table. What it includes is the persons address. First of all we add the persons address, then we add the persons name to that address in a seperate physical procedure. i.e. on a different form.
What I need to do is try and stop users entering the same address twice. The way I have thought of doing this is by making a string field called AddressIdentity and have this contain the door number and the postcode of the address with all the spaces stripped out. Then when adding the address, it checks if this exists before adding it. However I cannot work out how to put the 2 fields together without using the codebehind file, which I don't mind doing if I need to, but I'm sure its avoidable.
Here is my code - I have only included the relevant parts:
InsertCommand="INSERT INTO [tbl_shop_client_addresses] ([FlatNo], [Address1], [Address2], [Town], [County], [Postcode],
[Country], [Telephone], [DoorNo]) VALUES (@FlatNo, @Address1, @Address2, @Town, @County, @Postcode, @Country, @Telephone, @DoorNo)"
<InsertParameters>[code]......
So how do I do it? I was trying:
InsertCommand="INSERT INTO [tbl_shop_client_addresses] ([FlatNo], [Address1], [Address2], [Town], [County], [Postcode],
[Country], [Telephone], [DoorNo], [AddressIdentity]) VALUES (@FlatNo, @Address1, @Address2, @Town, @County, @Postcode, @Country, @Telephone, @DoorNo, @Postcode + @DoorNo)"
but of course AddressIdentity is a string. Do I use ' ' marks with an & sign? Or can't I do this?? Maybe I need to use the codebehind anyway to see if the field exists before inserting it?
I creating a real Estate web application. I have a form where the admin can type price for a specific property. The price will be insert into the SQL database.
Which is the best SQl data type to store for example : £150.000 and then retrieve it from the database. It has to be any type of SQL data that store number as I have a search on the website that compare values of numbers. It cannot be for example varchar othewise I will get an error.
I have a textbox which the user writes a word into. They then press a button to add that word to a list which is stored in the database.
What is the code to do add their word to the database? Do I need code on the main aspx file or only on the code behind?
What I tried doing up until this point is that once the button is pressed, in the codebehind the following happens:
[Code]....
I get errors telling me that the column name Program is invalid (I have a table named Program with one column named ProgramName)
I looked at a bunch of tutorials but nothing is straight forward and simple, it keeps confusing me. I need the simple step by step instruction to do this. I'm using a SQL database and coding in VB
Im Inserting data into database table with the help of datasets but its not inserting to table and even its not showing errors.
this is my code....
[code]....
i am trying to display a pop up message box on inserting the data into the database. The code i am using is as follows..
[Code]....
The problem is even on inserting the data and the data getting inserted into the database, the pop up mwindow does not get displayed. On debugging, it shows the value of i as 0.
I have requirement that User can Upload the Excel Sheet Data to sql server Database at once.
View 16 RepliesCurrently using VS2008, VB.NET, SQL. I have a FormView from a Data Source that is getting some fields that are stored as Decimals in the SQL Database.
I am grabbing the field from the FormView as such:
Dim AvgTicketL As Label = CType(frmMerchantProfile.FindControl("F10Label"), Label)
I need to take this value, and convert it to an Integer, then send it along to an API. I have the API Calls done, tested and working, but I'm getting an error as when it is getting this value, the API is returning "Must be an Integer" error.
What I have tried so far:
Dim AvgTicketL As Label = CType(frmMerchantProfile.FindControl("F10Label"), Label)
Dim AvgTicket1 As Integer
AvgTicket1 = Double.Parse(AvgTicket.Text)
Do something with AvgTicket1
I have also attempted to Round the Value, then convert it and call it - no luck.
Checking the value of AvgTicket1 (Writing it out to a Label or Response.Write) shows "100", where the database value was 100.00. But the API is still getting 100.00, apparently. Any other conversion method that I've attempted states errors that the Label cannot be converted to Integer.
What are some methods I can successfully convert this value to an integer from a label?
I am being passed a date in this format DepartDate=40683, in vb.net however i cant figure out how to convert the integer into a regular date.
View 2 RepliesWhen I try to run the following code it always spits out the hex representation, not the integer representation. Most of the examples I found on MSDN said this should work. What am I missing?
var stringBuilder = new StringBuilder("8");
int j = 0;
foreach (char item in stringBuilder.ToString())
{
j = Convert.ToInt32(item); //returns 38, need return to be 56
}
edit I should have made clear that I know the difference it's returning the hex value. I'm outputting the value to a file, and in that file, it still shows the hex value, not the integer, so I don't think it has anything to do with the debugging environment. edit2 Looks like a PEBKAC problem. Looked at the code that was writing to the file, and it was using a .toString("X") method, changing it to a Hex value. The fact that it was hex in my debug environment was what confused me.
I have an integer field in my sql database and I have an xsd set up with all the CRUD operations. I need to put the value in a variable into the this integer field. Sometimes the value is 'nothing'. I have option strict on so there's no conversions going on by itself. If I hard code 'nothing' into the insert query, it works fine. Here's what happens otherwise:
1) If I put a variable into the query, when I assign 'nothing' to the variable, it becomes 0 so it puts a 0 into my database.
2) If I use an iif( ) statement, it also converts 'nothing' to 0
I don't seem to have any way to get a nothing in there if I don't specifically write 'nothing'.
int no = int.Parse(hidden_field.Value.TrimStart()); it cause the error: input format was not in correct format. how to fix it?
View 5 RepliesI am developing a C# VS 2008 / SQL Server 2005 Express website application. I have tried some of the fixes for this problem but my call stack differs from others. And these fixes did not fix my problem. What steps can I take to troubleshoot this?
System.Data.SqlClient.SqlException was caught
Message="Conversion failed when converting datetime from character string."
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060
LineNumber=10
Number=241
Procedure="AppendDataCT"
Server="\\.\pipe\772EF469-84F1-43\tsql\query"
State=1
StackTrace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ADONET_namespace.ADONET_methods.AppendDataCT(DataTable dt, Dictionary`2 dic) in c:Documents and SettingsAdminMy DocumentsVisual Studio 2008WebSitesJerryApp_CodeADONET methods.cs:line 102
And here is the related code. When I debugged this code, "dic" only looped through the 3 column names, but did not look into row values which are stored in "dt", the Data Table.
public static string AppendDataCT(DataTable dt, Dictionary<string, string> dic)
{
if (dic.Count != 3)
throw new ArgumentOutOfRangeException("dic can only have 3 parameters");
string connString = ConfigurationManager.ConnectionStrings["AW3_string"].ConnectionString;
string errorMsg;
try
{
using (SqlConnection conn2 = new SqlConnection(connString))
{
using (SqlCommand cmd = conn2.CreateCommand())
{
cmd.CommandText = "dbo.AppendDataCT";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn2;
foreach (string s in dic.Keys)
{
SqlParameter p = cmd.Parameters.AddWithValue(s, dic[s]);
p.SqlDbType = SqlDbType.VarChar;
}
conn2.Open();
cmd.ExecuteNonQuery();
conn2.Close();
errorMsg = "The Person.ContactType table was successfully updated!";
}
}
}
I am getting error while inserting date in sql database :
My SQL Table Structure isÂ
Column Name | DB TYPEID ---- INT -----Autogenerated -- PKey
Proj_StartDate ---- Date
In Application i have created a class for holding variable properties then linking this class to another class where my insert method is residing :
public class ProjectMaker {Â
public string Proj_StartDate { get; set; }
}
Now the Class in which i am linking above Class Property is :
 public class ProjectMaker_DB { public static void InsertRecord(ProjectMaker model) {
var cmd = new SqlCommand {
CommandType = CommandType.StoredProcedure,
CommandText = "[dbo].[sproc_INSERT_d_project_p]"
[Code] ....
That was my Class library project , Now here's my Coding for button click event in startup project :Â
protected void SubmitProject_OnServerClick(object sender, EventArgs e) {
if (SubmitProject.InnerHtml.Contains("Submit")) {
#region Submit Section
try {
var rec = new ABC_Library.ProjectMaker()
[Code] ....
I am getting start date from Ajax calendar extender toolkit's Selected Date .
After clicking Submit Button it gives me error : "Input string was not in a correct format" ...