Re: build editor program(notepad)with vb.net - Visual Basic Discussion Boards

Dave Kreskowiak18-Jun-07 4:10

18-Jun-07 4:10

Nope. I call it a validation problem.

You're not putting the date entered by the user into a DateTime value. You're just taking the string and putting that directly into an SQL statement. That's a really bad idea.

If you use a parameterized query, the parameter will format the DateTime value for any SQL Server localization for you. All you have to do is get the text the user entered into a DateTime value, validate it so it's inside a good date range, then pass it to your SQL code.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: Date fromat problem

Sathesh Sakthivel17-Jun-07 3:54

Sathesh Sakthivel

17-Jun-07 3:54

If you are going to save the Date in the DB go with Datetime Format. not by String datatype.

In case if you have used the datatype as string then you should go with

Use the DateTime.ParseExact method to parse the string.

Regards,

Satips. Rose | [Rose]

Re: Date fromat problem

Dave Kreskowiak17-Jun-07 4:30

Dave Kreskowiak

17-Jun-07 4:30

Wy are you getting this from a label? Why not just get the date/time value from the original variable that set the label's date? No conversion and no parsing will be involved then.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Save drawing to an image in VB.NET

hsprasain16-Jun-07 12:41

hsprasain

16-Jun-07 12:41

Hey,

I've drawn a drawing in form. For example I have drawn line or circle or ... My problem is I want to save this drawing as image file. Can anybody give me an idea how I can do this?

I appreciate your help.

hsprasain

Re: Save drawing to an image in VB.NET

Christian Graus16-Jun-07 14:24

Christian Graus

16-Jun-07 14:24

Draw it onto an Image or Bitmap, then call it's Save method.

If you're already drawing in the Paint event, then just create a member Bitmap, draw onto that, and draw that in your Paint event.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: Save drawing to an image in VB.NET

GuyThiebaut17-Jun-07 6:43

GuyThiebaut

17-Jun-07 6:43

In my code I creat a piechart.
What I have done is stripped down the code to show you what goes where (This code will not work as it needs declarations and values...).
This code will in effect make the picture 'stick' to the form - so that it does not get erased as you move the form.

Panel1 is where the piechart is being drawn.
Width and Height are variables you need to set to the size of the picture you want.

You will also need to include the Panel1.CreateGraphics.DrawImage(b1, 0, 0) command in the Paint event of the objetct you are drawing onto - in fact this is where the magic of this method is...

Give this a go and good luck...

Regards

Guy
Cambridge
UK

Public b1 As Bitmap
Public g1 As Graphics

    b1 = New Bitmap(Width, Height, Panel1.CreateGraphics())
    g1 = Graphics.FromImage(b1)

    g1.DrawPie(Pen:=myPen, rect:=New Rectangle _
    (x:=x + XAdjust, y:=y + yAdjust, Width:=Width, Height:=Height), _
    startAngle:=startPos, sweepAngle:=sweep)

