|
You need to convert the cell to 'Text' format and not 'General'. By default excel will automatically exclude leading Zero's in a 'General' Formatted Cell!
Highlight the whole column and right click, select 'Format cells' and change the format to 'Text'.
Hope this helps.
Gary
|
|
|
|
|
Even if I convert the cell to TEXT, the result is the same.
With Best Regards,
Mayur
|
|
|
|
|
It Will be!
You need to use the import wizard in excel and select the cell type to be text.
If you load the file then try changing the column to text it will not do anything, as the leading zero's have already been taken out.
|
|
|
|
|
I have an XML file which I am reading throuh XMLTextReader. Now instead of traversing every element of XML , I just want to retrieve value of a particular start element. This start element is occusring many times in XML file .
How can i retrieve value of only this start element in full XML ? Any suggestions ??
Divya Rathi
|
|
|
|
|
Try Looping the required statement with Instr() function
|
|
|
|
|
Hi to all,
I'm trying to develop a query tool. Actually I want to run query like:
SELECT * FROM MyTable WHERE MyField = :variable 
The problem is that I don't know at the time of running the query, which query is and how many parameters I have.
I understood I have to use the Command.Parameters collection, but I'm still looking for some snippets because I didn't found so many examples.
Any suggestion are appreciated. 
|
|
|
|
|
I don't understand what you are aiming for here.
Can you explain a little more?
What database server are you using?
What is the purpose of this?
If you can then i will try to help
"If i was king cigarettes would be free."
|
|
|
|
|
Hi,
Does anyone know of a good demo project or article on simply drawing a rectangle with the mouse over an image? (It's for a small app I want to create to resize an image). I've looked around but can't find anything to get me started... I guess it's some GDI+ stuff I need to do but am not sure.
Ideally the rectangle would be able to be resized after it was drawn (a la Photoshop etc) but I can live without that if I have to.
Any tips or pointers on how/where to get started would be appreciated.
TIA...
Mike
|
|
|
|
|
Hello
Here is the code how to draw a rectangle on a picture box named picmain:
Dim startX As Integer<br />
Dim StartY As Integer<br />
<br />
Private Sub picmain_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles picmain.MouseMove<br />
If e.Button = MouseButtons.Left Then<br />
picmain.Refresh()<br />
Dim g As Graphics = Graphics.FromHwnd(picmain.Handle)<br />
Dim myPen As Pen = New Pen(Color.Red)<br />
myPen.DashStyle = System.Drawing.Drawing2D.DashStyle.Dash<br />
g.DrawRectangle(myPen, startX, StartY, Math.Abs(startX - e.X), Math.Abs(StartY - e.Y))<br />
End If<br />
End Sub<br />
<br />
Private Sub picmain_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles picmain.MouseDown<br />
startX = e.X<br />
StartY = e.Y<br />
End Sub
The resizing will be up to you.
Hope it helps
|
|
|
|
|
if you swap this line
g.DrawRectangle(myPen, startX, StartY, Math.Abs(startX - e.X), Math.Abs(StartY - e.Y))
with
If e.X < startX And e.Y < StartY Then
g.DrawRectangle(myPen, e.X, e.Y, Math.Abs(startX - e.X), Math.Abs(StartY - e.Y))
ElseIf e.X > startX And e.Y < StartY Then
g.DrawRectangle(myPen, startX, e.Y, Math.Abs(e.X - startX), Math.Abs(e.Y - StartY))
ElseIf e.X < startX And e.Y > StartY Then
g.DrawRectangle(myPen, e.X, StartY, Math.Abs(e.X - startX), Math.Abs(e.Y - StartY))
Else
g.DrawRectangle(myPen, startX, StartY, Math.Abs(startX - e.X), Math.Abs(StartY - e.Y))
End If
then you can draw the rectangle in any direction
"If i was king cigarettes would be free."
-- modified at 10:43 Thursday 23rd March, 2006
|
|
|
|
|
Thanks so much guys - that was exactly what I wanted!! I did get started with code very similiar but couldn't work out how to not draw every rectangle (instead of the just the current one) and also hadn't got it to work from any direction so I'm grateful for both tips.
Cheers,
Mike
|
|
|
|
|
How am i to display an image in a gatagrid from the SQL Server where the image is stored in the IMAGE field as byte()... I've found the way to convert it back to image form but how am i to dsplay it in the last column...
|
|
|
|
|
|
Thank you for the link sir but i donot want a querystring to be passed neither do want a reference pointer to the image i am using
"select * from tablename"
and want to convert the byte array to image at the 4th column in the table and insert the image to the same column but the conversion is done to a System.Drawing.Bitmap and not being displayed in the grid...
|
|
|
|
|
in vb 6 there is a mschart object
but in .net cant seem to find one
where do i start to be able to create a chart
ty in advance
maytel
|
|
|
|
|
Search it in the COM component section
Right click the tool box
Select Add/Remove components.
Select the COM components tab
Chatura from Pearl of the Indian Ocean.
|
|
|
|
|
|
ill look into it tnx
-- modified at 1:38 Thursday 23rd March, 2006
|
|
|
|
|
Here's another free .NET chart control. The charts look great, comes with plenty of examples, it's very stable, and development/support is active.
I highly recommend it.
http://zedgraph.org[^]
|
|
|
|
|
Hi!
in my below code how can i instantiate webchart webcontrol so that i get each dataview binded to seperate webchart.
say webchart1 will hold one dataview, webchart2 will hold another dataview and so on...
currently i only have datagrid1 webcontrol(eventually that datagrid will be replaced by some charting tool) which only picks the last dataview in loop. i actually would like to pick each chunk of data and populate seperate web chart.
for eg.
-----------------------
objConn = New SqlConnection(dbPath)
Try
'select the table with only distinct ID based
cmd = New SqlCommand("select distinct measure_id from measuredata m, textdata t where t.ScoreCardId = m.ScoreCardId", objConn)
Dim da As SqlDataAdapter = New SqlDataAdapter(cmd)
Dim dtId As New DataTable("MeasureId")
da.Fill(dtId)
'select all columns with ID
Dim cmd1 As SqlCommand = New SqlCommand("select * from measureData", objConn)
Dim da1 As SqlDataAdapter = New SqlDataAdapter(cmd1)
Dim dt As New DataTable("MeasureSource")
da1.Fill(dt)
Dim myView As New DataView(dt)
Dim datarow As DataRow
For Each datarow In dtId.Rows
myView.RowFilter = String.Format("Measure_Id='{0}'", datarow.Item("measure_Id"))
'######## checking if the dataview works #########
MycosChartWeb1.DataSource = myView
MycosChartWeb1.DataBind()
Next datarow
Catch ex As Exception
Response.Write("OOPs what went wrong:" + ex.ToString)
Finally
End Try
------------------------------
hope my question makes sense for what i wanna achieve.
please help thanks
robin
|
|
|
|
|
Hi,
I have an aspx file to generate a report for user. Users can print this report out from browser. But I found that there are page number, date and url on each page's header and footer. There's no way to remove these information except ActiveX. I cannot use ActiveX because activex requires user to enable it which is annoying.
So I'm wondering if I can convert my existing aspx file into PDF and display this PDF file in brower. I did a lot of search, all I can get is how to convert a HTML file into PDF, which wont work in my case.
Can anybody help me here?
|
|
|
|
|
An aspx file is not able to be viewed until it is a html file. So, the answer is no.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Thank you for your reply. But html cannot generate report dynamically.
All I need is to generate a dynamic report in an aspx file that user can print it out without page header and footer.
Any idea?
-- modified at 18:06 Wednesday 22nd March, 2006
|
|
|
|
|
Your report should be generated by your middle tier anyhow. Return it as a bitmap and turn that into a pdf.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Could you give me some more details?
My report has many pages, I generated each page in one user control, then insert these user controls into an aspx file. When user open this page, he will see a whole report.
Actually, we can just say that I have a web page writen by vb.net, how can I convert this page into pdf.
Thanks.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
