|
Use the FORMAT function on the value u are inserting into the datagrid.
e.g Format(txtDate.text, "%M/%d/yyy"), also search in help menu for format function as gives u plenty of examples
hope this helps
Macky100
|
|
|
|
|
I insert to grid at like this
With DGTBCYearEnd
.Width = 72
.HeaderText = HT_YEAR_END
.MappingName = TC_YEAR_END
.NullText = ""
.Format = "%M/%d/yyyy"
End With
Where can i put Format function?
thank in advance!
tetra
|
|
|
|
|
the format function is used to format a value like a txtbox or a datarow or an item in a dataset. i have only used the format function for this purpose. Sorry can't help u with this insertion, b ut maybe u can help me how do u get the .NullText function
Cheers
macky100
|
|
|
|
|
How to increase the maximum number of error count in the error list window of VB.net? By default it's only 100 error per compilation. Iam migrating application from VB6 to VB.Net2005. So, i got more than 1000 errors which can be seen in the upgraded report.html. Am not able to predict the how many errors are corrected or remaining. So please help me.
Rekha
|
|
|
|
|
You probably can increase the number of errors reported, but even if you do, the total number or errors reported is hardly interresting. When you have so many errors in the code, most of them will be the result of previous errors in the code. For an example, if the declaration of a variable contains an error, there will also be an error for every time that variable is used.
---
b { font-weight: normal; }
|
|
|
|
|
I am trying to populate the data from excel in datgrid usin recordset. This piece of code which is not working? Can any body please help me in vb6. Thank You.'****************
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\CHITRA\VBprojects\EXCELREADRECORDSET\ExcelImport.xls;" & _
"Extended Properties=""Excel 8.0;HDR=Yes;"";"
str = "SELECT * FROM [Nov 00 Upload$] "
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.Open str, cnn, , adLockOptimistic, adCmdText
If rs.State <> adStateOpen Then
MsgBox "hi"
End If
MsgBox rs.RecordCount
rs.MoveFirst
Set Adodc.Recordset = rs
'*******************************
Chitra Dash
|
|
|
|
|
Even though i have added the serviceinstaller for the second service.
It has installed both the service.
But when i try to run the second service it gives me an error message
"The program that this service is configured to run does not implement the sercvice."
How to solve the problem?
|
|
|
|
|
Hey!
I have hear that the framework are not counting the weeks right?
will this code work?
<br />
<br />
Dim cal As New System.Globalization.GregorianCalendar<br />
<br />
Return cal.GetWeekOfYear(inDate, Globalization.CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday)
|
|
|
|
|
If i set the year to 2007 and get the week nr from week 13(2007-03-26) to week 12(2008-03-17) then it counts the weeks wrong
2007-12-31 - 2008-01-06 is becoming week nr 53!? there is no week nr 53 in 2007.
And thanks to this error the next week is missing(Week 1 2008(2008-01-07 - 2008-01-13))
|
|
|
|
|
Yes, the week number is wrong for certain dates when using the ISO standard calendar.
I have created a method that can be used as a replacement. You can get it from my code archive[^].
---
b { font-weight: normal; }
|
|
|
|
|
We want to set the value of data fields of the data set in the combo Box at form load event.
Gurpreet
|
|
|
|
|
use foreach loop and plz dont double post
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
thanks for reply.
What is the property to set the text or value of the combo box at the run time.
Gurpreet
|
|
|
|
|
ComboBox1.Items.Add(value)
Chatura Dilan
|
|
|
|
|
hi,
iwant to compare an image of some control with image of another control of a windows form can any body help me?
mamatharaghu
|
|
|
|
|
I know how to install Window service.
If i add 2 window services in a solution and then try to install the service it will still install only one of it.
Is it possiable to install more than one service from a single solution?
-- modified at 1:15 Tuesday 28th March, 2006
Solved.
Just added another installer and problem solved
|
|
|
|
|
hello
guys i would like to ask you again if ever you have an idea on how i my going to generate a childnode which is unbound i'm using a datareader to get the parentnode for my treeview and its working my only problem is that i dont know how am i going to generate a child node...okey i have three table in my sqlbase one is for the divisions,2nd is the department and the 3rd is the sections...okey to clarify this the divisions will hold as parentnode and i already got it,,,while department will be the childnode of the divisions,,after that the sections will be also the child of the department and that's my problem the childnode can fix my problem coz i'm already 2 days stock here...please help me...okey heres my code for divisions(parentnode)...
Dim myconnection As New SqlConnection(My.Settings.sampleConnectionString)
Dim cmdjol As String = "select description from dbo.employee_divisions"
Dim cmd As New SqlCommand(cmdjol, myconnection)
cmd.Parameters.Add("@description", SqlDbType.VarChar, 50, ParameterDirection.Input).Value = Divisions.divname.Text
myconnection.Open()
Dim mydatareader As SqlDataReader = cmd.ExecuteReader()
Try
While mydatareader.Read()
TreeView1.Nodes.Add(mydatareader.GetString(0))
TreeView1.ShowPlusMinus = True
TreeView1.ShowRootLines = True
End While
Finally
mydatareader.Close()
myconnection.close()
End Try
can you add for my childnode(department and sections)
thnaks in advance...
|
|
|
|
|
HI,
I AM CREATING A PARENT NODE THEN CHILD FROM DATABASE.
FOR THAT I HAVE USED 2 DATASET AND 2 SQL STATEMENTS.
'***************Adding Root Node**********************
TreeView1.Nodes.Add("PARENT")
'*********************End*****************************
'***************Adding Child Node*********************
For i = 0 To ds1.Tables(0).Rows.Count - 1
Dim ndNodes As TreeNodeCollection, ndNode As TreeNode
ndNodes = Me.TreeView1.Nodes
For Each ndNode In ndNodes
ndNode.Nodes.Add("" & ds1.Tables(0).Rows(i)(0) & " " & ds1.Tables(0).Rows(i)(1) & "")
Next
'******************End*****************************
'***************Adding Sub Child Node**************
Dim temp1 As String = ds1.Tables(0).Rows(i)(0)
Dim sql2 As String = "SELECT a,b,c FROM xyz"
adpt2 = New OleDbDataAdapter(sql2, conn)
adpt2.Fill(ds2, "TPSAT")
For j = 0 To ds2.Tables(0).Rows.Count - 1
Dim ndNodes1 As TreeNodeCollection
ndNodes1 = Me.TreeView1.Nodes(0).Nodes
ndNode = Me.TreeView1.Nodes(0).LastNode
ndNode.Nodes.Add("" & ds2.Tables(0).Rows(j)(0) & " " & ds2.Tables(0).Rows(j)(1) & "")
'***************************************end*****************************************************************
|
|
|
|
|
HI,
I AM CREATING A PARENT NODE THEN CHILD FROM DATABASE.
FOR THAT I HAVE USED 2 DATASET AND 2 SQL STATEMENTS.
'***************Adding Root Node**********************
TreeView1.Nodes.Add("PARENT")
'*********************End*****************************
'***************Adding Child Node*********************
For i = 0 To ds1.Tables(0).Rows.Count - 1
Dim ndNodes As TreeNodeCollection, ndNode As TreeNode
ndNodes = Me.TreeView1.Nodes
For Each ndNode In ndNodes
ndNode.Nodes.Add("" & ds1.Tables(0).Rows(i)(0) & " " & ds1.Tables(0).Rows(i)(1) & "")
Next
'******************End*****************************
'***************Adding Sub Child Node**************
Dim temp1 As String = ds1.Tables(0).Rows(i)(0)
Dim sql2 As String = "SELECT a,b,c FROM xyz"
adpt2 = New OleDbDataAdapter(sql2, conn)
adpt2.Fill(ds2, "TPSAT")
For j = 0 To ds2.Tables(0).Rows.Count - 1
Dim ndNodes1 As TreeNodeCollection
ndNodes1 = Me.TreeView1.Nodes(0).Nodes
ndNode = Me.TreeView1.Nodes(0).LastNode
ndNode.Nodes.Add("" & ds2.Tables(0).Rows(j)(0) & " " & ds2.Tables(0).Rows(j)(1) & "")
'***************************************end*****************************************************************
mamatharaghu
|
|
|
|
|
hi
see this
this is more perfect which u want
da = New SqlDataAdapter("select divisions from divisions", con)
da.Fill(ds, "Personals")
For i = 0 To ds.Tables(0).Rows.Count - 1
TreeView1.Nodes.Add(ds.Tables(0).Rows(i)(0))
Next
da1 = New SqlDataAdapter("select * from dept", con)
da1.Fill(ds1, "dept")
q = Me.TreeView1.Nodes
For Each p In q
For i = 0 To ds.Tables(0).Rows.Count - 1
p.Nodes.Add(ds1.Tables(0).Rows(i)(0))
Next
Next
da2 = New SqlDataAdapter("select * from sections", con)
da2.Fill(ds2, "sections")
Dim j As Integer
For j = 0 To ds.Tables(0).Rows.Count - 1
For i = 0 To ds2.Tables(0).Rows.Count - 1
q1 = Me.TreeView1.Nodes(j).Nodes
p = Me.TreeView1.Nodes(j).Nodes(i)
For Each p In q1
p.Nodes.Add(ds2.Tables(0).Rows(i)(0))
Next
Next
Next
mamatharaghu
|
|
|
|
|
I would like to be able to receive and send SMS in VB.NET. Please respond with sample or example of how i could accomplish this. I would especially love tutorials which i could read to acquire information/knowledge.
What do i have so far? Well i know you can access through COM Ports via cell phones. I also know that AT and MSCOM in .NET should have all the functions that handle this request.
I have been trying to read to see if i could find out exactly how but to no avail. Hence i now seek your assistance.
Looking forward to lots of response.
Martin Luther King, Jr. - "A man who won't die for something is not fit to live."
|
|
|
|
|
Hi all,
can anyone show me how to use windows management interface(WMI) using VB.Net
to check the disk quota and send the notification to the user if
the disk is almost run out of space.I am using windows XP.
I do have look some articles regarding this but failed to get any source codes.
Hope that anyone can guide me regarding the WMI...
Thanks a lot in advance.
besah
|
|
|
|
|
Here is an example of the type of thing that I need to do using Visual Basic Express:
Let's say that you are ordering a vehicle. First you pick the vehicle type:
Sedan
Sport Utility
Mini Van
Pickup Truck
Then, depending on which you selected, you get a list of exterior colors. Different colors are offered for each different vehicle type.
Then you are offered;
Leather seats
Cloth seats
Then you select an engine size. Different engines are offered for each different vehicle type.
Then you select a transmission, etc.
I prefer to use RadioBoxes with one of the RadioBoxes preselected as a default. Then I would like to have a Button1 labeled "Next" and a Button2 labeled "Back".
Where can I get a sample program that does this type of thing?
I tried to program it, but, the Button1_Click event or RadioButton1_checked_changed subroutines didn't work out because they caused me to get "lost". I need control to return to my next line of code after the user makes his selection.
|
|
|
|
|
Hi,
I'm working on a project involving image processing and analysis.I have implemented various edge detection algorithms.I cannot fully understand how to perform non-maximum supression and hysteresis ridge tracking in canny edge detection.if someone knows about websites that explains it detail please specify or if any has implemented the algorithm please post the source code.It's urgent!!
signing off is preci
|
|
|
|
|
Is there a way to get ‘Window Form Designer Generated Code’ of a VB.Net 2005 form
Thank you
Chatura Dilan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
