Search results for query: *

Is there a easy way in VS.2005 to export as dataset to MS Excel ?

Auguy, I'm not quite sure what it is you are doing, but if you have orders in a datagrid that is bound to a datset, you can add as manys rows as you like. Once you have added your order you could you a SQLDataAdapter and create the Update and Inserts methodes> SqlDataAdapter1.Update(yourDS...

Thank My example was a simple one just to illustrate my problem. I need to bring back a count of rows where the name is andrew and assign that value to a integer

How do i retreive a signle value use a sql statement in VBA I gace tried the following but it dosent work. Dim myString as string myString = db.execute "Select Name from Tbl_Users Where UserID = andrew"

Evansey, I think you need to look a little closer to home for the answer to this one, you could be going round the houses when the answer may be on your doorstep. Why are the cells shaded, conditional formatting perhaps? If so, do a Simple if statement using you conditional formating criteria...

I have a some strings some 9 charactors long and some 10 long. I need all my strings to be 12 didgets long, so I need to add "00" to the front of my 10 didget strings and "000" to my 9 didget string Is there any kind of format funtion to do this Thanks

All I have the following code to populate a reportviewer in Windows application, the reports (rdlc) are local to the application. I am unsure what needs to go where I have ?marks. My dataset is called OpsReportingDataSet.xsd and the table within it is called tbl_EWTCases. Dim varStart...

Thanks for the reply I forgot to add that the reports are not server based, they are held within the application.

I have a problem with the report viewer. I have a form showing a report viewer (RV), When the form loads it shows the report the report viewer is linked to with the data bindings. I want to be able to change the report (rdlc) the RV shows programaticaly but for some reason it does not work, can...

Does anyone know how to Populate a list box with the contents of a record set that has 5 columns Thanks

I have this code that check is a value from a dataset is Null but it wont work, can any help If IsDBNull(Me.DsData.tbl_SocTar_ALL_SAP_AND_INFOPAC_COMBINED(count1).Canc_date) = True Then

All I have this code trying to execute a stored procedure on a sql server: myQD.Connect = "ODBC;Description=PLYSQL03;DRIVER=SQL Server;SERVER=PLYSQL09;UID=Blahblah;PWD=BlahBlah;" myQD.SQL = "EXECUTE addUserName '" & UID & "','" & Name & "'" myQD.Execute However when i run this I get error...

I have this code: If IsDBNull(Me.DsTables1.tbl_EWTCases.FindByEWReference(ewRef).AssignedTo) Then But receive a error message stating cannot convert Dbnull to string, how can i covercome this THanks

I have a basic Query: SELECT CurrentStatus, COUNT(CurrentStatus) AS [Count of Status] FROM dbo.tbl_EWTCases GROUP BY CurrentStatus THis works fine but will not produce a total for anything that is showing as Status null, how do i get this to count nulls ? THanks

I have done this, but no data is populatingf me report?

I have a crystall report thats data comes from a dataset. I have a report viewer on a form that uses my crstall report a its datasource. However when i run my program all teh report shows is the data header, it looks as though dataset isnet being usedn in teh reports. How do I add the data...

Ah, but if i have a ds that has 100 rows, and i only changes 1 row do i still have to loop through the dataset and call the update method for every record?

I've king of got this to work but come accros amother problem. In my Data set I have fields User and user name, if I chnage a username on one row and call the .update method to commeit the chnage from the ds to the sql table, All record in that table update with the new user nameI have entered...

How do you set the update Command and what sghould you set it to ?

I have a DataGrid that is populated with the a tableadptor. I want to change things in the datagrid and use the tableadaptors "Update" meothod to commit the change in the datagrid to the SQL table, How do i do this??