Click here to Skip to main content
15,921,941 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Questionmemory usage is too high? Pin
jamilkhan00728-Aug-07 20:46
jamilkhan00728-Aug-07 20:46 
AnswerRe: memory usage is too high? Pin
Christian Graus28-Aug-07 20:48
protectorChristian Graus28-Aug-07 20:48 
QuestionFolder that have write access to all users? Pin
jamilkhan00728-Aug-07 20:39
jamilkhan00728-Aug-07 20:39 
AnswerRe: Folder that have write access to all users? Pin
Vasudevan Deepak Kumar29-Aug-07 3:26
Vasudevan Deepak Kumar29-Aug-07 3:26 
AnswerRe: Folder that have write access to all users? Pin
Dave Kreskowiak29-Aug-07 4:30
mveDave Kreskowiak29-Aug-07 4:30 
AnswerRe: Folder that have write access to all users? Pin
jamilkhan00729-Aug-07 20:15
jamilkhan00729-Aug-07 20:15 
GeneralRe: Folder that have write access to all users? Pin
Dave Kreskowiak30-Aug-07 5:00
mveDave Kreskowiak30-Aug-07 5:00 
QuestionWhat is wrong with oledb code Pin
Vimalsoft(Pty) Ltd28-Aug-07 20:22
professionalVimalsoft(Pty) Ltd28-Aug-07 20:22 
hi All again i managed to solve my previous adapter. as Acces does not support substring function, i used Mid instead. so now i have problem in my search button. and the Problem is Poiting to the following line.
damixed.SelectCommand.Parameters("Boundary_Area").Value = cmbboundary.Text
damixed.SelectCommand.Parameters("Lis_key").Value = txterf.Text

i used "mid" function to Extract the value to is needed to be searched. like this
SELECT Boundary_Area, Compl_Boundary_Area, Extension, Current_Values, Improvements_Value, Improved_Value, First_Prop_Address, Lis_key, Num_key, Own_Name, Parcel_No, Parcel_Portion_No, Primary_ID, Prop_Address, Purchase_Date, Site_Value, Street_Name, Street_No, Actual_Extent, Title_Deed_No, Values_Effective FROM Property_ValRoll WHERE (Boundary_Area = ?) AND (MID(Lis_key, 5, 5) = ?)

When i run project code, it tell me that
An OleDBParameter with Parametername 'Lis_key' is not contained by this oledbParameterCollection.


As you can see am connecting to Acces database,i had a same project that is successfully but DB as SQL, so the code will differ in the adapter and in the parameter. So please tell me if its the correct way to get input from a user's textbox and combobox this way? and what is wrong with my code.

Thank you

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding

AnswerRe: What is wrong with oledb code Pin
Dave Kreskowiak29-Aug-07 4:42
mveDave Kreskowiak29-Aug-07 4:42 
GeneralRe: What is wrong with oledb code Pin
Vimalsoft(Pty) Ltd29-Aug-07 21:54
professionalVimalsoft(Pty) Ltd29-Aug-07 21:54 
QuestionUsing ADO.net from VB.net Pin
Wlink28-Aug-07 20:19
Wlink28-Aug-07 20:19 
AnswerRe: Using ADO.net from VB.net Pin
Vimalsoft(Pty) Ltd28-Aug-07 20:40
professionalVimalsoft(Pty) Ltd28-Aug-07 20:40 
QuestionHow to create crystal report with a query Pin
RichardBlare28-Aug-07 20:04
RichardBlare28-Aug-07 20:04 
QuestionDrawing a Gauge Pin
ejaz_pk28-Aug-07 19:47
ejaz_pk28-Aug-07 19:47 
AnswerRe: Drawing a Gauge Pin
Dave Kreskowiak29-Aug-07 4:10
mveDave Kreskowiak29-Aug-07 4:10 
QuestionProblem in Problem in Mobile Incoming call detected(Dave Kreskowiak) Pin
Nimesh U28-Aug-07 19:18
Nimesh U28-Aug-07 19:18 
AnswerRe: Problem in Problem in Mobile Incoming call detected(Dave Kreskowiak) Pin
Rupesh Kumar Swami28-Aug-07 21:36
Rupesh Kumar Swami28-Aug-07 21:36 
AnswerRe: Problem in Problem in Mobile Incoming call detected(Dave Kreskowiak) Pin
Vasudevan Deepak Kumar29-Aug-07 3:23
Vasudevan Deepak Kumar29-Aug-07 3:23 
AnswerRe: Problem in Problem in Mobile Incoming call detected(Dave Kreskowiak) Pin
Dave Kreskowiak29-Aug-07 4:07
mveDave Kreskowiak29-Aug-07 4:07 
Questionhow to load and unload dll or plugin Pin
rattlesnake31628-Aug-07 15:27
rattlesnake31628-Aug-07 15:27 
AnswerRe: how to load and unload dll or plugin Pin
Dave Kreskowiak28-Aug-07 17:25
mveDave Kreskowiak28-Aug-07 17:25 
GeneralRe: how to load and unload dll or plugin Pin
rattlesnake3162-Sep-07 17:22
rattlesnake3162-Sep-07 17:22 
GeneralRe: how to load and unload dll or plugin Pin
Dave Kreskowiak3-Sep-07 4:33
mveDave Kreskowiak3-Sep-07 4:33 
AnswerRe: how to load and unload dll or plugin Pin
originSH28-Aug-07 23:36
originSH28-Aug-07 23:36 
QuestionVisual Studio 2008 [modified] Pin
ASPnoob28-Aug-07 14:37
ASPnoob28-Aug-07 14:37 

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.