|
It doesn't matter where the variables come from, you can still pass them into a paramaterised query. Or do string mashing if you don't care about security.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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")
|
|
|
|
|
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
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.
|
|
|
|
|
Please help me with a piece of code. I cant make it out without help.
Thanks
|
|
|
|
|
Please help me with a piece of code in VB.
Can someone help me on this?
|
|
|
|
|
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
|
|
|
|
|
Can You please elaborate this code a little bit more in VB.net ?
|
|
|
|
|
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
|
|
|
|
|
This isn't the correct forum. You're more likely to get a reply in the ASP.NET forum.
|
|
|
|
|
Thanks, should I just make a new thread in that forum or will this one get moved by an Admin?
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
Thanks for your suggestion.
Will check out.
|
|
|
|
|
Hello Experts,
I seen a software of redgate which name is smartassembly.
Regarding how can i inject dlls with the exe. This Process is also called Dependency Mearging.
Please give me the ideas.
If you can think then I Can.
|
|
|
|
|
What do you want to do exactly ? What is it that you want to achieve ? You want to take dlls that your project uses, and make them part of the exe, so they are not seperate files ? You need to decompile your dlls, if you don't have the source already, and add the source to your main project. A tool would do this by decompiling all the source, and then merging it.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Actually my application have two dlls in which application is dependent. I want to make my application to portable.
So i want to inject those dlls to with my application. i sees a software of redgate (smartassembly). Its works exectly which i want.But i want to use without purchasing any application. This process is called Dependency Mearger in software.
Please give me the technique for doing that.
Thanks
If you can think then I Can.
|
|
|
|
|
Well if you don't want to get your credit card out of your pocket, then you will need to do what Christian has already stated.
|
|
|
|
|
Are u IT Professional.
If you can think then I Can.
|
|
|
|
|
Sorry for the slow reply but needed to go and do some of my own digging on the net.
To answer your question, NO, but you would never guess what i came across, something called google, it must be new, and using it i did work out that there are very few free linkers and obfuscators out there. I did find one though, although their free version is limited to what it can do, and is used via the command line.
I could keep looking for more, but like you I am also busy at work.
Anyway, i will let you get on now, you are obviously very busy trying to find a solution to your problem, and i wouldn't like to take up any more of your time.
Have a nice day
|
|
|
|
|
Actually you don't need to combine everything in one massive executable to make it portable, you just ensure you bundle all dependencies when deploying it to the portable device. .Net is great for that as you just copy the whole folder and ensure you have not coded against fixed paths.
http://portableapps.com/[^] has articles on making applications portable (sorry for no precise link but their site is down at this moment) , and includes a packaging tool.
It will work for .Net apps, however the guys at portableapps.com do not see .Net as a portable language due to the fact that (they say) less than 12% of windows machines can be relied on to have the correct version of the .Net framework, or even any framework. If you are developing in .Net 3.5 you would be really stuck for portability.
However in my experience .Net is reasonably portable.
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
www.JacksonSoft.co.uk
|
|
|
|