All Questions
330 questions
-2
votes
1
answer
42
views
vb.net display current week database records
I found some other reference here in internet and tried this code so far, but seems not to work. Can someone help rearrange or modify my code for displaying record current week.
Sub loadCheck()
da ...
- 27
0
votes
1
answer
54
views
VB.NET Webforms application: Sharing global variables between code and SQL
I'm working on some old webforms applications. We have some clients and we currently store some of the info in a global variables class like the next:
Public Class globals
Enum Enterprise
...
- 2,802
0
votes
1
answer
550
views
How do I write data from access tables to excel
I am looping through a table called _TF_Tables which contains the names of all tables within the database for which an Excel workbook needs to be created and filled with data from that table.
The ...
- 822
1
vote
0
answers
3k
views
Fractional second precision exceeds the scale specified in the parameter binding
When trying to move data of one table from SQL Server 2019 to SQL Server 2012 using a stored procedure with the help of linked server, I' getting this error:
The OLE DB provider "MSDASQL" ...
-1
votes
1
answer
887
views
vb.net set properties of columns of gridview dynamically
Hello StackOverFlow Family
I have a table in my database that contains all columns of all grid views that already have been created on vb.net application form as below.
Using this table, I want to ...
- 13
0
votes
1
answer
149
views
How make code for multiple search at the time in vb.net, SQL Server
For the last three months, I worked on code creating a single searching code in vb.net but I need help to make multiple search at the time like for ex:- I search in database using vb.net is done but ...
- 3
0
votes
1
answer
278
views
Data source is an invalid type in VB.net
I am querying the database to fill the Datagrid. I dont want everything in the database to be displayed on the table just some important information.
I am new to VB.net I am used to asp.net core MVC ...
- 1,477
0
votes
0
answers
96
views
issue with HTTP vs HTTPS on soap service via SQL server
I have a SOAP service hosted on a web server (2012 R2). This SOAP service was getting called by a SQL server and everything worked fine.
I moved this SOAP service to a different web server (2016). Now ...
- 21
0
votes
0
answers
144
views
How to cast UTF-8 xml to SQL Xml?
I get XML encoded as UTF-8 in Base64 String.
First i decode from Base64 to byte then i use System.Text.UTF8Encoding.UTF8.GetString(XMLDoc) to get xml as string.
All is ok but then i must use this xml ...
- 125
0
votes
1
answer
224
views
Get SQL instance return error in SQL Server Express
I have this function to fill a combobox, it is working in SQL Server but not working in SQL Server Express where it returns an error:
Conversion from type "DBNUll" to type 'String' is not ...
0
votes
1
answer
150
views
Scalar Function SQL By Linq Vb.net
I have a Function in Sql For check if username and password is Correct return 1 or 0
CREATE Function [dbo].[checklogin](@user varchar(30),@pass varchar(30))
Returns BIT
AS
BEGIN
DECLARE @check ...
0
votes
1
answer
1k
views
display query results in data grid view [closed]
How to populate the results of my below query in my datagrid box
- 426
0
votes
1
answer
142
views
How to Change database name in Linq Vb.net
I have a database Linq dbml
I need to change the database name before creating
Dim dt As New DataSchool()
dt.Connection.Open()
dt.CreateDatabase()
1
vote
1
answer
710
views
Error "CREATE FILE encountered operating system error 123" linq vb.net
I have a database with the link "dtschool.dbml" and I want to create this database in SQL Server
When running this code
Dim dt As New SchoolData.linqSchoolsDataContext
Dim sd As New ...
1
vote
0
answers
179
views
How do I insert millions of records with speed and at once into an sql table using vb.net?
I have am filling gridview with data and insert record 1 by 1 into an sql table using a stored procedure which has only insert statement.
This is ok but when records are in millions then this takes ...
- 29