Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.
Course Of The Month
7 days, 16 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
To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…
- Microsoft Applications
- Windows 10
- Windows OS
- Fonts Typography
- Windows 7, Microsoft Word
Suggested Courses
Course of the Month7 days, 16 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
729 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.