Visual Basic

3-Nov-09 5:34

Hi,
I have a datagridview1 column "Name", which has collections of names and some are repetitive; e.g.
"Name"
-------
ram
shyam
ram
ram
raj
shuk
shuk

So, in the above "Name" column, there are repeatation of names. I want to do this:

1) read the repetitive name as a single, e.g. "ram", "shuk"
2) store them in a array of string;
3) finally the array should be like this : arr(1) = "ram", arr(2) = "shyam", arr(3)="raj",arr(4)="shuk" .

So in arrays I have finally stored the repetitive names as once.

Now I want to copy these array entries into rows of another datagridview2 whose column name is "Final Name".

Can someone help me by providing a piece of code?

Thanks
R.S.

Md. Marufuzzaman3-Nov-09 6:20

Md. Marufuzzaman

3-Nov-09 6:20

Please let me know the data source. Do you execute any transact sql statement?

Thanks
Md. Marufuzzaman

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

jeshra2793-Nov-09 6:26

3-Nov-09 6:26

No I have not executed any transact sql statement.
My code is like this :

cmd = New SqlCommand("Select * FROM student_details", con)

If con.State = ConnectionState.Closed Then con.Open()

myDA = New SqlDataAdapter(cmd)

Dim myDataFillSet As New DataSet()

myDA.Fill(myDataFillSet, "student_details")

Md. Marufuzzaman3-Nov-09 6:56

Md. Marufuzzaman

3-Nov-09 6:56

jeshra279 wrote:
No I have not executed any transact sql statement.
My code is like this :

cmd = New SqlCommand("Select * FROM student_details", con)

If con.State = ConnectionState.Closed Then con.Open()

I think you are using... whatever .. update the SQL statement by using SQL JOIN.

Thanks
Md. Marufuzzaman

jeshra2795-Nov-09 22:16

5-Nov-09 22:16

Please help me with a piece of code. I cant make it out without help.

Thanks

jeshra2793-Nov-09 17:28

3-Nov-09 17:28

Please help me with a piece of code in VB.
Can someone help me on this?

Andy_L_J3-Nov-09 17:56

Andy_L_J

3-Nov-09 17:56

You ARE using a query to get the original data, just run another query to get The DISTINCT name values.

SELECT DISTINCT(StudentName) FROM Student_Details ...

I don't speak Idiot - please talk slowly and clearly

'This space for rent'

Driven to the arms of Heineken by the wife

jeshra2794-Nov-09 0:04

WRONG FORUM-Moved to ASP.NET-Help with SQL Database and ASPX Page [modified]

4-Nov-09 0:04

Can You please elaborate this code a little bit more in VB.net ?

mavrik51503-Nov-09 5:34

mavrik5150

3-Nov-09 5:34

I hope this is the right area, but I was working on this project and I'm a little stuck and wanted to know if I get can some help. We have a page in our site that we just added that allows some of our customers to add new users to their programs by filling out a form and submitting it, all of the fields are saved in a Database and used to create the agent record and fill out those fields in there. But before the agent can be added there is a four part review that needs to take place and within each step there's different options for approval/decline/more information. Here's my problem, or where I'm stuck:

How to you get a table to have it's own buttons that correspond to each row of a database. If I use the GridView I'm stuck using only the buttons they allow (such as the Edit button and Delete button) but I wanted to have a View button that would either open a PDF File or Pop Up window displaying all of the information entered on the form that's stored in a Database. I would also want a button that could be used to either Approve (which would update the Status field in the Database to the next step) or Decline (which will allow the reviewer to enter a message that can be seen in the Notes section of the Table and Database).

I was thinking that maybe a JavaScript type table could be used, this way the table can expand to show the documents if they click a button and there may be a time where supporting documents could be added to a user but I don't know how that will play into the design of this area. I don't know if I'm looking in the right area or if I should be looking at something else, since I've been having trouble with the Gridview in Visual Studio 2005, or maybe it is possible and I just don't know how to set it up correctly. Thanks.

modified on Tuesday, November 3, 2009 12:33 PM

Re: Help with SQL Database and ASPX Page

Jay Royall3-Nov-09 5:52

Jay Royall

3-Nov-09 5:52

This isn't the correct forum. You're more likely to get a reply in the ASP.NET forum.

Re: Help with SQL Database and ASPX Page

mavrik51503-Nov-09 6:00

mavrik5150

3-Nov-09 6:00

Thanks, should I just make a new thread in that forum or will this one get moved by an Admin?

Re: Help with SQL Database and ASPX Page

Jay Royall3-Nov-09 6:10

Jay Royall

3-Nov-09 6:10

I'm not entirely sure whether admin will move it or not. What I would do is modify the title of your post here to make people aware that it is the wrong forum and then re-post in the ASP.NET forum.

Get Published Version Number

vijay24823-Nov-09 1:55

vijay2482

3-Nov-09 1:55

Hi all,

Thanks to all who have replied to my earlier posts.

I have an application, that is published on the server.
I want to display the published version number during FormLoad event.
I used the below code:

The version displayed is '0' insted, the version on the server is '13'.
Is there some other way to get the version of the application that the enduser is using?

Thanks in Advance.

modified 28-Nov-12 7:39am.

DaveAuld3-Nov-09 2:46

DaveAuld

3-Nov-09 2:46

Can you clarify your problem,

Do you mean you are using a different application to try and determine the file version information of another applications exe?

or are you looking for code for the application to display its own file version to the user, if for example they click about?

Its just that your code above is pointing to an HTML file which from my experience will not have file information embedded.

If the html content contains details about your application, then you would have to read the contents of the file and parse out the version data contained within.

Dave
Who am I?:
Web|Facebook|Twitter|LinkedIn|Bebo

vijay24823-Nov-09 2:50

vijay2482

3-Nov-09 2:50

Hi,

Thanks for your reply.
I'm looking for a code that displays its own application version.
The application is published on the server, the users install the application from the server.
When their is an update on the application, the updated version is available to the user but the version number that the user is using is not know to them.
So I would want a message box to display the version.

DaveAuld3-Nov-09 3:01

DaveAuld

3-Nov-09 3:01

Ah, ok,

Look at My.Application.Info there you will find various properties. Also there is more under My.Application.Deployment where you will find, CurrentVersion and UpdatedVersion that can be used for various upgrade scenarios.

Cheers,
dave

Dave
Who am I?:
Web|Facebook|Twitter|LinkedIn|Bebo