All Questions
Tagged with sql-server-2005 vb.net
230
questions
0
votes
0
answers
69
views
Load Image VB.NET from SQL Server 2005 type Image
I have problem with load image in VB.NET 2005 from SQL SERVER 2005 type image.
SQL table "pegawai"
code varchar(15)
foto image
VB Code:
Sub SendQueryParam(ByVal ssql As String, ByVal ParamArray ...
0
votes
2
answers
610
views
App.config file and .edmx file missing. And how to undo Views imported in Entity Data Model wizard?
Can anyone help me please? Right now i'm connecting my web API project to an existing database. Someone suggested to use EntityFramework for that. I'm applying code first approach in the "Entity Data ...
1
vote
1
answer
1k
views
VB.net how to create table using xml and displaying the table on the webpage
Can somebody please help me to amend this code because i tried running but the table didnt appear on the page. I'm new to XML and somebody gave me this snippet saying that XML coding is more reliable ...
-1
votes
2
answers
4k
views
How to get count in output variable using a stored procedure?
SELECT COUNT(*)
FROM tblRequest
GROUP BY RequestStatusID
This query return the column having total requests respective status Id.
I want to get total requests count respective to its statusId in ...
1
vote
0
answers
109
views
Calculating sum with uneven rows from multiple table
I tried This with adding 2 data tables in vb.net but it fails when group has 3rd level child (for e.g. if added 12, regular fees,5 in group table) please tell me how i can i query database when child ...
0
votes
1
answer
2k
views
SQL CommandTimeout not working?
I set the CommandTimeout property of my SqlCommand to 3 but it's still taking at least 10 seconds for it to throw an exception.
cmd = New SqlCommand("query", con)
cmd.CommandTimeout = 3
cmd....
2
votes
1
answer
1k
views
What transaction isolation level should I use
I am working on a custom application that allows users to insert / update / delete / retrieve data from a database.
Stored procedures I use affects a few tables so I use a transaction and I want to ...
0
votes
1
answer
27
views
Displaying a message when something is inserted into a table
In my application I want a message to be displayed when something new is inserted into my table, what's the best way of doing this? the only thing I can think of right now is having a timer repeat a ...
2
votes
1
answer
1k
views
vb.net auto update datagridview when database change
I have an application where multiple users can connect to a database and datagridview need to be updated automatically when there has been a change in the database. Possible without timers?
0
votes
2
answers
766
views
Selecting from a column with Ampersand(&)
The data type of the column is nvarchar. I can insert to the column properly using parameters. I see the ampersand character in the column when I view the table in sql server management studio.
My ...
0
votes
0
answers
27
views
How is it possible to have changes in a database available at a later stage inside a local transaction?
I have a vb.net application that updates a record in table A and then inserts a record in the same table, inside a local transaction (in SQL Server 2005.)
_DbConnection.Open()
Try
_Transaction = ...
0
votes
0
answers
31
views
unable to get that data from sql to display in textbox what's wrong with the code?
I want to input a data from textbox1 (ex: NSB1000-PCP) and when I click textbox2 I want to display the corresponding value of PCP which is PENTAX.
I was unable to get that data from SQL to display in ...
0
votes
1
answer
35
views
ASP DataGrid - Must declare the scalar variable "@LCompanyIDInt" [closed]
I have an application I'm working on that have multiple grid views on panels, and those panels are selected by a dropdown list. The first one I'll put here works perfectly.
I have a second grid set ...
0
votes
2
answers
780
views
How to fix "ExecuteNonQuery:CommandText property has not been initialized?" error?
I am getting an error ,
"ExecuteNonQuery: CommandText property has not been initialized"
Please help !!! I have been executing this code to save data in my other forms with our any error but when ...
0
votes
2
answers
1k
views
String or binary data would be truncated. The statement has been terminated.?
here's my piece of code. when i execute i get an error as give below
If Val(dr("USE_Amount").ToString) >= Val(txtprice.Text) Then
dr.Close()
msg = "Ref No : ...