Hi Parag,
Explain us clearly what you need.We use Datareaders to get the data in connected mode.
Dim myCommand As SqlCommand
Dim strSql as String
strSql = "Insert into EMP Values(" + <<UR text box values>> +")
myCommand=New SqlCommand(strS ql)
myCommand.Execu teNonQuery()
Thanks.
santuvssantu
Last Activity: Oct 19 '07, 06:00 AM
Joined: Jun 26 '07
Location:
-
Try declaring the DS as Global(to use it only once). I think that should work.
ThanksLeave a comment:
-
Hi,
add a job to run the Stored proc as Schedule task
1) create new job,
2) add a step to created job
3) Add name for this step, such as "Step1"
4) Choose type: Transact-SQL script
5) Choose actual database from list
6) Add command:
EXEC sp_yourstored_p roc_name
7) Go to schedules tab and set correct schedule planLeave a comment:
-
Hi,
You can create a template column for checkbox. Please go through below one.
Hope this helps.
http://www.xmlfox.com/CSsamples.htmLeave a comment:
-
Hi,
Use Convert.ToDecim al() function.
Thanks.Leave a comment:
-
Hi,
Please provide the command you are using. May be you are not converting the text box values to datetime.
DATEDIFF ( datepart , startdate , enddate ) where startdate and enddate are datetime datatype values.
Have a look at the Datediff() below:
http://msdn2.microsoft .com/en-us/library/b5xbyt6f(VS.71) .aspx
Thanks.Leave a comment:
-
Hi,
I got it using
m_WordDoc.PageS etup.OddAndEven PagesHeaderFoot er = -1
0 for False.
-1 is for true.
Thanks.Leave a comment:
-
Hi All,
I got the answer to my query and just want to share with you all.
m_WordDoc.Inlin eShapes.AddOLEO bject(ClassType :="Excel.Sheet" ,FileName:=full path, DisplayAsIcon:= False)
AddOLEObject Method
Creates an OLE object. Returns the InlineShape object that represents the new OLE object.
expression.AddO LEObject(ClassT ype, FileName, LinkToFile, DisplayAsIcon, IconFileName, IconIndex,...Leave a comment:
-
Please can some one help???? This is urgent for me
When I use Shapes.ADDOLEOb ject() function for this, I am able to insert successfully but at the starting of word. When I am doing this for 2 or 3, it was just overlapped. I want to insert 2 excel files in the word..........
Hope I am clear.........
Thanks.Leave a comment:
-
Hi,
Dim m_WordDoc As Word.Document
m_WordDoc.Activ eWindow.ActiveP ane.View.SeekVi ew = Word.WdSeekView .wdSeekCurrentP ageHeader
m_WordDoc.Appli cation.Selectio n.TypeText(Text :="Test Header")
m_WordDoc.Activ eWindow.View.Se ekView = Word.WdSeekView .wdSeekMainDocu ment
The same way you can put your own footer by changing wdSeekCurrentPa geFooter.....
Hope this...Leave a comment:
-
Inserting Excel file to a word document using VB.NET
Hi Friends,
I have tried inserting an excel file to a word document.But the following code is inserting the junk information. So can you please help me out?
Dim m_WordApp As New Word.Applicatio n
Dim m_WordDoc As Word.Document
m_WordDoc = m_WordApp.Docum ents.Open(CObj( "C:\Documen ts and Settings\santu\ My Documents\New Microsoft Word Document.doc"), CObj(False),... -
Word Document Properties in VB.NET
Can any one give me the correct way to get this?
I am trying to set, for example, the "Different Odd & Even Page
Header" property in a Word doc.
I have a word document object m_WordDoc.
I am trying ...
m_WordDoc.PageS etup.OddAndEven PagesHeaderFoot er = 1;
.... but get error msg
System.Argument Exception: The parameter is incorrect,
at Microsoft.Offic e.Interop.Word. PageSetup.set_O ddAnd...
No activity results to display
Leave a comment: