i can't get to show data in the report. i even tried with report wizard too. first created a dataset then in the dataset created data table. after this report filed headers are added to the report and when i run report shows only header names but no data.

hello have searched google a lot but couldn't find any. i am trying to create a report in visual studio 2019. data is coming from SQL server and using

reportViewer1

to print the report. can someone show me a good tutorial on it.

hi, i like to build a restaurant billing system. i would be using Visual Studio 2019. language would be C#. my question is regarding printing bills. what is the easiest 3rd party software I can use with Visual Studio 2019 for printing bills to a thermal printer.

kitchen and bar also will be notified. my client having doubts. saying that tablets will hang and slow. currently they are using ipads and running the application by remote desktop. billing system is installed in a PC and waiters are using ipads via remote desktop to make entries. at the moment they are facing lot of problems. every now and then their ipads remote access connections gets disconnected. and sometimes even wifi connections are getting lost. so, i proposed my methodology(explained in the original post). but my client having doubts. saying tablets will face same issue as ipads.

my client having doubts. saying that tablets will hang and slow. currently they are using ipads and running the application by remote desktop. billing system is installed in a PC and waiters are using ipads via remote desktop to make entries. at the moment they are facing lot of problems. every now and then their ipads remote access connections gets disconnected. and sometimes even wifi connections are getting lost. so, i proposed my methodology(explained in the original post). but my client having doubts. saying tablets will face same issue as ipads.

i am thinking of developing a restaurant billing system.

here is how my set up going to be.

1 desktop PC(SQLServer) to run SQL server. OS windows server.
2 desktop PCs(Cashier1,Cashier2) for cashiers.

SQLServer, Cashier1 and Cashier2 will be connected to local network(wired)

5 Tablet for waiters to take orders (enter orders to SQLServer). These Tablets will have wifi connections to enter customer orders into SQLServer

bills will be printed from Cashier1 and Cashier2

5 Tablets will be using unique user logins to take orders.

now my question is. will it be too slow or the system will hang when staffs use tablets to take orders?

have clicked the green arrow :)

Thank you. I copied the dll I was referring to but it didn’t work. Then I copied all the dll (5 or 6 files I think). Once I copied all those dlls now it is working.

i am using a windows application to connect to a finger print scanning device.

at the moment i can connect to machine and download all the logs. (using this DLL Interop.zkemkeeper.dll)

from my PC, windows 7 32bit it is working but when i installed the application on windows server 2003
32bit i am not able to connect to reader.

i installed visual studio 2010 on server and tried to build the Application on the server to make sure no reference were missing.

but still i can not connect to the reader.

my question is why it connects and can even downloads all the logs from my pc but it doesnt work on server (windows server 2003 32bit)

reader IP 192.168.0.1 port: 4370.

Public axCZKEM1 As New zkemkeeper.CZKEM

code to connect to reader:
private sub ConnectToReader()
If txtIP.Text.Trim() = "" Or txtPort.Text.Trim() = "" Then
MsgBox("IP and Port cannot be null", MsgBoxStyle.Exclamation, "Error")
Return
End If
Dim idwErrorCode As Integer
Cursor = Cursors.WaitCursor
If btnConnect.Text = "Disconnect" Then
AxCZKEM1.Disconnect()
bIsConnected = False
btnConnect.Text = "Connect"
lblState.Text = "Current State:Disconnected"
Cursor = Cursors.Default
Return
End If

    bIsConnected = AxCZKEM1.Connect\_Net(txtIP.Text.Trim(), Convert.ToInt32(txtPort.Text.Trim()))
    If bIsConnected = True Then
        btnConnect.Text = "Disconnect"
        btnConnect.Refresh()
        lblState.Text = "Current State:Connected"
        iMachineNumber = 1
        axCZKEM1.RegEvent(iMachineNumber, 65535)
    Else
        AxCZKEM1.GetLastError(idwErrorCode)
        MsgBox("Unable to connect the device,ErrorCode=" & idwErrorCode, MsgBoxStyle.Exclamation, "Error")
    End If
    Cursor = Cursors.Default

