|
softdev_sup wrote: I want to create report writer (user can create reports on run time by selecting field)
in VS 2008 / 2005 by using SQL Server on Back end and crystal report or any other report writer for reporting
Is a statement, not a question. So go ahead and let us know the outcome.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
any guidlines
|
|
|
|
|
Ask your user to go for MS or Crystal Report training...
|
|
|
|
|
|
Seriously, what you are asking (letting user create whichever kind of report they like) has been asked by many users years before. But the fact remains that creating a report requires knowledge of database and the schema of that system, and the knowledge of the reporting engine/IDE, which generally need a developer.
Unless you are talking about "prefixed" dynamic report, where user choose the columns from a pre-defined list.
|
|
|
|
|
Yes i Want actually a very simple report writer where a user can make his own desire reports on run time , i know their are Discrepancies but still wanna do it bcz of some requirements
Best of regards,
SOFTDEV
|
|
|
|
|
softdev_sup wrote: any guidlines
Several, take your pick;
* The guidelines on UI-design alone amount to a whopping 38 mb (850 pages) and can be found here[^].
* The guidelines for designing a class-library can be found here[^].
* The coding guidelines of Brad Abrams can be found here[^].
Your question is too broad to give a more specific answer.
"Walking on water and developing software from a specification are easy if both are frozen." -Edward V Berard
|
|
|
|
|
thank you so much so nice of u
|
|
|
|
|
Hi all,Are there any application running in recovery console mode ???
And how can we run the native using api application in recovery console mode.
|
|
|
|
|
AFAIK, you can't run any applications in the Recovery Console. You're limited to what the Command Prompt provides.
|
|
|
|
|
That's not possible since the .NET Framework isn't loaded when Windows starts in the recovery console.
You'll have to write in a language that compiles to native code.
|
|
|
|
|
Hi all
I am using vs2005 and windows form
I want add a control inside the datagridview's (windows control ) cell
I dont find any method similar to gridview webcontrol's
gridview.rows[0].cells[0].controls.add()
anyone can post the code snippet for this
thanx a lot
|
|
|
|
|
Take a look at DataGridView Custom Column Sample[^] from MSDN.
Or This article[^] from Code Magazine.
If neither of these is quite right, I found them and loads more by Googling custom datagridviewcolumn
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Hi,
I try to export datagrid data to one excel spread sheet (i called it ExcelA).
Then, when I want to close ExcelA, I wrote this codes to kill excel.exe.
wExcel.Quit()
System.Runtime.InteropServices.Marshal.ReleaseComObject(wExcel)
System.GC.Collect()
Dim proc As System.Diagnostics.Process
For Each proc In System.Diagnostics.Process.GetProcessesByName("EXCEL")
proc.Kill()
Next
wExcel = Nothing
But then, it killed all the excel that I currently open. (those that are not related to this ExcelA.)
How can i only kill the excel.exe that belonging to this ExcelA ?
Please help. I had tried to search.. but failed to get it.
Thanks in advanced. Appreciate your help.
Here is my codes:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
ds.Clear()
ds.Tables.Add()
If ds.Tables(0).Columns.Count <= 0 Then
For i As Integer = 0 To myTable.Columns.Count - 1
ds.Tables(0).Columns.Add(myTable.Columns(i).ColumnName)
Next
End If
Dim dr1 As DataRow
For k As Integer = 0 To myTable.Rows.Count - 1
dr1 = ds.Tables(0).NewRow
For j As Integer = 0 To myTable.Columns.Count - 1
dr1(j) = dgSearch.Item(k, j)
Next
ds.Tables(0).Rows.Add(dr1)
Next
Dim wExcel As New Excel.ApplicationClass
Dim wBook As Excel.Workbook
Dim wSheet As Excel.Worksheet
wBook = wExcel.Workbooks.Add()
wSheet = wBook.ActiveSheet()
Dim dt As System.Data.DataTable = ds.Tables(0)
Dim dc As System.Data.DataColumn
Dim dr As System.Data.DataRow
Dim colIndex As Integer = 0
Dim rowIndex As Integer = 0
For Each dc In dt.Columns
colIndex = colIndex + 1
wExcel.Cells(1, colIndex) = dc.ColumnName
Next
For Each dr In dt.Rows
rowIndex = rowIndex + 1
colIndex = 0
For Each dc In dt.Columns
colIndex = colIndex + 1
wExcel.Cells(rowIndex + 1, colIndex) = dr(dc.ColumnName)
Next
Next
wSheet.Columns.AutoFit()
Dim strFileName As String = "C:\M2.xls"
Dim blnFileOpen As Boolean = False
Try
Dim fileTemp As System.IO.FileStream = System.IO.File.OpenWrite(strFileName)
fileTemp.Close()
Catch ex As Exception
blnFileOpen = False
End Try
If System.IO.File.Exists(strFileName) Then
System.IO.File.Delete(strFileName)
End If
Try
wBook.SaveAs(strFileName)
wExcel.Workbooks.Open(strFileName)
wExcel.Visible = True
Catch ex As Exception
MsgBox(ex)
Finally
' MsgBox("closing now")
End Try
End Sub
Private Sub Excel_WorkbookBeforeClose(ByVal wBook As Excel.Workbook, ByRef Cancel As Boolean) Handles wExcel.WorkbookBeforeClose
wExcel.Quit()
System.Runtime.InteropServices.Marshal.ReleaseComObject(wExcel)
System.GC.Collect()
Dim proc As System.Diagnostics.Process
For Each proc In System.Diagnostics.Process.GetProcessesByName("EXCEL")
proc.Kill()
Next
wExcel = Nothing
End Sub
|
|
|
|
|
Try using environment.exit(exitcode) in the workbook close event.
|
|
|
|
|
Hi ,
I would like to edit 2 columns in datagrid. How can i do that?
I know dgSearch.ReadOnly = False, is to be able to edit all columns.
But now i only want certain columns only.
How should I go about?
Please help and guide me. Thanks in advanced.
regards,
eunice
|
|
|
|
|
You need the DataGridViewColumn.ReadOnly property. MSDN[^]
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Hi All,
I am loading usercontrols inside form(Pannel).Upon click on button on usercontrol it opens popup(form) which minimizing the toplevel form. The pop up should open above Toplevel form. Any idea please help.
I tried by setting TopMost property to true but no luck.
Many Thanks,
Sri
|
|
|
|
|
Try to set this property after displayed by Show() method. That usually fixes it.
|
|
|
|
|
Hello,
Thanks for the reply. Which property i need to set.
Regards,
Sri
|
|
|
|
|
Same TopMost like below.
Dim f As New Form2
f.TopMost = True
f.Show()
Me.TopMost = True
|
|
|
|
|
i dont think so it will work in MDI i have same problem also
if i put one control box or any other container control on MDI form then the child form goes back
|
|
|
|
|
Hi All,
After loading form loosing focus. I tried by setting focus in "Deactivate" and "LostFocus" event of form but no luck. Form loosing focus after 5-10 sec(After loading).
Many Thanks,
Sri
|
|
|
|
|
Please provide some code for what exactly you are doing on load, Deactivate and LostFocus events.
|
|
|
|
|
Hi All,
I have a Win Form on which I use the KeyDown event to perform certain activities using Alt-Key combinations.
Unfortunately, this also triggers the menustrip 'capturing' the Alt key and highlighting the default menu item ('File') and essentially disabling any further typing until the Alt key is pressed again.
Is there any way to stop the file menu from capturing the Alt when this is used to trigger operations in the KeyDown event?
Thanks,
Sri
|
|
|
|