Click here to Skip to main content
15,887,477 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: basic concepts Pin
Dave Kreskowiak15-May-07 3:56
mveDave Kreskowiak15-May-07 3:56 
QuestionUrgently required solution Pin
d_smit15-May-07 0:34
d_smit15-May-07 0:34 
AnswerRe: Urgently required solution Pin
Colin Angus Mackay15-May-07 0:51
Colin Angus Mackay15-May-07 0:51 
Answerurgent message titles Pin
leckey15-May-07 4:19
leckey15-May-07 4:19 
QuestionAbout Datagrid and xml data(urgent) Pin
Wlink14-May-07 23:08
Wlink14-May-07 23:08 
AnswerRe: About Datagrid and xml data(urgent) Pin
Ch_Shahzad iqbal15-May-07 23:28
Ch_Shahzad iqbal15-May-07 23:28 
GeneralRe: About Datagrid and xml data(urgent) Pin
Wlink16-May-07 2:27
Wlink16-May-07 2:27 
QuestionI added a column to a table, but, I can't see it. Pin
furjaw14-May-07 21:49
furjaw14-May-07 21:49 
I ran the code below that adds a column to an SQL table.
I refreshed Data Sources, but, the new column does not appear.
I refreshed Server Explorer and the new column does not appear.
I tried running the code again and I got:
"Column names in each table must be unique. Column name 'CaseNbr' in table 'Patient' is specified more than once."
so the column did actually get added, but, I can't see it.

Imports System.Data.SqlClient
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim sqlConnection As New System.Data.SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Patient.mdf;Integrated Security=True;User Instance=True")
Dim str As String = "ALTER TABLE Patient ADD CaseNbr Varchar(50)"
Dim command As New System.Data.SqlClient.SqlCommand(str, sqlConnection)
sqlConnection.Open()
command.ExecuteNonQuery()
sqlConnection.Close()
Close()
End Sub
End Class

AnswerRe: I added a column to a table, but, I can't see it. Pin
Ch_Shahzad iqbal14-May-07 22:05
Ch_Shahzad iqbal14-May-07 22:05 
AnswerRe: I added a column to a table, but, I can't see it. Pin
Dave Kreskowiak15-May-07 3:46
mveDave Kreskowiak15-May-07 3:46 
GeneralRe: I added a column to a table, but, I can't see it. Pin
furjaw16-May-07 9:31
furjaw16-May-07 9:31 
GeneralRe: I added a column to a table, but, I can't see it. Pin
Dave Kreskowiak16-May-07 13:31
mveDave Kreskowiak16-May-07 13:31 
GeneralRe: I added a column to a table, but, I can't see it. Pin
furjaw17-May-07 13:27
furjaw17-May-07 13:27 
GeneralRe: I added a column to a table, but, I can't see it. Pin
Dave Kreskowiak17-May-07 15:50
mveDave Kreskowiak17-May-07 15:50 
Questionisual Studio 2005 Connection to the Server Issue Pin
R. A. Abbasi14-May-07 21:37
R. A. Abbasi14-May-07 21:37 
AnswerRe: isual Studio 2005 Connection to the Server Issue Pin
Dave Kreskowiak15-May-07 3:51
mveDave Kreskowiak15-May-07 3:51 
GeneralRe: isual Studio 2005 Connection to the Server Issue Pin
R. A. Abbasi16-May-07 1:08
R. A. Abbasi16-May-07 1:08 
GeneralRe: isual Studio 2005 Connection to the Server Issue Pin
Dave Kreskowiak16-May-07 13:29
mveDave Kreskowiak16-May-07 13:29 
GeneralRe: isual Studio 2005 Connection to the Server Issue Pin
R. A. Abbasi16-May-07 19:51
R. A. Abbasi16-May-07 19:51 
QuestionOOPS or OOPs Pin
Navneet Hegde14-May-07 20:26
Navneet Hegde14-May-07 20:26 
AnswerRe: OOPS or OOPs Pin
Guffa14-May-07 20:52
Guffa14-May-07 20:52 
GeneralRe: OOPS or OOPs Pin
Christian Graus15-May-07 0:04
protectorChristian Graus15-May-07 0:04 
AnswerRepeat poster Pin
leckey15-May-07 4:22
leckey15-May-07 4:22 
Questionadding image Pin
cheerup_woe14-May-07 19:45
cheerup_woe14-May-07 19:45 
AnswerRe: adding image Pin
Christian Graus15-May-07 0:07
protectorChristian Graus15-May-07 0:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.