End Sub

i have managed to do it. but really appreciate that you have explained so well and gave code too. hopefully some other user will find it useful. thank you.

how can I make all the dates thats coming from the database as bold in the calendar?

Dim DateAsString As New ArrayList this is the part i am using in form load to get all the dates for the Meeting. private sub getalldate() Dim connectionString As String = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDB;Data Source=192.168.0.8" Dim connection As SqlConnection = New SqlConnection(connectionString) connection.Open() Dim sql As String = "SELECT MeetingDate FROM Meetings" Dim command As SqlCommand = New SqlCommand(sql, connection) Dim reader As SqlDataReader = command.ExecuteReader() If (reader.Read()) Then If (reader.HasRows) Then While reader.Read() dateasstring.Add("#" & reader(0) & "#") End While End If End If reader.Close() connection.Close() end sub private sub makedatesboldincalendar() Dim num As Date Dim dtArrSpecialDates() As Date For Each num In dateasstring dtArrSpecialDates = {num} MonthCalendar1.BoldedDates = dtArrSpecialDates Next end sub what happens is it makes date bold but only the last date it is getting from database. there are more than 10 entries in the Meetings table. so, how can i highligh all the dates i am getting from database?

hi, i am trying to download data from fingerprint device. below is the code provided by them in their demo application(vb). with the code provided by them i can connect to device successfully but i am not getting correct data.

Private Sub btnGetGeneralLogData_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetGeneralLogData.Click
If bIsConnected = False Then
MsgBox("Please connect the device first", MsgBoxStyle.Exclamation, "Error")
Return
End If

    Dim idwTMachineNumber As Integer
    Dim idwEnrollNumber As Integer
    Dim idwEMachineNumber As Integer
    Dim idwVerifyMode As Integer
    Dim idwInOutMode As Integer
    Dim idwYear As Integer
    Dim idwMonth As Integer
    Dim idwDay As Integer
    Dim idwHour As Integer
    Dim idwMinute As Integer

    Dim idwErrorCode As Integer
    Dim iGLCount = 0
    Dim lvItem As New ListViewItem("Items", 0)

    Cursor = Cursors.WaitCursor
    lvLogs.Items.Clear()
    AxCZKEM1.EnableDevice(iMachineNumber, False) 'disable the device
    If AxCZKEM1.ReadGeneralLogData(iMachineNumber) Then 'read all the attendance records to the memory
        'get records from the memory
        While AxCZKEM1.GetGeneralLogData(iMachineNumber, idwTMachineNumber, idwEnrollNumber, idwEMachineNumber, idwVerifyMode, idwInOutMode, idwYear, idwMonth, idwDay, idwHour, idwMinute)
            iGLCount += 1
            lvItem = lvLogs.Items.Add(iGLCount.ToString())
            lvItem.SubItems.Add(idwEnrollNumber.ToString())
            lvItem.SubItems.Add(idwVerifyMode.ToString())
            lvItem.SubItems.Add(idwInOutMode.ToString())
            lvItem.SubItems.Add(idwYear.ToString() & "-" + idwMonth.ToString() & "-" & idwDay.ToString() & " " & idwHour.ToString() & ":" & idwMinute.ToString())
        End While
    Else
        Cursor = Cursors.Default
        AxCZKEM1.GetLastError(idwErrorCode)
        If idwErrorCode <> 0 Then
            MsgBox("Reading data from terminal failed,ErrorCode: " & idwErrorCode, MsgBoxStyle.Exclamation, "Error")
        Else
            MsgBox("No data from terminal returns!", MsgBoxStyle.Exclamation, "Error")
        End If
    End If

    AxCZKEM1.EnableDevice(iMachineNumber, True) 'enable the device
    Cursor = Cursors.Default
