how to insert record in database with each date of month on single button click ?

Posted by Mr. Goo on Stack Overflow See other posts from Stack Overflow or by Mr. Goo
Published on 2011-03-13T08:08:39Z Indexed on 2011/03/13 8:09 UTC
Read the original article Hit count: 332

Filed under:

vb.net

|

visual-studio-2008

|

sql-server-2005

I have two textbox .... textbox1 and textbox2

textbox1 == choose from date textbox2 == choose to date

if user select from date in textbox1 as 01-May-2011 and in textbox2 as 30-May-2011

then all the dates from 01-MAy-2011 to 30-May-2011 will be inserted in each row of mssql2005 datatable...

example. . :

IN database Table1 structure ...

ID           Date
1            01-MAy-2011
2            02-MAy-2011
3            03-MAy-2011
4            04-MAy-2011
5            05-MAy-2011

and so on till 30-May-2011

© Stack Overflow or respective owner

Related posts about vb.net

VB.NET How Do I skin a vb.net app

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to skin a vb.net app I made ive googled some stuff and I've seen skinned vb.net apps. However it seems like any time i try to find someone explaining it its a link to a pay for product. Does anyone have anything useful on this? >>> More
VB.NET IF() Coalesce and “Expression Expected” Error

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I am trying to use the equivalent of the C# “??” operator in some VB.NET code that I am working in. This StackOverflow article for “Is there a VB.NET equivalent for C#'s ?? operator?” explains the VB.NET IF() statement syntax which is exactly what I am looking for... and I thought I was going to… >>> More
Would a programmer knowing C# and VB.Net ever choose VB.Net?

as seen on Programmers - Search for 'Programmers'
Now before someone tells me VB.Net isn't bad like VB was, I know it isn't. But, I've yet to speak to a programmer who is completely content that some project they work on is written in VB.Net. Basically, my question is would a programmer knowing both C# and VB.Net (and all of their team knowing both)… >>> More
Do I lose anything by coding in c# and using free online vb.net code convertors?

as seen on Programmers - Search for 'Programmers'
The company I work for uses vb.net since there are many programmers who moved up from vb6 to vb.net. Basically more vb.net resources in the company for support/maintenance vs c#. I am a c# coder and was wondering if I could just continue coding in c# and just use the many online free c# to vb.net… >>> More
What are some good/reputable/widely-used libraries written in VB.NET?

as seen on Stack Overflow - Search for 'Stack Overflow'
Generally speaking, when VB.NET and C# are compared, there is a lot of strong support for C#, accompanied by some bashing of VB.NET until a respected developer comes along and acts as The Voice Of Reason, pointing out that while VB prior to VB.NET had its fair share of issues, VB.NET is really a very… >>> More

Related posts about visual-studio-2008

Server.transfer causing HttpException

as seen on Stack Overflow - Search for 'Stack Overflow'
I am developing a C#/SQL ASP.NET web application in VS 2008. Currently I am using the Server.Transfer method to transfer control from one ASPX.CS file to another ASPX file. The first time through, this works. But after control is transferred to this new file it encounters a condition: if (restart… >>> More
Using Visual Studio 2008 to Assemble, Link, Debug, and Execute MASM 6.11 Assembly Code

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to use Visual Studio 2008 to the greatest extent possible while effectively compiling/linking/building/etc code as if all these build processes were being done by the tools provided with MASM 6.11. The exact version of MASM does not matter, so long as it's within the 6.x range, as that… >>> More
Visual Studio 2008: Don't deploy SQL Server Compact 3.5 when debugging

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm using VS2008 to create a Compact Framework application for a Windows CE 5.0 device (Datalogic Kyman). I'm using SQL Server Compact 3.5 in my application. However, I'm debugging on a Kyman that still has Windows CE 4.2 installed (attached via USB using Mobile Device Center). My problem: VS2008… >>> More
Missing help files for Microsoft.WindowsMobile in Visual Studio 2008 help system

as seen on Stack Overflow - Search for 'Stack Overflow'
I've just installed the Windows Mobile 6.5.3 DTK, both standard and professional. Before that I had the standard and professional Windows Mobile 6 SDKs. All Windows Mobile help pages are missing in Visual Studio 2008's help system - in particular everything in the Microsoft.WindowsMobile namespace… >>> More
Visual Studio 2008: Start custom build target via project/solution context menu - without add-in

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a custom build target in a visual studio 2008 c# project. Is there a simple way to add a context menu item to the project, so that the custom build target can be executed via the ide? The build target is not integrated into the default build process and has to be started by hand. This step… >>> More