Private Sub Panel1_Paint(ByVal sender As System.Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles Panel1.Paint

    Panel1.CreateGraphics.DrawImage(b1, 0, 0)

End Sub

You always pass failure on the way to success.

build editor program(notepad)with vb.net

ilnaz16-Jun-07 10:25

ilnaz

16-Jun-07 10:25

hi i am very amator in vb.net i want build an editor program like notepad whit vb.net but i cannot build menu and their code like open in file submenu and save and ...
please guide me and help.
thanks a lot Confused | :confused:

Re: build editor program(notepad)with vb.net

Christian Graus16-Jun-07 14:26

Christian Graus

16-Jun-07 14:26

Really, your best bet is to buy a book and work through it, or look for some tutorials online. Building a menu is simply a case of dragging it onto your form, and clicking where you want menu items to be, to add them. Making them do something is as simple as double clicking on them in the editor. The code is also fairly simple, just use the FileOpenDialog and FileSaveDialog classes.

But, again, if you're asking this, you're probaby enough of a beginner, that you really need to rely on a book to get you started, as you'll get more structured and consistent help than you cn get from forum replies.

build editor program(notepad)with vb.net

ilnaz16-Jun-07 10:17

ilnaz

16-Jun-07 10:17

hi i am very amator in vb.net programming i want build a editor program like notepad in vb.net but i cannot build menu and their code for menu like open frome file submenu and save and ...
please help and guid me
thanks a lot

EXCEL to HTML

Vidhya Sagar16-Jun-07 6:24

Vidhya Sagar

16-Jun-07 6:24

Hi experts,

I need a vb script(.vbs) to convert a Excel file to Html file. Is it possible?????

Regards....Sagar

Re: EXCEL to HTML

Expert Coming16-Jun-07 13:43

Expert Coming

16-Jun-07 13:43

Of course it is possible. Anything is possible when you are programming!

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

How to adjust the size of the toolstrip control ?

Aniket Sonawane16-Jun-07 5:55

Aniket Sonawane

16-Jun-07 5:55

Iam creating a Text Editor and i have added a toolsrtip control in the form with 7 buttons on it . The size (height) of the toolstrip control is very small. so the buttons on it appear very small. I want them larger(both by length and breadth) and by default the size of the toolstrip control cannot be changed form the Properties window. Please kindly tell me how to change the size.

Aniket Sonawane

how can i convert word document to XML using vb.net

koolprasad200316-Jun-07 0:00

koolprasad2003

16-Jun-07 0:00

hello frnds,
how can i convert word document to XML using vb.net the
if any one have code or supportive link then plzz..help

regards,
koolprasad2003 Smile | :)

Be a good listener...Because Opprtunity knoughts softly...N-Joy

Re: how can i convert word document to XML using vb.net

Duane in Japan17-Jun-07 0:19

Duane in Japan

17-Jun-07 0:19

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?culture=en-US&EventID=1032319980&CountryCode=US

Try this video.

Runtime table generation and filling data from Ms Access?

venu_dil15-Jun-07 23:52

venu_dil

15-Jun-07 23:52

Can any one plz help me to get the code for my problem.

problem:

I have to generate tables at runtime from Ms Access data base. Number of tables to generate depends on the sql query we pass in the program and the depends on the data in the tables.

So I want the code for diplaying a table on control panel and fill the data to it from the Access files based on the query.

Plz reply me if you got any ideas or codes for this

thank you

dil

Re: Runtime table generation and filling data from Ms Access?

.NetRams16-Jun-07 0:09

.NetRams

16-Jun-07 0:09

I have to generate tables at runtime from Ms Access data base. Number of tables to generate depends on the sql query we pass in the program and the depends on the data in the tables.

>> User the "create table ... " query statement to create the table with number of columns and their types.

So I want the code for diplaying a table on control panel and fill the data to it from the Access files based on the query.

>>Do you have any file, which holds datas for newly creating tables?

Be simple and Be sample.

Re: Runtime table generation and filling data from Ms Access?

venu_dil16-Jun-07 6:24

venu_dil

16-Jun-07 6:24

Thanks for favourable answer "ramskr".

I am trying to generate the grid view table on the control panel through for loop by using the sql query.

I got the code to get the data from the Access data base.

So the thing I need is, code to generate table at run time

Cheers.

dil

get date format

Jayesh Talsaniya15-Jun-07 23:15

Jayesh Talsaniya

15-Jun-07 23:15

how to get the date format in vb?

Jayesh Talsaniya

Re: get date format

.NetRams16-Jun-07 0:12

.NetRams

16-Jun-07 0:12

Do you need to extract, month, day, year from date?

use -> Date.month , Date.day, Date.year. Also you can convert date to shortdate, shorttime, longdate and longtime as string.

Be simple and Be sample.

Re: get date format

Jayesh Talsaniya16-Jun-07 0:16