End Sub

thank you all

SELECT * FROM DeviceLogs GROUP BY LogDate this gives me error "because it is not contained in either an aggregate function or the GROUP BY clause"

then is selects just a single record. i want records of all users to be selected but without repeating. if userid 1 has more than one log then just select earliest record for user id 1 and ignore other records for him.

I have the following SQL table, ID LogDate Name Department ----------------------------------------------- 1 3/26/2015 7:55 AM Adam HR 2 3/26/2015 7:53 AM Tony Fin 3 3/26/2015 7:59 AM Mark Mang 1 3/26/2015 8:15 AM Adam HR 3 3/26/2015 8:10 AM Mark Mang 2 3/26/2015 7:53 AM Tony Fin i like to get this output ID LogDate Name Department ------------------------------------------------- 2 3/26/2015 7:53 AM Tony Fin 1 3/26/2015 7:55 AM Adam HR 3 3/26/2015 7:59 AM Mark Mang i want to get a single record for each user ordered by min LogDate. my table name is "DeviceLogs"

does anyone know how to check whether someone is a fan of a facebook page.

i have following datalist in WhatsNews.aspx page. <asp:datalist id="DL1" runat="server" ItemStyle-BorderColor="#c7c7c6" CssClass="HomePageTitles"> <ItemTemplate> <asp:HyperLink Runat ="server" Target="_Parent" NavigateUrl ='<%#"page.aspx?id=" + DataBinder.Eval(Container.DataItem, "NewsArticleID").ToString()%>' ID="Hyperlink1"> <%#DataBinder.Eval(Container.DataItem, "NewsArticleTitle")%> </asp:HyperLink> </ItemTemplate> <AlternatingItemStyle BackColor="#FFFFFF" /> <ItemStyle BackColor="#e7e3e3" BorderColor="#e7e3e3" /> </asp:datalist> in above code i am setting to open the links in parent window. and in home page i am adding WhatsNew.aspx using iframe. <iframe frameborder="0" marginheight="1" marginwidth="1" hspace="1" width="390" height="450px" scrolling="no" src="WhatsNew.aspx"></iframe> when i open home page and click a link in whatsnew section, IE 8 opening the links in a new window. but firefox 3.5.7 opens in parant window, just like i want. how can i make IE 8 also open the links in parent window?

i like to display report names in a data list and when the user clicks open the corresponding PDF file. all the reports are in PDF format. Report 1 Report 2 Report 3 Report 4 Report 5 how can i do this? i am saving pdf files path in database(http://www.mysite.com/reports/Report1.pdf) my current code shows the report name but when i click it doesn't go anywhere. <asp:datalist id="DL1" runat="server" ItemStyle-BackColor="#c7c7c6" ItemStyle-BorderColor="#c7c7c6" CssClass="Titles"> <ItemTemplate> <asp:HyperLink Runat ="server" NavigateUrl ='<%#DataBinder.Eval(Container.DataItem, "ReportURL")%>' ID="Hyperlink1"> <%#DataBinder.Eval(Container.DataItem, "ReportName")%> </asp:HyperLink> </ItemTemplate> </asp:datalist> code behind Private Sub GetReports() Dim objConnection As SqlConnection = New _ SqlConnection(ConfigurationManager.ConnectionStrings("MyDbConn").ToString()) objConnection.Open() Dim myCommand As New System.Data.SqlClient.SqlCommand() myCommand.Connection = objConnection myCommand.CommandText = "SelectReports" myCommand.CommandType = CommandType.StoredProcedure Dim param As New System.Data.SqlClient.SqlParameter() Dim myAdapter As New SqlDataAdapter(myCommand) myAdapter.Fill(DataSetReports) Dim reader As SqlDataReader = myCommand.ExecuteReader() DL1.DataSource = DataSetReports DL1.DataBind() objConnection.Close() End Sub

modified on Monday, January 25, 2010 1:21 AM