Click here to Skip to main content
15,911,142 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionFacing Problem in Menu Control of ASP.NET 2.0 Pin
Ambrish Kr. Gupta22-Mar-07 0:58
Ambrish Kr. Gupta22-Mar-07 0:58 
AnswerRe: Facing Problem in Menu Control of ASP.NET 2.0 Pin
Sylvester george22-Mar-07 1:17
Sylvester george22-Mar-07 1:17 
Questiondate format Pin
Sebastian T Xavier22-Mar-07 0:56
Sebastian T Xavier22-Mar-07 0:56 
AnswerRe: date format Pin
Guffa22-Mar-07 2:33
Guffa22-Mar-07 2:33 
GeneralRe: date format Pin
Sebastian T Xavier22-Mar-07 5:23
Sebastian T Xavier22-Mar-07 5:23 
QuestionImages in a Database Pin
Icarus12322-Mar-07 0:22
Icarus12322-Mar-07 0:22 
AnswerRe: Images in a Database Pin
Colin Angus Mackay22-Mar-07 0:37
Colin Angus Mackay22-Mar-07 0:37 
QuestionSave captured information in the table Pin
Oga M22-Mar-07 0:19
Oga M22-Mar-07 0:19 
Please help me.I have declared my variables
***************************
Public Sub addTimesheet(ByVal IdNumber As String, ByVal ProjectName As String, ByVal ProjectMember As String, ByVal ClientSite As String, ByVal ProjectManager As String, ByVal Occupation As String, ByVal WeekNumber As Integer, ByVal Day As String, ByVal Hour As Integer, ByVal Description As String)
Dim Sql As String
Dim obj As Datalayer.Database = New Datalayer.Database
Sql = "insert into TimeSheet (Id_Number,Project_Member,Project_Name,Project_Manager,Hour,Day,Description,Client_Site,Occupation,Week_Number)" & _
" Values('" & IdNumber & "','" & ProjectName & "','" & ProjectMember & "','" & ClientSite & "','" & ProjectManager & "','" & Occupation & "', '" & WeekNumber & "','" & Day & "','" & Hour & "','" & Description & "')"
obj.Execute(Sql)
'addTimesheet = obj.GetDataset(Sql)
'obj.Close()
'Exit Sub
*******************************
Gives me this error
Conversion failed when converting the varchar value 'Select Project Manager' to data type int.(Pointing this query statement) lngRecords = cmdQuery.ExecuteNonQuery()
End Sub

******************
In my AddEntryButton

Dim Obj As Businesslayer.TimeSheet = New Businesslayer.TimeSheet

Obj.addTimesheet(txtIDNo.Text, cmbProjectName.SelectedItem.Text, cmbProjectMember.SelectedItem.Text, cmbClientSite.SelectedItem.Text, cmbProjectManager.SelectedItem.Text, cmbOccupation.SelectedItem.Text, txtWeekNo.Text, cmbDays.SelectedItem.Text, txtHours.Text, txtDescription.Text)
*******************
What might be the Problem(explain it to me please)


oga m
AnswerRe: Save captured information in the table Pin
Oga M22-Mar-07 1:56
Oga M22-Mar-07 1:56 
QuestionDatagrid_ItemCommand problem Pin
Rajiya22-Mar-07 0:09
Rajiya22-Mar-07 0:09 
AnswerRe: Datagrid_ItemCommand problem Pin
varshavmane22-Mar-07 0:34
varshavmane22-Mar-07 0:34 
GeneralRe: Datagrid_ItemCommand problem Pin
Rajiya22-Mar-07 1:07
Rajiya22-Mar-07 1:07 
GeneralRe: Datagrid_ItemCommand problem Pin
_AK_22-Mar-07 1:19
_AK_22-Mar-07 1:19 
GeneralRe: Datagrid_ItemCommand problem Pin
vengaqua22-Mar-07 22:32
vengaqua22-Mar-07 22:32 
GeneralRe: Datagrid_ItemCommand problem Pin
vengaqua27-Mar-07 20:23
vengaqua27-Mar-07 20:23 
QuestionControl events Pin
vengaqua22-Mar-07 0:05
vengaqua22-Mar-07 0:05 
AnswerRe: Control events Pin
_AK_22-Mar-07 1:23
_AK_22-Mar-07 1:23 
QuestionUnmanaged DLLs with ASP.NET Pin
karanba21-Mar-07 23:22
karanba21-Mar-07 23:22 
QuestionEncrpyt and Decrypt Pin
varshavmane21-Mar-07 23:17
varshavmane21-Mar-07 23:17 
AnswerRe: Encrpyt and Decrypt Pin
Paddy Boyd22-Mar-07 0:04
Paddy Boyd22-Mar-07 0:04 
GeneralRe: Encrpyt and Decrypt Pin
varshavmane22-Mar-07 0:28
varshavmane22-Mar-07 0:28 
GeneralRe: Encrpyt and Decrypt Pin
Paddy Boyd22-Mar-07 0:30
Paddy Boyd22-Mar-07 0:30 
GeneralRe: Encrpyt and Decrypt Pin
varshavmane22-Mar-07 0:36
varshavmane22-Mar-07 0:36 
GeneralRe: Encrpyt and Decrypt Pin
Paddy Boyd22-Mar-07 0:39
Paddy Boyd22-Mar-07 0:39 
QuestionWSDL Pin
chat_sp2001@yahoo.com21-Mar-07 23:10
chat_sp2001@yahoo.com21-Mar-07 23:10 

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.