Search results for query: *

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

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"

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...

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 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...

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??

How do I open a document from my application, all I want to do is open the document, word, excel etc seperate from my application Thanks

Is it possible to diplay the data from a 2 dimentional array (type varient) to a data grid. if so How? Thanks

If i have a date and want to calculate what that date is +10 days including working days how do i do that?

If i have a dataset that is populated from SQL Table and I make changes to that dataset. How do I commit those changes back to the original SQL table?

If I have a dataset and one of those columns holds a dateTime dataType, who can i check if a specfic colums is Nul, I've ried everything including: if dsCases.tbl_EWTCases(0).InterimResponseDate = "" t if dsCases.tbl_EWTCases(0).InterimResponseDate is Null nothing seems to work

How do I cancel a errorprovider, i have a form where all the fields are validated by a error provider, but if i just want to close the form I cant unless all the fieds are completed correctly, So can i just put a button on my form that just closes the form without refering to the erorrprovider

Does any know how to get the value from a datagrid without accessing the dataset, ie what the value is at row 2 colunmn 5 Thanks

If a user makes multiple selection on a datagrid, is there anyway I can add the row index to an arraylist or Dataset Thanks