|
how can i count the total no of row in datagrid vb.net
asdf
|
|
|
|
|
|
kostasdiktia2 wrote: DataGrid1.RowCount
buth -1
<blink>FeRtoll Software.net
------------
E-Mail me
WebPage
|
|
|
|
|
Hi: help code program play sound wav from path "C:\dicsound\sound\..."soundfilename" by SELECT * From diccom ORDER BY id_dic ASC
///////////////////////////////////////////////////////////////////////
Private Sub ShowPostion()
'Dim Oledr As OleDbDataReader
Dim oleCmd As OleDbCommand
Dim sqlTmp As String
Dim box As New PictureBox
sqlTmp = "SELECT * From diccom ORDER BY id_dic ASC"
Cursor.Current = Cursors.WaitCursor
With Conn
If .State = ConnectionState.Open Then .Close()
.ConnectionString = strConn
.Open()
End With
oleCmd = New OleDbCommand
daPro = New OleDbDataAdapter(sqlTmp, Conn)
daPro.Fill(ds, "testdic")
TextBox1.Text = (ds.Tables("testdic").Rows(0).Item("id_dic"))
TextBox2.Text = (ds.Tables("testdic").Rows(0).Item("read_dic"))
TextBox3.Text = (ds.Tables("testdic").Rows(0).Item("sub_dic"))
TextBox4.Text = (ds.Tables("testdic").Rows(0).Item("content_dic"))
TextBox5.Text = (ds.Tables("testdic").Rows(0).Item("sample_dic"))
soundbox.Text = (ds.Tables("testdic").Rows(0).Item("soundFilename"))
Conn.Close()
asp dropdownlist for access
|
|
|
|
|
por favor alguien puede decirme como cuando pongo el puntero del mouse sobre un grafico(o sea un Graphics que esta dibujado sobre un PictureBox) puedo tomar las Coordenadas X y Y del grafico donde esta el puntero?
Gracias
|
|
|
|
|
Babelfish translation for those who can possibly help...
please somebody can say to me like when I put the leader of mouse on grafico(o is a Graphics that this drawn on a PictureBox) I can take Coordinates X and and of the grafico where this the leader?<br />
<br />
Thanks.
Please post in english if possible.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
(Translation: I'll show you the way, but not write the code for you.)
-- modified at 0:48 Thursday 9th March, 2006
|
|
|
|
|
Somthing like this...
Private Sub PictureBox1_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles PictureBox1.MouseMove
Label1.Text = "X." & e.X & " " & "Y." & e.Y
End Sub
progload
|
|
|
|
|
Hi all,
I am building a online dating site (users may be 200-300 or more). each user can only store upto 5 images. my table structure looks like below
------
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserImage]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UserImage]
GO
CREATE TABLE [dbo].[UserImage] (
[Bits] [image] NULL ,
[Description] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[UserId] [int] NULL ,
[UserImageId] [int] NULL ,
[UploadTime] [datetime] NULL ,
[ImageSize] [int] NULL ,
[Mime] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
------
I just want to know will it have any performance issue when i store images in DB rather than in file and only have a reference to that filename in DB?
I dont want my user to type the URL parameter and do silly stuff such as.
i only want them to type
www.mysite.com
and if they type in URL anything other than that it should take them to
a page saying page not found or sumthing. the reason is.
when i delete image i am getting a parameter from query. like
www.mysite.com/managepictures.aspx?UserId=12&DeleteImgId=4
that means if user passes diff. parameter it will actually delete others image and they can even browse the pic by chaning UserID para.
i dont know how to achieve this
please help
many thanks in forward
Robin
|
|
|
|
|
In general, storing images in a database for this purpose is probably not a good idea. Your database will grow very large over time and become unmanageable (and possibly performance will degrade too).
The better way would be to store the images in the file system and store the path to those images in the database.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
(Translation: I'll show you the way, but not write the code for you.)
|
|
|
|
|
Umm.... haven't you already asked this (or a VERY similar question[^]) before????
PLEASE DON"T POST MULTIPLE TIMES. 
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
(Translation: I'll show you the way, but not write the code for you.)
|
|
|
|
|
you didnt answer my remaining answer.
|
|
|
|
|
No, I didn't.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
(Translation: I'll show you the way, but not write the code for you.)
|
|
|
|
|
so is there any solution to my answer? or shall i just pass the parameter in invisilble label and work it out? but in some cases i need parameter from client end. what should i do about that
|
|
|
|
|
hello
hello i would only to ask anyone of who can solve this problem coz i been using this code datagridview.row.clear() to add a new record but...it shows an error message which is "cannot clear the list coz its data bound" can you help me this problem.....
thanks
|
|
|
|
|
hi there!
i think istead of clearing the datagridview u should clear the dataset and then rebound the gridview.
abhinav
|
|
|
|
|
I am running a procedure in a thread which is created on the click of a button. However, the process does not complete correctly. Please refer to the code below:
Private Sub cmdProcess_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdProcess.Click
Try
Dim tquery As Thread
tquery = New Thread(AddressOf Me.GetData)
tquery.Start()
Catch ex As Exception
MessageBox.Show(ex.Message, "Error In cmdProcess_Click", MessageBoxButtons.OK, MessageBoxIcon.Error)
End Try
End Sub
Private Sub GetData()
Try
Dim field1, field2, op1, period1, value1 As String
Dim m1, y1, tablename As String
period1 = Trim(cmbPeriod.Text)
m1 = Mid(Trim(period1), 5, 2)
y1 = Mid(Trim(period1), 3, 2)
tablename = "SSA" & m1 & y1
field1 = Trim(cmbField1.Text)
value1 = Trim(cmbValue.Text)
op1 = Trim(cmbOP1.Text)
field2 = Trim(cmbField2.Text)
str = "select " & Trim(op1) & "(" & Trim(field2) & ") from " & Trim(tablename) & " group by " & Trim(field1) & " order by " & Trim(field1)
ipcon.Open()
DA = New OleDbDataAdapter(str, ipcon)
DS = New DataSet
DA.Fill(DS, "qrec")
ipcon.Close()
DataGrid1.SetDataBinding(DS, "qrec")
Catch ex As Exception
MessageBox.Show(ex.Message, "Error In GetData", MessageBoxButtons.OK, MessageBoxIcon.Error)
End Try
End Sub
-- This code exits with the following error message 'Controls created on one thread cannot be parented to a control on a different thread'
Please guide me how to resolve this issue.
With Best Regards,
Mayur
|
|
|
|
|
Hello,
I have to create a custom control which consists of a label and an ASP.Net listbox. The control has to have a public property called 'Items' which allows users to add list items to the control's listbox during design time. (much like the Items property of the original vb listbox). I used ListItemsCollectionEditor to show the ListItems Editor window.
However, when the ListItems Editor window appeared and after adding some list items, the listbox did not display the newly added items at all.
A code snippet is given below:
<editorattribute(gettype(system.web.ui.design.webcontrols.listitemscollectioneditor), _
gettype(uitypeeditor))=""> _ //displays the ListItemEditor window
Public ReadOnly Property Items() As ListItemCollection
Get
Return listitems //listitems is a listItemCOllection variable
End Get
End Property
How do I enable the listbox to display the newly added list items?
|
|
|
|
|
Why not use Excel? It has built-in functions to do this and lots more.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once 
(Translation: I'll show you the way, but not write the code for you.)
|
|
|
|
|
<insert snickering sound>
</insert snickering sound>
.. I was waiting for the 'we dont do homework' response from someone
'g'
|
|
|
|
|
Thanks, thats a nice quote. I don't think that i can use excel
|
|
|
|
|
Any other information will be very Helpful!!
Thanks Again
|
|
|
|
|
Do it in Excel then reverse engineer it to code logic... that's what I'd try.
|
|
|
|
|
I have a code that seems to be in Excel but i am a little confused when trying to while transfering it to Visual Basic.
|
|
|
|
|
|
i'm export my favorites links from internet explorer as html file
now i want to import this ( html ) file to tree view on my form
i can read form this file and get folder name and URL but i cann't make it as tree it's now in on level only
i want to read from this file and make tree view in many level
i'm get an example from vbcity but it not complet , this is example from vbcite
http://www.segaal.com/ReadBookmark2.zip
example read HTML file and consider it contain two level but in fact it's contain three level
as this picture
http://www.segaal.com/BookMarks_Level.jpg
pls i want to edit this project to read HTML file in multi Level in tree view as above picture
any one can edit this example to Read BookMarks by multi level in tree view
http://www.segaal.com/ReadBookmark2.zip
thanks for all
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
