Click here to Skip to main content
15,922,650 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: How to format alpha-numeric strings? Pin
Jon_Boy28-Aug-08 8:09
Jon_Boy28-Aug-08 8:09 
QuestionNo one can kill Windows service process Pin
nitin_ion28-Aug-08 1:54
nitin_ion28-Aug-08 1:54 
AnswerRe: No one can kill Windows service process Pin
jzonthemtn28-Aug-08 3:49
jzonthemtn28-Aug-08 3:49 
AnswerRe: No one can kill Windows service process [modified] Pin
Chinners28-Aug-08 4:26
Chinners28-Aug-08 4:26 
GeneralRe: No one can kill Windows service process Pin
nitin_ion1-Sep-08 18:08
nitin_ion1-Sep-08 18:08 
Questiondisplay data into datagrid Pin
anirai27-Aug-08 20:59
anirai27-Aug-08 20:59 
AnswerRe: display data into datagrid Pin
Vimalsoft(Pty) Ltd27-Aug-08 23:09
professionalVimalsoft(Pty) Ltd27-Aug-08 23:09 
Questionproblem while trying to insert number of rows into the database using dataset and tablemapping Pin
kisran27-Aug-08 19:56
kisran27-Aug-08 19:56 
hello frends .......

m facing problem while trying to insert values into the database using dataset and tablemapping...... getting error no coloumn at index 0


Dim ds As New DataSet 
ds.Tables.Add("DATA") 
Dim dr As System.Data.DataRow 
Dim k As Integer 
' For i = 1 To 90 
Dim m As Integer 
' m = i 
m = 1 
k = 0 
' Dim t As TextBox = Panel2.FindControl("Text" & i.ToString()) 
' If t.Visible = True Then 
dr = ds.Tables("DATA").NewRow() 
dr(k) = Session("proj") 
k = k + 1 
dr(k) = Session("vol_name") 
k = k + 1 
dr(k) = Session("brd") 
k = k + 1 
For j = 1 To 9 
If j = 4 Then 
Dim d1 As DropDownList = Panel2.FindControl("Text" & m.ToString()) 
m = m + 1 
dr(k) = d1.SelectedValue 
k = k + 1 
Else 
Dim t1 As TextBox = Panel2.FindControl("Text" & m.ToString()) 
m = m + 1 
If t1.Text.Trim() = "" Then 
dr(k) = OracleString.Null 
k = k + 1 
Else 
dr(k) = t1.Text.Trim() 
k = k + 1 
End If 
End If 
Next 
ds.Tables("DATA").Rows.Add(dr) 
' Else 
' Exit For 
' End If 
' i = i + 8 
' Next 
'******************************* 
Dim cn As OracleConnection 
cn = New OracleConnection("user id=lntforms;data source=;password=user123") 
cn.Open() 
Dim sq1 As String 
sq1 = "SELECT * FROM CMS_LOADLIST" 
Dim oraDa As OracleDataAdapter 
oraDa = New OracleDataAdapter(sq1, cn) 
oraDa.TableMappings.Add("Load_list", "DATA") 
oraDa.Fill(ds, "CMS_LOADLIST") 
'Label5.Text = ds.Tables("DATA").Columns.Count.ToString() 
Dim cb As OracleCommandBuilder 
oraDa.SelectCommand = New OracleCommand(sq1, cn) 
cb = New OracleCommandBuilder(oraDa) 
Try 
oraDa.Update(ds, "DATA") 
ds.AcceptChanges() 
'Session.Add("ds", this.ds) 
Catch ex As System.Exception 
'err = 1 
ds.RejectChanges() 
'Session.Add("ds", this.ds) 
If ex.Message.StartsWith("ORA-00001") Then 
Label5.BackColor = Color.Red 
Label5.Text = "All project entries must be unique." 
Else 
Label5.BackColor = Color.Red 
Label5.Text = ex.Message() 
End If 
End Try 



please help me out....

kisran

Questionvb.net datagrid cell merging Pin
mmel_g27-Aug-08 19:51
mmel_g27-Aug-08 19:51 
AnswerRe: vb.net datagrid cell merging Pin
Ashfield27-Aug-08 21:15
Ashfield27-Aug-08 21:15 
GeneralRe: vb.net datagrid cell merging Pin
mmel_g29-Aug-08 16:03
mmel_g29-Aug-08 16:03 
QuestionHow to suppress javascript error while using WebClient Pin
MAP Tiger27-Aug-08 14:00
MAP Tiger27-Aug-08 14:00 
AnswerRe: How to suppress javascript error while using WebClient Pin
N a v a n e e t h27-Aug-08 19:47
N a v a n e e t h27-Aug-08 19:47 
GeneralRe: How to suppress javascript error while using WebClient Pin
MAP Tiger27-Aug-08 22:37
MAP Tiger27-Aug-08 22:37 
AnswerRe: How to suppress javascript error while using WebClient Pin
MAP Tiger28-Aug-08 0:02
MAP Tiger28-Aug-08 0:02 
GeneralRe: How to suppress javascript error while using WebClient Pin
dennisa29-Sep-09 13:32
dennisa29-Sep-09 13:32 
Questionvb.net and SQL server 2005 Pin
Rafone27-Aug-08 11:59
Rafone27-Aug-08 11:59 
AnswerRe: vb.net and SQL server 2005 Pin
Polymorpher27-Aug-08 14:16
Polymorpher27-Aug-08 14:16 
AnswerRe: vb.net and SQL server 2005 Pin
Ashfield27-Aug-08 21:24
Ashfield27-Aug-08 21:24 
GeneralRe: vb.net and SQL server 2005 Pin
Rafone28-Aug-08 3:11
Rafone28-Aug-08 3:11 
GeneralRe: vb.net and SQL server 2005 Pin
Jon_Boy28-Aug-08 4:23
Jon_Boy28-Aug-08 4:23 
GeneralRe: vb.net and SQL server 2005 Pin
Rafone28-Aug-08 5:10
Rafone28-Aug-08 5:10 
QuestionCrystal Reports and Images Pin
Cory Kimble27-Aug-08 8:54
Cory Kimble27-Aug-08 8:54 
AnswerRe: Crystal Reports and Images Pin
codemunch27-Aug-08 9:25
codemunch27-Aug-08 9:25 
AnswerRe: Crystal Reports and Images Pin
ScottBrady27-Aug-08 10:51
ScottBrady27-Aug-08 10:51 

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.