Jayesh Talsaniya

16-Jun-07 0:16

no i dont mean that.

i want to check the format fo the date that is in the textbox contol.
wether it is dd/mm/yyyy or /mm/dd/yyyy or other....

Jayesh Talsaniya

Re: get date format

.NetRams16-Jun-07 0:22

.NetRams

16-Jun-07 0:22

In VB.net there is no direct control to check format. Try with masked text box. You have to write own code on keypress event - first 2 digit should be below 12 (if it is month) and so on.

Be simple and Be sample.

Re: get date format

Jayesh Talsaniya16-Jun-07 0:24

Jayesh Talsaniya

16-Jun-07 0:24

oh is it so?

k thanx for replying.

now i wil code for that.

regards

Jayesh Talsaniya

Re: get date format

Dave Kreskowiak16-Jun-07 12:01

Dave Kreskowiak

16-Jun-07 12:01

Unless you limit the input of the user, there's no way to tell what format the date is in, reliably. Think about it. Which number is the month and which is the day in "6/6/07"? With restricting the user to a known format, it's impossible to tell. You could get a good clue if you looked at the culture information though. Chances are, the entered date will follow the standard format for a country. Mostly... Check out the CultureInfo class. You can get the current culture your code is running under and get the DateTimeFormat from there. This would be the culture of the O/S is setup for, NOT necessarily the one the user typed into a TextBox.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Radiobutton inside gridview

sgkani15-Jun-07 21:38

sgkani

15-Jun-07 21:38

Hi,

I have a gridview of 5 columns.In that 3 column has radiobutton grouped in each row.

<asp:templatefield sortexpression="Item" headertext="Item">
<headerstyle width="15%" horizontalalign="Center" forecolor="White">
<itemstyle wrap="false" horizontalalign="Left">
<edititemtemplate>
<asp:textbox id="txtEditItem" visible="false" runat="server" text="<%#Databinder.Eval(Container.DataItem,"Item")%>">

<itemtemplate>
<asp:label id="lblItem" runat="server" text="<%#Databinder.Eval(Container.DataItem,"Item")%>">

<asp:templatefield sortexpression="Yes" headertext="Yes">
<headerstyle width="7%" horizontalalign="Center" forecolor="White">
<itemstyle horizontalalign="Center">
<itemtemplate>

<asp:radiobutton id="rbYes" runat="server" groupname="item1" checked="true" enabled="true">

<asp:templatefield sortexpression="No" headertext="No">
<headerstyle width="7%" horizontalalign="Center" forecolor="White">
<itemstyle horizontalalign="Center">
<itemtemplate>
<asp:radiobutton id="rbNo" causesvalidation="true" runat="server" groupname="item1" enabled="true">

<asp:templatefield sortexpression="NA" headertext="N/A">
<headerstyle width="7%" horizontalalign="Center" forecolor="White">
<itemstyle horizontalalign="Center">
<itemtemplate>
<asp:radiobutton id="rbNA" runat="server" groupname="item1" enabled="true">

<asp:templatefield sortexpression="Comments" headertext="Comments">
<headerstyle width="44%" horizontalalign="Center" forecolor="White">
<itemstyle wrap="false" horizontalalign="left">
<edititemtemplate>
<asp:textbox id="txtEditComments" runat="server" text="<%#Databinder.Eval(Container.DataItem,"Comments")%>">

<itemtemplate>
<asp:label id="lblComments" runat="server" text="<%#Databinder.Eval(Container.DataItem,"Comments")%>">

in this Button "rbYes" is checked by default. if i cliked "rbNo" or "rbNA" the other 2 columns must be editable.

Can anyone help me out in this..

expecting ur response..

Kanimozhi.S

Re: Radiobutton inside gridview

Duane in Japan17-Jun-07 0:22

Duane in Japan

17-Jun-07 0:22

Does this help any?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1727092&SiteID=1

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.