Leave A Space Between Two Columns ?
Feb 10, 2009I want to know how can I leave a space between two columns, so that the entry into the second column start in a given position.
This my code see it:
CODE:
I want to know how can I leave a space between two columns, so that the entry into the second column start in a given position.
This my code see it:
CODE:
is there any way to stretch a datagrid's control columns so they would take all the space width of the form?I can set datagrid's dock property to bottom so it will take all the bottom by height but the right side of the data grid will stay empty which is not good.If I set datagrid's dock property to right it jumps all over the form...So I need a way to fill up my datagrid's bottom and right (width) side so I would not have empty space.
View 3 RepliesHow would i get a certain text inside a textbox to equal that text space to space or null to space?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If Textbox1.Text.StartsWith(Textbox2.Text + " ") And Not String.IsNullOrEmpty(Textbox2.Text) Then
Textbox1.Text = Textbox1.Text.Remove(0, Textbox2.TextLength)
Textbox3.AppendText("a")
End If
Btw: after i finish this step my project will be finished!
I am using a picture box. I want to be able to use the Space or Enter key to change the image in it. For that, I try to use the keydown function as follow:
Private Sub ChestWindow_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyDown
Select Case e.KeyCode
Case Keys.NumPad1[code]....
is the function which changes the image. It works well when I press '1' on my numeric part of the keyboard as a test.The issue is that when I press Space or Enter, the form containing the picturebox closes. (I've already put the keyPreview property to True)
I'm using VB.net 2005. I have working programs that I populate DataGridViews with something like the following:
[Code]...
My goal is to connect to my database either manually or using an sqladapater, and get information from two of my databases on sql server 2005. Then I want to take this information and on run-time begin to add/subtract/divide/multiply certain columns and place the information into other columns. I can do this in queries, however, I want to do it on run-time what is the best way to achieve this.I had some of this working, but I just want to start fresh and see how you would go about doing this.
[Code]...
I have the below Linq query that is returning the data but I need to aggregate the columns to group on the Period and Sum the Count columns. How do I go about doing this?
LINQ
from t In tblTimes
join h In tblEngineeringDashboard_CADMachinesCounts on t.ID Equals h.TimeID
Order By t.Period
[code].....
I am using the following code to alter an table imported from an Excel spreadsheet
Dim SQL As String = "ALTER TABLE receipts ADD payee integer, account integer, category integer, reconciled boolean"
Dim dataread As New OleDb.OleDbCommand()
dataread.Connection = Connection1
[code]....
Both ExecuteNonQuery() actions yields the exception message {"Syntax error in field definition."}The error message does not happen with the first if the boolean column is not there (I tried Tes/No as a definition - but that also failed.The second query to modify the ID column from autonumber to integer I assume fails because it is a Primary KeyHas?
Imagine the following scene: I have one table which have tree columns (ID, Number, Name).
A Select query result on this:
code:
Now, the user deletes the Number 3 and 4. So, now the Select query is going to be:
code:
And I want to have:
code:
How can I organize the column?
I'm learning VB2008 using the Express edition IDE, and would like to start using the Mercurial SCM. I have a couple of questions:
1. Should I use a single repository for all my tiny projects under C:\VB.Net\, or should I create a repository into each project [code] If using only a single repository, will Mercurial filter changes so I can see only files belonging to a given project?
2. What files/directories can I leave out of Mercury? For instance, here's what VB2008 Express created for a single-form project: [code]
3. Is it possible to avoid the empty \WindowsApplication1\ at the root of a project, so that I don't have to cd into it to find the first actual file (WindowsApplication1.sln)?
I've the following code which successfully makes an average for all the columns from a table. What I need to do though is ignore certain columns in this equation.
Dim totalNumber as Double = 0
Dim count as Integer = 0
For x = 0 To xyz123.Tables(0).Columns.Count - 1
[Code]....
Averaging columns in a table - ignoring certain columns
View 2 RepliesWhat should I use and how to use something that functions like a label box but can handle several columns and columns? Something that looks like this. [code] Name | Age | Birthday are headers and the letters are variables
View 5 RepliesIs there a way to leave a control in code without explicitly going to the next control? For example, I want to[code]...
View 5 RepliesIt's usually happend that I have some arrays with same length. For example name(), surname(), age() Is it the best way to leave all info in 3 arrays or it possible ( better ) to concatenate somehow?
View 5 RepliesAll about datagridview,i entry the data from textbox to dtgridview the format is DATE normally ,if the textbox have a date that dtgridview can accept but when i leave blank and add to dtgridview..the message error""could'not store<> field".
My question is it possible make conversion from date to string??What code to put at the textbox or in cell_formating??what i try is..
if dgv.row(e.rowIndex).cell("dateRec").value="" then
e.value=""
e.formattedapplied=true
end if
[code].....
View 1 RepliesI have an old app still written in VB2003 that required some changes, part of that was revamping a menu that isn't behaving.I've deleted it and it doesn't show in the designer but when I start the program there it is, and still not correct.How do I really get rid of it so I can build another one?I'd hate to have to delete the whole MainMenu, this is the 5th in line, that would be a lot of re-creating.
View 8 RepliesI have a xml like this:
<?xml version="1.0" encoding="utf-8"?>
<xs:PersonaRCV xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:Identificacion>201232934</xs:Identificacion>
[code]....
and i called it in my aspx like this:
<pre><asp:Label ID="LBXML" runat="server"><%# Server.HtmlEncode(FormatXml(Eval("Respuesta")))%></asp:Label></pre>
Finally the code seen with Firebug looks like this:
<xs:PersonaRCV xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:Identificacion>401690010</xs:Identificacion>
<xs:Nombre>MAX FRANCISCO</xs:Nombre>
I was trying to do something with jquery replace:
var queHay = $("#MostrarEsconder" + myVal + " span").html();
queHay.replace('/<xs:/', '');
but i can't get it to work.Anyone can suggest something to get my results as i want them? with jquery or in codebehind in my FormatXML function!
I have a string variable that contains the following html data:
<p>
<em><strong>This is some <span style="background-color: rgb(255, 255, 0);">rich </span>text. 3 < 5 is a valid statement. <br />
[code].....
I want to create application leave, but i don't know how to start it first.
View 2 RepliesWhen you edit a cell in a datagrid, how can you "commit" that change if you are still in that current cell? Right now, the DataSet.HasChanges property isn't true UNTIL you leave the current cell. If you don't click on another row, then the property is not true yet. How can I tell it that it is true without physically clicking on another cell?
View 4 RepliesI'm programming something and I have it set to where if you leave the text box blank then a message box comes up and tells you to enter a value to move on to the next text box [code]Now whats currently happening is if I click the exit button and leave the name text box blank the error i programmed will come up and tell me to enter a name. I want to be able to click the exit button while no text is entered in the name text box bypassing the error message.
View 5 RepliesVS 2010 How to Handle Multiple MouseHover/Leave?
View 34 RepliesI have been working in an Migration Application where i find out some weird problem , Leave Event Fires twice causing validation to fire twice , hence i want to intercept the events to be processed by application..Hence require help in hooking the delegates so that i can get a list of the events that are to be processed .If anybody can help me out by giving some info or code as how to implement hooking in a textbox leave event/
View 1 RepliesI used textbox.leave so that when user leave the textbox, it will fire a function.
Under some cases, I would like to disable this textbox.leave event.
way to "reset" a tooltip, so you don't have to leave and re-enter a control to make it pop? I have a form that is pretty much entirely taken up by one control. I want to have its ToolTip text change based on which region of the control is being hovered over (which I can do now). I just have to leave the control and re-enter it to make it pop. I'd like to have the Tooltip pop, then if I move the mouse to a different location (still inside the control's bounds) have it pop-able again in the new spot.
View 5 RepliesI am working on a new assignment. Our instructor wants us to code a shared leave event for three textboxes (txtBox1, txtBox2, txtBox3).I understand how to code the shared event and how to make a generic tbox for it:
Private Sub txtDescription_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtBox1.Leave, txtBox2.Leave, txtBox3.Leave
'generic textbox
Dim txtText As TextBox
txtText = CType(sender, TextBox)
We are told that if the generic textbox contains data and the data has been modified (against the database record), we need to : Determine the name (name property) of the textbox that casued the evend and Determine the value (text property) of that textbox.I know to check to see if anything is in the generic box by the length property, and if it is modified by the modified method, but how do you determine the name and value? Is it a case statement?
I have some validation set on my combobox and it works as it should, but the problem I have is that the user is unable to click on the exit button, or click on the X to close the form until they have entered a valid field - would it be possible to exclude these controls from the validation? So the user can click on exit, or click on the X?
My coding is:
Private Sub Combobox1_Leave(sender As Object, e As System.EventArgs) Handles Combobox1.Leave
If Not Combobox1.Items.Contains(Combobox1.Text) Then
[CODE]...
when i leave the tab and move to another tab and return to last tab
this message show to me
http:[url].....