I have a table where i stored News with date and title.in my home page i need to display date and title. i can achieve this using gridview and i got the following result,
but i need the...
i am downloading data from some other source to Excel workbook. after that, i just want to save all those data to DB after performing some validations.
at the moment, i am using the following code to import data from excel into my Dataset.
Dim App As Excel.Application
Dim wkb As...
i want to display my records in the following structure(pls find the attachment) and my db structure looks like,
Id ------Name - Age - Dept.
Record1 Field1 Field2 Field3
Record2 Field1 Field2 Field3
Record3 Field1 Field2 Field3
i tried this using...
which method r u using to create ur excel file. that is, if u r using excel object to save ur file, then u can use the following
App.DisplayAlerts = False
ur declaration could be some thing like that,
Dim App As New Excel.Application
Dim WBook as...
let me explain,
in my program i am using two dimensional array to store large amount of data. i need to search for particular string, for that i am using For..Next to loop thru my array and i need to repeat this step many times for some other checking. this is really time consumable and so i am...
i want to search a particular string on first dimension of two dimensional array. i can do this by looping thru each element on the array. but its really time consuming and my array has large amout of data too and also i need to repeat this process many times.so that, i like to use some...
i am developing COM addin for Outlook 2003 which provides some additional features to "Send mail" function for my client.for this i have created one "compose new msg" window and used CDO object to access "Address Book" window of outlook.here my problem is,when i try to access address entry...
add validation to ur loop, i.e)
Dim r As RepeaterItem
Dim bln As Integer
For Each r In rptEvManage.Items
if not isNothing(r.FindControl("uplEventFile")) Then
Dim strFileName As String = CType(r.FindControl("uplEventFile"), HtmlInputFile).PostedFile.FileName
try this code,
change ur parse statement into
u can also add the validation for this, ie)
dim TmpDate as Date
If isDate(CType(r.FindControl("txtEvDate"), TextBox).Text) Then...
you can use this,
Dim SelStr As String = "SELECT COUNT(*) AS Expr1 FROM TEST"
Dim Selcmd As New Odbc.OdbcCommand
Dim dr As Odbc.OdbcDataReader
dim Con as new odbc.odbcConnection
con.ConnectionString="ur connection String to db"
dim TmpStr as string
Selcmd.Connection = Con...
If u want to use databinding, then u may change ur select statement like that "select Column1 from table1 union select '' as column1" and fill the dataset using this, now ur combo box always has the empty value as a first record.
This is always the prolem of using data adapter update cmd to perform inserts except using datagrid to do this.u can use sql insert statement with odbccommand or sqlcommand to perform this.This could solve your autogenerate number problem.
otherwise u need to create NewDatarow manually and...