Tagged Questions

1
vote
2answers
276 views

Saving text file in db and retrieving

I have to store a text file in the form of byte array and has to read it back from the database and need to write on text file. What can i Do? I am using sql server 2008 R2 and vb.net
0
votes
2answers
24 views

Delay in reading from specific database

I have an application written in VB.NET which reads data from an SQL Server 2008 R2. At the time of login, user select one of the many database files (available in a dropdown list) and then keys in ...
0
votes
1answer
47 views

Error in SQL query in Visual Studio 2012

I am trying my hand at writing something that can be used at work and am learning on my own. I've run into an issue that I cannot find a solution to, although it's very possible that I am just ...
0
votes
1answer
13 views

error occured while binding gridview in vb.net

i've met an error that " property access must assign to the property or use its value" while binding the gridview. here is my code. cn.Open() Dim str As String str = "select * from Customer where ...
0
votes
1answer
49 views

How to Insert Primary Value (PK) to Related Table (FK)

I'm having trouble from Inserting 1 Primary Value (Increment) of TABLE to another TABLE (Foreign Key) Table 1 has the Primary key of Student Number; if i enter values for last and first name from ...
0
votes
1answer
84 views

ms sql server 2008

i m creating a library management software using vb.net and ms sqlserver 2008 for the first time. and well i have following question---- 1-- do i have to create sql authentication or windows ...
0
votes
1answer
571 views

The new command text returns data with schema different from the schema of the main query. Check your query's command text if this is not desired

The new command text returns data with schema different from the schema of the main query. Check your query's command text if this is not desired. I am getings this warning, when ever i add a query ...
0
votes
1answer
526 views

A transport-level error has occurred when sending the request to the server

We have an in-house developed VB.Net Windows Forms application that is losing users' individual connections to the SQL Server 2008 R2 database. The bolded message below is what appears. A ...
2
votes
0answers
299 views

VB.NET application not using failover partner

I have a VB.NET app that connects to a SQL Server. We recently added database mirroring in case of a server failure. Well of course, our SQL Server failed but the VB.NET app is not failing over. I ...
0
votes
0answers
90 views

Pass arguments to a procedure dynamically in SQL Server

I have a dropdown list box control. It contain set of team name like AP,TN,CHK,DEL,TRY each team has some set of agents, the count of the agents are varied. When I choose AP it contain some list of ...
0
votes
0answers
132 views

Store images into SQL Server

I'm using SQL Server 2008 R2 and SQL Server Management Studio as my database. I need to upload a set of images to the server in order to display them upon certain triggers in my system. I know that ...
0
votes
0answers
222 views

Programmatically determine max size of SQL Server Express database

Is there a way to determine the max size of a SQL Server Express database using SMO? Or will I have to add code to say if express then if sql2005 then limit = 4gb else limit = 10gb ...
0
votes
0answers
105 views

windows does not connect to sqlserver r2 2008

My windows form application is developed on vb.NET using SQLSERVER R2 2008 Express as database.I installed sqlserver r2 on windows server 2008 of Client Location.There are about 8 systems on their ...
0
votes
0answers
348 views

Unable to retreive new datatable column

First, let me say I am a complete noob at this so I am really sorry if something does not sound right or if the answer is very basic. My issue is: I am trying to add two columns to my SQL database ...
0
votes
0answers
443 views

How to include my SQL Server 2008 R2 local database to my windows application on the time of deployment?

I have developed a windows application using SQL Server 2008 R2 Express as the database. I have made it in the deployment set up form by adding prerequisites (.net framework4, SQL Server Express, ...