Search results for query: *

I have a db grid and I can populate it via the data source property but i want to maunually scroll through the recordset and fill in each columns of the grid. Does anybody have the code for a dbgrid. I found a lot of code for a flexgrid but the properties do not match. Please help me out...

Hi I am trying to loop through a grid to get column 0 value and somehow i am getting only the first column value grid.movefirst for i = 0 to grid.rows - 1 inumber = grid.columns(0).text next i grid.movenext Thanks

I am new to database and i was using stored procedures when somebody suggested using a view instead of a stored procedure? Anybody care to explain what a view is and what is the difference between that and a stored procedure Thanks

Hi, I have a grid which is populated through a recordset via ado. The user wants to print all the records as it is on the screen. Since my grid has to be scrolled to the right to view all the column capturing the picture of the grid is not helping me. I can print the grid as it is even...

I have to print the entire contents of a dbgrid what i have done is created a new form with a grid populated on it and when the user presses a button, i load the form and print it eg when the cmdPrint is clicked load(frmGrid) frmgrid.printform end sub but this is not working any ideas

Hi again, Thanks for all the replies. Tim said to call a stored procedure using the exec which works fine as far as compiling is concerned but i am still not getting the results i want this is what i need name type desc aaa 0 aaa bb 1 bbb cc...

Can you call one stored procedure within another and if so what is the syntax for calling it. Thanks Samantha

I populated a dbgrid via a stored procedure. my grid looks like this name type desc aaa 0 ddddddddd bbb 1 eeeeeee i want to loop through this grid and replace the type column if 0 then form and if 1 then Memo I am unable to do this as i keep getting errors such as...

I have a sheridan grid where the user enters information and this has to be saved via a stored procedure. Since the user can enter several rows of information, the grid has to be looped to save information. What I need to know is do I just have to loop through the grid and append each...

I have two grids one is dbgrid and the other is a sheridan grid I have to send data from the dbgrid to the sheridan grid on the double click event vNum = dbgKits.Bookmark sKitNumber = dbgKits.Columns(0).Text If...

Hi, I need columns to be displayed like this Kit ID Type Desc 12 Form jddd 13 Kit fff CREATE PROCEDURE dbo.DisplayKits_Forms_pr (@language int) AS BEGIN if @language = 1 select kit_id as 'Kit ID', form_ind as Type, english_desc...

hi, i have a list box which contains a max of 7 strings. I need to loop through this list box and store these strings in an array. Please help. Thanks Samantha

I have a list box in visual basic which will contain a max of 7 strings. I need to save this data so i am thinking about looping through the list box and saving these strings in an array but i am not sure if i can append the string array as a parameter and send it to the stored procedure...

Hi I am trying to send the stored procedure 2 parameters as inputs. one is language and the second is the country id and i would like to get the description back as an output but this is not working. Please help CREATE PROCEDURE dbo.DisplayCountry_pr @language int, @countryid int...