In the era of the cloud, customers migrating away from their existing on-premise infrastructure. This requires lots of planning, strategies, and effort to identify their existing resources and determine how best to migrate. Datacenter migrations happen in four phases -
COURSE of the MONTH
13 days, 4 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
vb.net dataset replace "T"
Posted on 2011-03-01
Hi I have a problem.
I read data from a SQL database.. in this database I have some values..
like
date, time, batchnumber, quantiy, comment
and before the batchnumber could contain a Letter. The letter T then the batchnumber.
ex. T123456
No this T is not in used longer but I can´t delete the old data that contains T.
So I wounder can I in some simple way replace the T in my dataadpater before I filll my dataset?
Plese look at my code below.
'Create SQLQuery
sqlquery = "SELECT * FROM TEST WHERE Batch_nr =" & "" & comment & ""
' Create a DataAdapter
da = New SqlDataAdapter(sqlquery, MyConnection)
Try
' Fill the DataAdapter
da.Fill(ds)
Catch ex As Exception
MessageBox.Show( ex.Message )
End Try
so I woul dlike to replace the T or remove it just before I do the
da.Fill(ds)
tips help..
I read my data in a .net application and get the data from a MSSQL 2008 database...
I read data from a SQL database.. in this database I have some values..
like
date, time, batchnumber, quantiy, comment
and before the batchnumber could contain a Letter. The letter T then the batchnumber.
ex. T123456
No this T is not in used longer but I can´t delete the old data that contains T.
So I wounder can I in some simple way replace the T in my dataadpater before I filll my dataset?
Plese look at my code below.
'Create SQLQuery
sqlquery = "SELECT * FROM TEST WHERE Batch_nr =" & "" & comment & ""
' Create a DataAdapter
da = New SqlDataAdapter(sqlquery, MyConnection)
Try
' Fill the DataAdapter
da.Fill(ds)
Catch ex As Exception
MessageBox.Show( ex.Message )
End Try
so I woul dlike to replace the T or remove it just before I do the
da.Fill(ds)
tips help..
I read my data in a .net application and get the data from a MSSQL 2008 database...
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
6
-
5
11 Comments
I don´t think I would like to do something in the query because I still need the data from the T123456 but I don´t want to save it in the dataset whit T123456 I would like to replace it or remove it...
change query like this
sqlquery = "SELECT ate, time, REPLACE(batchnumber,'T',''
, quantiy, comment FROM TEST WHERE Batch_nr =" & "" & comment & ""
sqlquery = "SELECT ate, time, REPLACE(batchnumber,'T',''
, quantiy, comment FROM TEST WHERE Batch_nr =" & "" & comment & ""
hmm...
pratima_mcs:
If I do in this way do I get the data from the lines that contains the T123456
or will I don´t get that data?
and I can´g understand your line... should it be ate or is it a misspell? Pleas check my line I have..
sqlquery = "SELECT * FROM Test WHERE Batch_nr =" & "" & comment & ""
Should it really be lite this then?
sqlquery = "SELECT ate, time, REPLACE(batchnumber,'T',''
pratima_mcs:
If I do in this way do I get the data from the lines that contains the T123456
or will I don´t get that data?
and I can´g understand your line... should it be ate or is it a misspell? Pleas check my line I have..
sqlquery = "SELECT * FROM Test WHERE Batch_nr =" & "" & comment & ""
Should it really be lite this then?
sqlquery = "SELECT ate, time, REPLACE(batchnumber,'T',''
try this no ;
sqlquery = "SELECT ate, time, REPLACE(batchnumber,'T',''
It will give you your result
sqlquery = "SELECT ate, time, REPLACE(batchnumber,'T',''
It will give you your result
OK I try to explain..
I have try to run my querys in management for MSSQL 2008
this is my query i run in the management
select Comments from TEST where Batch_nr= '32517290'
Msg 245, Level 16, State 1, Line 5
Conversion failed when converting the nvarchar value 'T12345678' to data type int.
thats the error so this would I like to remove the T in my query but I still want the T123456 data ... I hope you understand..
I have try to run my querys in management for MSSQL 2008
this is my query i run in the management
select Comments from TEST where Batch_nr= '32517290'
Msg 245, Level 16, State 1, Line 5
Conversion failed when converting the nvarchar value 'T12345678' to data type int.
thats the error so this would I like to remove the T in my query but I still want the T123456 data ... I hope you understand..
I losing it soon..
tested this
select REPLACE(Batch_nr,'T','') Kommentar from TEST where Batch_nr = '32517200'
then I get a column in return called Kommentar and then the value
32517200
tested this
select REPLACE(Batch_nr,'T','') Kommentar from TEST where Batch_nr = '32517200'
then I get a column in return called Kommentar and then the value
32517200
select Comments from TEST where Batch_nr= CAST(REPLACE('T12345678','
try like this
sqlquery = "SELECT * FROM TEST WHERE Batch_nr =" & CAST(REPLACE(comment,'T','
try like this
sqlquery = "SELECT * FROM TEST WHERE Batch_nr =" & CAST(REPLACE(comment,'T','
SELECT * FROM Test WHERE Batch_nr = CAST(REPLACE(3251710,'T','
Still give me error
Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the nvarchar value 'T12345678' to data type int.
Thank you for try to help me.. can´t understand that I never can learn how to do when I get this big problems :(
Still give me error
Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the nvarchar value 'T12345678' to data type int.
Thank you for try to help me.. can´t understand that I never can learn how to do when I get this big problems :(
Ok tell me what are the datatypes for Batch_nr and comment ? is it varchar both or int ??
If both varchar
sqlquery = "SELECT * FROM TEST WHERE CAST(REPLACE(Batch_nr,'T',
if Batch_nr varchar , comment int then
sqlquery = "SELECT * FROM TEST WHERE CAST(REPLACE(Batch_nr,'T',
hope this helps
If both varchar
sqlquery = "SELECT * FROM TEST WHERE CAST(REPLACE(Batch_nr,'T',
if Batch_nr varchar , comment int then
sqlquery = "SELECT * FROM TEST WHERE CAST(REPLACE(Batch_nr,'T',
hope this helps
Featured Post
Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses
Course of the Month13 days, 4 hours left to enroll
777 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.