I am using a DateTimePicker control in my form. By selecting a date, it should be inserted in an MS SQL database. But, the date format in VB is (DMY) and is different from the format in MS SQL (YMD) !!
View 1 RepliesI have the following function which is used by a class. It sets dates. Now the problem I have is one date comes back as dd/mm/yyyy and the other as mm/dd/yyyy
View 2 RepliesI am trying gto get my date formated in the 01/01/2011 format which I beleive is "M/dd/yyyy"current line of code Me.List1_slddatetxt.DataBindings.Add("Text", Subject_Values.BindingSource4, Form10.DateSold_txt.Text, True).FormatString = "M/dd/yyyy"
View 5 RepliesWith Binding the Listview with dataset, the dateformat in datefield only appear the year as '12' instead of '2012',
strSQL = "select * from tableA where PNo = '" & cbPortNo.SelectedItem.ToString() & "' and convert(date, fDateReceived) = '" & dDateSelected & "'"
Dim da1 As New SqlDataAdapter(strSQL, sqlconn)
[code]....
I am having a problem with my program that is desinged to read a 3rd party text file database. I posted previosuly about a problem inserting an item in a new row and the column was expectig a different data type. It appears that sometimes the column is being determined to be of decimal value, I dont understand why. the fields contain information such as
Col1
F123456
CLW-12321 etc....
So my column fills with
123456
12321 the letters just get chopped off
So I added MaxScanRows = 0 to my schema file and that took care of the problem
Except now several of my columns that contain Date Values are coming back
9/24/2010 00:00:00
without the setting MaxScanRows = 0
The date returned 9/24/2010
Here is the code for my schema ini file I am creating:
HTML
Dim fs As New FileStream("Schema.ini", FileMode.Create, FileAccess.Write)
Dim writer As New StreamWriter(fs)
[CODE]............
I have been trying different settings hence the dimmed out lines
Here is the code to fill the datatable:
HTML
[CODE].............
I am thinking that without the MaxScanRows = 0 setting the datatype for Col1 is being incorrectly determined
I am not sure what is happening with other columns that contain date values. Apparently If i use MaxScan Rows=0 all columns are being pulled over as string value which creates numerous problems. If I dont use maxscanrows then all columns appear to be correct except Col21 MLSNUM which is being pulled in as a decimal. Can I change that in the schema file?
I'm using Visual Studio 2010 / VB / dot net 4.0, and I have a drop-down menu in my left column that switches resource languages for the end user. It reads like this:
--------English ------- <<- Engish is always the default top language option
French |
Spanish |
[code].....
I have two combobox in a form: Cb1 and Cb2
When I load the form, Cb1 and Cb2 are connected to a bindingsource.
When I change Cb1, the code (below) changes Cb2 to show only the items according to Cb1
This is working fine.
The problem is when I change Cb1 , change Cb2 and click the save button..... Cb2 seems to be 'lost'...
I'm using VS2008.
CODE:
I have a DGV I am working on, and I have many columns.
For example I have Columns colcase(Combobox), colreportTime(Time)
the combox shows 4 cases {A,B,C,D}
what I need to do is if the user select "C"
the the colreporttime will show the time of this change unless the old value is C
I'm getting familiar now with using the Dataset Designer and how it makes for quick and easy updates and query of tables. I use to use the OleDB commands and leave the Connection String as a Global Constant so I can easily change it if the server name changes, or if we have to re-direct the .NET to another instance of the database.
But now that I use the Dataset designer I'm concerned that I maintain flexibility and support in the long run. how the Dataset designer works and where it stores it's connection string info? And how difficult that would be to update. It looks like I modify the App.config file, but I'm unfamiliar with this.
What am I getting myself into? It looks like a standard XML file. Is that it?
Ok, so I know I have to change the labeledit to true but that doesn't change the selected node to be able to edit, so how does that work?
Along with renaming I have it set to that a user can add a node. So once the node has ben added how do I let them rename it as it is being added and without being a prompt or inputbox? So lets say I cam clicked on a parent and they click add node, it adds it to parent but I have it so it is default "New" but I want them to edit it as it is added. I think it will be along the same lines as clicking on one and rename but I have to start some place.
Can someone please help me create a very very simplistic sample page as the chat page included is too coomplete. something as simple as detecting a change in the database and displaying the word "change" on screen in realtime for any client connected.and I tried creating a global.asax file into which I added in the line mentioned in the link above, but it does not seem to like the word "Setup" in the line [code]
View 2 Replieswhats wrong with my code?if i change the item from the combo box..the textbox not change or has an error?
conn = New MySqlConnection()
conn.ConnectionString = "server=localhost; user id=root; password=12345; database=gigzta; allow zero datetime=no"
strsql = "SELECT accNo FROM accinfo WHERE (completename LIKE '%" & ComboBox2.Text & "%')"[code].....
I have 10 Comboboxes in a form. All these combo boxes have databound items which come from the same column in a table in the database (access 07) (Am designing a billing software, and these comboboxes show the items (10 lines of them).All these combos reside in one Groupbox.Now for the strange (scary/funny) part, whenever I change a value of 1 combo, all the other combos change automatically and show the same value as the one that was changed. (strange!).
View 6 RepliesI have a change calculator program that has two user inputs and 6 outputs. The user inputs how much money is owed, then how much money is received. IT will then display how much change you need to give back. It should also display the different types of currency that are available to give as change. Here is my code so far.
[Code]...
I'm working on a simple base form in which all the other forms in the project will inherit. This base form only adds 5 properties (at the moment) dealing with painting a gradient background. The problem I'm facing right now is when I change a property on Form1 (the test form) and click run it doesn't show that change. I also checked the .designer.vb file and when I make a change it's not added to the code behind file, I'm at a loss right now to why.
[Code]...
I am throwing some data out into Excel and am having some formatting troubles. I have 5 columns (date, time, a long number I don't want displayed in scientific notation - text is fine, text, text). I can get it all working with numberformat, however I have to do them different ways.
Date works this way cell.numberformat = "m/d/yy" and it formats it to say 3/1/11
Time works this way cell.numberformat = "h:mm AM/PM" and it formats it to say 8:07 AM
For the long number cell.numberformat = "@" and it doesn't change the format and it gets displayed in scientific notation
BUT if I use cell.style.numberformat = "@" it works as it should, but it messes up all of the date and time cells. Apparently when you use style.numberformat, it doesn't just apply to the cell you're working with. If I try using style.numberformat with the date and time formats, they don't change and are entered as if I didn't change the format at all.
So, I've got a text boxes which loads up a content from a XML file, usually a numbers I want a button, so when I will change the numbers on the text box, the data in file will change as well, in other words a save button That's how the data is being taken from a file
[code]...
Those EditPaths, Playa2 etc are making up a path to a file
means the images that will display in the picturebox is based on the value shown on the textbox (ProjID)..
Please see code below..
[CODE
Public Class Form4
[code].....
How to know HTML source change or not change because this web site written ASP.net and information is changing in TABLE tags when pressed button.I'm not reading when change the TABLE tags.
View 6 RepliesI have a treeview and text box below it... is it easy or even possible to allow a user to change the height of the treeview which will automatically change the height of the textbox so there is no gap between them?ie one gets bigger the other gets smaller etc etc
View 1 RepliesI have the Context Menu Options like ( Small Font , Large Font ) based on the selection I want to change the size of the Font in the Controls,Control's Size & location(x,y,height,width). The resize of the controls should not affect the look and feel of the forms.
View 5 RepliesI inherits textbox Control and I added some new properties to it .one of these properties value i want it to change it's value in desgin time when i change Name property of the new textbox
Public Class NewTextBox
Inherits TextBox
Private _txtSubName As String = String.Empty
That is the property for set or get SubstringName of Textbox
Public Property SubName() As String
Get
Return _txtSubName[code].....
that's the property i want to change it's value when i change Name property of the control.i tried to overrides Name property but it's not overridable also i trieds to overloads it but it doesn't work in desgin time.Here is something i tried but it's wronge.
Private _txtName As String = ""
Public Overloads Property Name() As String
Get[code]......
OK So basically as the title says, in my browser i have tabs, now when a new tab is open and the user will go to a new page, if they click to the next tab the url box & document title remain the same (until they click a link or something) are there any methods of detecting when the person clicks to another tab so that i can code it to change the textbox and form text?
View 4 RepliesI want to change my controls opacity .I know how can i change the form opacity but I want to change the controls opacity without change the the form opacity , such as : "I want to set my form opacity = %100 and the button opacity = %50 " or "I want to set my form opacity = %50 and the button opacity = %100 " I'm using visual studio 2005 .net .I want to do that in basic language
View 3 RepliesHow to change all properties of a form to properties of other but don't change important properties like Owner,Handle, OwnedForms, Parent,HasChildren,Controls and ... .I have a child form that i want it to provide controls of Form.The background form provides Aero frame and child form is a transparent form in it.I want it because I want to draw buttons with system style in Aero in Windows Forms.This is my own code but it does not work good (ForeForm is child form):
For Each Propertry In ForeForm.GetType.GetProperties()
Select Case Propertry.Name
Case "AeroBackgroundEnabled", "FormBorderStyle", "TransparencyKey", "Parent", "Owner", "ShowInTaskbar", "Handle", "HasChildren", "OwnedFo[code].....
Additionaly:I wrote a great Aero Form.I don't publish current version (1.2) that supports Aero Blur,RealTime Aero Color change,extend Basic theme?
I've checked under properties and I can't seem to find a way to change the name of my tabs from "Tabpage1", "Tabpage2", etc.
View 2 RepliesI am trying to make a program that checks a certain process and changes one hex value to another. I want it to work a tad like some of those memory editors out there [art money, cheat engine, etc]... where it works only when the program is open, and it goes back to normal if you close and open the program again.
View 1 RepliesI've been able to change the Look And Feel of my GUI, is there a way to do this in Visual Basic?
View 3 Repliesi must change the SessionID for an ASP.NET 4.0 Application (SessionID via Cookies) to have it run on 2 domains with the same Session [URL]... This will keep the Items in sync abov the 2 domains.
Therefor the Page will have iframes with an "setkey.aspx/ashx", which must set the new SessionID.
<iframe src="http://web1.local/SetKey.aspx?sid=<%=Session.SessionID%>" width="250" height="100"></iframe>
<iframe src="http://web2.local/SetKey.aspx?sid=<%=Session.SessionID%>" width="250" height="100"></iframe>
In the Session.Start the Session is already filled, so the SessionID keeps static via several Requests from the same Broeser.
[Code]...
public void ChangeList(IEnumerable<LineInfo> newLineList)
{
if (InvokeRequired)
{
BeginInvoke((Action<MainForm, IEnumerable<LineInfo>>)((t, e1) => t.ChangeList(e1)), this, newLineList);
return;
}
}