|
Sorry for late reply. I will try that.
|
|
|
|
|
hi every body.
I want to ralate two datatables in a dataset then call a quary on that.
please help me how to do that.
i can wrote a realation like this:
ds.Relations.Add(ds.Tables("firstFile").Columns(cmbPercode1.SelectedItem.ToString), _
ds.Tables("SecondFile").Columns(cmbPercode2.SelectedItem.ToString))
please help me . thanks so much.
|
|
|
|
|
Have you *tried* to do a standard SQL SELECT query against the data using the relevant JOIN between on the columns in the two tables?
|
|
|
|
|
I need free dropdown checklist control to b used in .Net 2003.
|
|
|
|
|
I am using VS.net 2005. I hv created reports using 2005 and crystal reportviewer for displaying reports. Report displays fine but it displays very slowly. I mean to say, for a normal rpt where there is no calc also it takes 3 to 4 mins to display. Whereas the display rate is fast as compared to client machine.
Any specific reason about it?
Solution will be highly appreciated.
Thanx
Shailesh
|
|
|
|
|
Does this always happen when opening a report or only the first time?
Reason for asking is that the first time you open a CR the runtime gets loaded and this takes some time (although 3min is very long), after that it should go fast.
Another reason might be your connection.
|
|
|
|
|
Is there a way to use data that is created from a combination of the current DataGridView cell and a math function carried out by vb, to enter the new adhoc data into the cell and refresh the datagridview to reflect this new data combination?
|
|
|
|
|
Most DGV are populated by binding them to an underlying list (List<t> or data table/view) you could add an extra column to the list and populate that column with the results of your function.
How are you populating your DGV.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thank you. In fact that is just what I ended up doing, on the fly so to speak.
Larry
|
|
|
|
|
hi all
pls help
I haved used a VLOOKUP to select the field i require, however i need to select all fields that appear in this column and put them in a table. VLOOKUP will only selects the first cell in the column where this data appears. How can i get it to loop round all of them?
veon
|
|
|
|
|
Use the following code as a starting point ...
totalrows = ActiveSheet.UsedRange.Rows.Count
For i = 1 To totalrows
MsgBox(Sheets("Sheet1").Cells(i, 6))
Next i
|
|
|
|
|
hi thanks a lot for the help
is there anyway to copy the data in sheet1 to a new spreadsheet. hmm its like using a code to create a new spreadsheet and generate the data from sheet1 to it. but it only generate selected column not all column is it possible to do it in excel 2000
thanks
veon
|
|
|
|
|
You need to modify a little, the code snippet that David Mujica gave you
Something like that:
totalrows = ActiveSheet.UsedRange.Rows.Count
For i = 1 To totalrows
'MsgBox(Sheets("Sheet1").Cells(i, 6))
Sheets("Sheet2").Cells(i, 6)=Sheets("Sheet1").Cells(i, 6)
'or whatever
Next i
Shay Noy
|
|
|
|
|
Here is a code snipet to create a new workbook from VBA.
Dim Wk As Workbook
Set Wk = Workbooks.Add
Application.DisplayAlerts = False
Wk.SaveAs Filename:="C:\Temp\demosheet.xls"
|
|
|
|
|
hi thanks again my dear friends =)
can i check with you again the code u given me is to create a new workbook or a new spreadsheet. cause i just need a new spreadsheet will do. thanks =))
veon
|
|
|
|
|
To create a new worksheet you can use:
Sheets.Add
|
|
|
|
|
please tel me how i can make four image with x,y resolution , from the input pic of x*2,y*2 image resolution , so if we consider the input image in four pixel squares (two pixel width and two pixe height) the first of output use the first left pixel of four pixel in the square and the second picture use the right top pixel , third use the bottom right, and the fourth use the left bottom ,
i use the setpixel and getpixel method for it, but it is too slow , i think if i use method of changing the image to array it will be very faster, please tel me ho i use the array method.
this is my code in vb.net but too slow :
For y = 0 To picy.Height - 1 Step 2
j = Int(y / 2)
For x = 0 To picy.Width - 1 Step 2
i = Int(x / 2)
pic(0).SetPixel(i, j, picy.GetPixel(x, y))
pic(1).SetPixel(i, j, picy.GetPixel(x + 1, y))
pic(2).SetPixel(i, j, picy.GetPixel(x + 1, y + 1))
pic(3).SetPixel(i, j, picy.GetPixel(x, y + 1))
Next x
Next y
best regards
|
|
|
|
|
Read my articles on image processing. You will need to use C#.
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,
if all you need the new image for is showing it on screen, you should not spend any time creating such image, just consider using a Graphics.DrawImage with InterpolationMode.NearestNeighbor
to get it completely correct you probably also have to perform a Graphics.Translate() over half a pixel in both x and y!
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Wow - I didn't even read the code to see what he was using it for.
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.
|
|
|
|
|
I'm not sure what his ultimate purpose is, but it looks like a pixelating viewer, maybe an editor.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
this code used for generating four picture from input one, in half resolution of the source image.
this applied to print machines , in micromovement technology for decreasing the print resolution in the paper exposing of the digital printing machines.
it may be used in 9 from one or 16 from one picture.
|
|
|
|
|
Hi,
I have a question, i need to store the value of richtextbox to MySQL and retrive the value from MYSQL to richtextbox. can you give me a code in vb.net? and will the formating be affected like the font and alignment?
Can you please respond quicky?
|
|
|
|
|
evilson wrote: Can you please respond quicky?
No.
I don't get why people say stuff like that. We're not hired to do your job, we do it for free. You can't give us deadlines on that.
It's just data, did you bother to try storing it and retrieving it, before asking this question ? Why on earth would storing and retrieving it cause the formatting to change ?
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.
|
|
|
|
|
Sory about that
I tried it but an error appeared during loading saying type byte cannot convert to string. I dont know what to do next. i already stored the content of the rich text box
this is the full code
<br />
<br />
<br />
Private Sub frmTest_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />
conn = New MySqlConnection()<br />
'connection <br />
myConnString = "connection to server" <br />
conn.ConnectionString = myConnString<br />
conn.Open()<br />
If conn.State = ConnectionState.Closed Then conn.Open()<br />
massDataTable.Clear()<br />
massCommand = New MySqlCommand<br />
massCommand = conn.CreateCommand<br />
massCommand.CommandText = "SELECT * FROM `test` where `mark-1` = 1"<br />
massAdapter.SelectCommand = massCommand<br />
massAdapter.Fill(massDataTable)<br />
With Me<br />
.RichTextBox1.Text = (massDataTable.Rows(0)(1))<br />
End With<br />
End Sub<br />
<br />
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
