|
HELLO, CAN YOU HELP ME ON HOW TO INSERT AN IMAGE INTO A SUBITEM USING CODE ONLY! I AM CREATING A MESSENGER AND I WANT TO INSERT THE CONTACTS PICTURE .. BUT I WANT TO MAKE THE CODE TO INSERT THE PICTURE BY A PATH FOR EXAMPLE: "C:/INDEX.JPEG". HOW CAN I MAKE THIS?? THANKS ALOT!!
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
|
|
|
|
|
Hello,
I am creating a application that can connect any sql server on the network.
The customer would like a dialog box to be able to find a instance of a server, and then enter the password and username to get a list of all the database they want to connect to.
Does anyone have any examples projects in vb.net that does something like this.
I will be most grateful for any code.
Thanks in advance,
Steve
|
|
|
|
|
The .NET Framework 2.0 has the SqlDataSourceEnumerator[^] class to do this for you. It returns a DataTable with the information that you're looking for.
We're not going to write the code for you. You have to take a stab at it first. How else are you going to learn what works and what doesn't?
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
my excel file contains no field headings
when i uploading the data the first row of the excel file become
the field's headings of the dataset.
how to avoid this.
ie.i have to save the first row also to the dataset
|
|
|
|
|
First, don't start a new thread for this. Keep it in your original thread and reply to the poerson who responded to you.
Next, let's see the code you used to import the Excel file. Whatever you did, you told the process to treat the first row as headers.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
hi,
connect the excel with oledb.then
MyCommand = New System.Data.OleDb.OleDbDataAdapter( _
"select * from [Sheet1$]", MyConnection)
ds = New System.Data.DataSet
MyCommand.Fill(ds, "delgrpmember")
For currentRow = 0 To ds.Tables(0).Rows.Count - 1
Dim i As Integer
Dim newRow1 As DataRow = dsExcelExport.Tables("delgrpmember").NewRow()
For i = 0 To colcount - 1
newRow1(i) = ds.Tables(0).Rows(currentRow)(i)
Next
dsExcelExport.Tables("delgrpmember").Rows.Add(newRow1)
Next
daExcelExport.Update(dsExcelExport, "delgrpmember")
In this the first row of the Excel file not contained in the Dataset.I have to import all the used rows including first row to the Dataset.
my Excel file has no headings.
can u help me
|
|
|
|
|
viji] wrote: connect the excel with oledb.then
And the code that you used to do this?? Especially the connection string...
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I press the Enter key the focus jump into next row
How can stop automatic row selection.
Continue...
|
|
|
|
|
hi,
i have uploaded an excel file into a dataset .but it not containing the first row of the excel file.
|
|
|
|
|
That is because the database driver thinks that the first row contains field names. You have to specify somehow that it doesn't. I don't know how, but at least you have something to look for...
---
b { font-weight: normal; }
|
|
|
|
|
hi, this is chandu,
How to generate seriel no. based on date wise ?
if date is changed then no should start from 1,2,3,4,5,....like.
chandu
|
|
|
|
|
Chira Chandra wrote: if date is changed then no should start from 1,2,3,4,5,....like.
You mean yuo want your number to start with the actual date ? I don't understand what your question is. Do you want to append the date to your serial number, or do you want suggestions for an algorithm that creates serial numbers you can then decode to get back a date ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Sir, thank you for ur reply.
Suppose in the database we are having 1 to 10 numbers in the serial number column & date is 24-9-06. If we run the VB application on next day, the date will be 25-9-06. So then the Serial number should start freshly from 1,2,3,4,...like wise. the existing records should end on the day itself. This is my problem. Please give me Code to this concept. I would be thankful to you.
chandu
|
|
|
|
|
Ah - I see.
OK, well, if the numbers are just a sequence of 1,2,3,4 for each date, you want to write a stored proc which does this. It will check for the highest number in the table where the date is today, and then store a new number and return it, the number is one higher.
If you have a table called Serials with two entries, serial as an int and date as a datetime, this will work:
create proc InsertSerial @serial int out
as
begin
select @serial = count(*) from Serials where DATEPART(day, date) = DATEPART(day, GETDATE())
and DATEPART(month, date) = DATEPART(month, GETDATE())
and DATEPART(year, date) = DATEPART(year, GETDATE())
set @serial = @serial + 1
insert into Serials (Serial, Date) values (@serial, GETDATE())
end
I'm not sure if there's another way to compare the date without the time, but I tested this and it works fine.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Thank you sir, for your Immediate reply.
I think the procedure should be created in Oracle. am I correct. But I am using MS-Access 2000. Or shall we write this procedure in VB-6. Please reply.
chandu
|
|
|
|
|
Actually, that was SQL Server 2000. I thought Access supported stored procs nowadays ? You may need to change a few things ,but the general idea should still work.
No, I'm not advocating that you handle this in your VB code, although you could. It just makes more sense to me to do it in the DB.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
I'm developing a program where I have to count a number of print time of a report that's really printing out from a printer. Then I ask for a coding that will update the number of printing to a database(including other value if it have to update) after a user press "ok" from a print dialog.
Thank you,
Little Ducky
|
|
|
|
|
Well, you want to store a number in a database. Do you already have a database ? If not, do you need one for just this task, or will an XML file do ?
Whatever the answer to these questions, the questions that typically get answered here are the ones that show signs of the person asking having been willing to do their own work. At this point, you seem to be asking for someone to write all the code for you ( despite not having provided enough info for anyone to do this ), when what you're asking seems straightforward to me, and only a google away.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
I wrote script to do a force shutdown,reboot,loggof and restart. I was wondering if someone can help with a way how to write some code how to add these choice to a imput box with option buttons and make the reboot the default button.
Thanks in advance
|
|
|
|
|
You can't change the InputBox to support radio buttons, or anything else for that matter. You can either create your own COM-based form in another lanugage or use Internet Explorer as your presentation interface and create a webpage-based form to support more complex input methods, just like any web page with a FORM tag in it.
You'll have to create an HTML file that displays your form, then use something like this to show it:
Set myIE = CreateObject("InternetExplorer.Application")
myIE.Navigate "fully qualified path to myForm.html"
myIE.ToolBar = False
myIE.StatusBar = False
myIE.Resizable = False
Do
Loop While myIE.Busy
myIE.Width = 600
myIE.Height = 800
myIE.Left = 50
myIE.Top = 20
myIE.Visible = True
The InternetExplorer.Application object has a Document property that can be used to get at the various tag contents and fields in your HTML page. The documentation on it is here[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi all
I have question
I have windows application with one form1.vb and class classA.vb ...>
Public Class ClassA
Inherits Form1
Public NameTextBox1 As String
Public Sub New()
NameTextBox1 = "Enter Your Name"
TextBox1.Text = NameTextBox1
End Sub
......
End Class
----------------------
And in form1 I dropedd TextBox1
so I want when I make object from classA
Textbox1 .text changed to "Enter Your Name"
*I have tried to make object in form load and nothing changed
any body know th problem
*I hope I explain my problem clearly
*this sample of my prob
thanks---
AMR-CIS
|
|
|
|
|
amr_CIS wrote: so I want when I make object from classA
Textbox1 .text changed to "Enter Your Name"
It does, but if you don't show the form you won't see it.
---
b { font-weight: normal; }
|
|
|
|
|
how can I solve this problem????
AMR-CIS
|
|
|
|
|
Dim myNewForm As New ClassA
myNewForm.Show()
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Did u test it??
its open new form
I want it in the same from
'''I want solution to this problem plz
'''''I tried in Form1_Load
Dim obj As New ClassA
obj.Refresh() '' didnot work
obj.Update() ''' didnt work
AMR-CIS
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
