• Member Avatar for xrjf
    xrjf

    Began Watching sql query to fill listview

    Please help on this one: SELECT Format([expr1],"# %") AS expr2, totvisit/totrem AS expr1 FROM ( SELECT Count(*) AS totrem FROM ( SELECT DISTINCT remid FROM remtable WHERE remtable.pacid = 94) …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in Drag and Drop between DGV's - how to determine the source DGV?

    dim dgv as datagridview = DirectCast(sender,DatagridView) if dgv.name = "..." then
  • Member Avatar for xrjf
    xrjf

    Began Watching Drag and Drop between DGV's - how to determine the source DGV?

    Hi, I have a DGV (dgvListOfJobs), populated from an SQL database to show the user a list of 'jobs' (i.e. rows). I also show 7 other DGV's (dgvMonday, dgvTuesday, etc) …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in VB.Net How to rotate a rectangle by mouse click and drag

    Just to rotate in both directions: Private Sub rotatingRectangle_Paint(sender As Object, e As System.Windows.Forms.PaintEventArgs) Handles Me.Paint Try Dim alpha As Double Static oldSign As Int32 = -1 Static oldSign2 As …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in VB.Net How to rotate a rectangle by mouse click and drag

    A briefer and improved version to rotate the image: Private Sub rotatingRectangle_Paint(sender As Object, e As System.Windows.Forms.PaintEventArgs) Handles Me.Paint Try Dim alpha As Double If bDrag Then If oldpos.X = …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in How to Generate Auto Invoice Number

    I think string should be converted in numeric, say `Format(CStr(Mid(dr, 2, 6)) + 1, "E00000#")` or `Format(CInt(Mid(dr, 2, 6)) + 1, "E00000#")`
  • Member Avatar for xrjf
    xrjf

    Began Watching How to Generate Auto Invoice Number

    Sub generate_inv() Dim id_tmp As String Query = "select top 1 InoviceNo from Invoice order by InoviceNo desc" cmd = New OleDbCommand(query, cn) dr = cmd.ExecuteReader If dr.HasRows = False …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in create sql table from listbox selected item/'Incorrect syntax near '3142'.'

    I don't know exactly what is your code, but perhaps you could call createTable() passing the selected index as argument: Sub createTable(selectedIndex As Int32) Dim n As Int32 = 200 …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in VB.Net How to rotate a rectangle by mouse click and drag

    Here the image rotates while dragging around the center clockwise or not, although when the mouse moves horizontally the spinning slows. A workaround could be to spin just in one …
  • Member Avatar for xrjf
    xrjf

    Began Watching VB.Net How to rotate a rectangle by mouse click and drag

    I'm using Winforms with a picturebox and a custom rectangle drawn on it (face detection). Now I have code the draws the rectangle on the specified coordinates, allows resizing and …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in create sql table from listbox selected item/'Incorrect syntax near '3142'.'

    Sorry, `rnd` should be an instance of `Random` class: dim rnd as new Random()
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in create sql table from listbox selected item/'Incorrect syntax near '3142'.'

    I guess the table names are being repeated, to avoid this problem you may set the 200 numbers, firstly ordered in `vinte`and then reorder randomly: Dim n As Int32 = …
  • Member Avatar for xrjf
    xrjf

    Began Watching create sql table from listbox selected item/'Incorrect syntax near '3142'.'

    Hi all I'm creating a warehouse management system, then i want when new orders are created, a customer's name be selected from a list box and that customer's selected name …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in how to set datagridview's row number form textbox? c#

    There is missing a catch instruction after line #15: catch { }
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in how to set datagridview's row number form textbox? c#

    Why do you create a new instance of DataGridView in `DataGridView dataGridView10 = new DataGridView();` ?? You should employ the same DataGridView present in the form.
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in how to set datagridview's row number form textbox? c#

    I would set datagrid's property `AllowUserToAddRow` to False and then manage to add a row by code. For example: Private Sub btnNext_Click(sender As System.Object, e As System.EventArgs) Handles btnNext.Click Try …
  • Member Avatar for xrjf
    xrjf

    Began Watching how to set datagridview's row number form textbox? c#

    it means if user insert "n"(number of case) in textbox than click the "Next" button, in datagridview set to "n" number of rows. i don't know what code i use, …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in WPF - Assigning a common style to all "Window" and "Grid" elements

    I've search a quite and what you're looking for seems quite sure to not work. Another work around is to add a 'myWindow' class inherited from window and set the …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in WPF - Assigning a common style to all "Window" and "Grid" elements

    Additionally supressing `Style="{StaticResource MyWindowStyle}"` you may add this event in code behind MainWindow: Private Sub MainWindow_Initialized(sender As System.Object, e As System.EventArgs) Me.Style = FindResource("MyWindowStyle") End Sub
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in WPF - Assigning a common style to all "Window" and "Grid" elements

    ![WpfStyleFile.PNG](/attachments/large/3/0c9a49e533ca301a6578f615c654647b.PNG "align-center") I've tried your code and the only way I could change the window's background was setting `x:Key`. MainWindow.xaml: <Window x:Class="MainWindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Title="MainWindow" Style="{StaticResource MyWindowStyle}" > <Grid HorizontalAlignment="Center" …
  • Member Avatar for xrjf
    xrjf

    Began Watching WPF - Assigning a common style to all "Window" and "Grid" elements

    Hi Everyone, I started creating a new WPF project wherein, I have just added a style to all the elements of type "Window" and "Grid" but none of these are …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in set icon for nodes in XMLTreeView via XML-File (vb.net)

    You are welcome
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in set icon for nodes in XMLTreeView via XML-File (vb.net)

    You may do a trick: set a numberic value to Path attribute for Programme, Felt, and so on: <?xml version="1.0" encoding="utf-8"?> <Programme Path="1"> <Feld Icon="Folder.ico" Path="2"> Feld 1<VisualStudio Path="C:\Program Files …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in set icon for nodes in XMLTreeView via XML-File (vb.net)

    Of course your class seems to be called `XmlTreeView` so replace line #7 `Public Class treeViewLoadXml` by `Public Class XmlTreeView`. I case of doubt please tell me.
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in set icon for nodes in XMLTreeView via XML-File (vb.net)

    Ok, forget the last I said and here is the code again, supposed the TreeView control is named TreeView1: Imports System.Xml Imports System.IO Imports System.Text Imports System.Text.RegularExpressions Public Class treeViewLoadXml …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in set icon for nodes in XMLTreeView via XML-File (vb.net)

    The class starting at lines #13 and #14 define a user control (which inherits from TreeView): Public Class MyTreeNode Inherits TreeView ... You should add this user control to your …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in set icon for nodes in XMLTreeView via XML-File (vb.net)

    That's because your control's name is perhaps treeview1 -a treeview control- and if it's not an instance of MyTreeNode. To replace treeView1 by an instance of MyTreeNode look in the …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in set icon for nodes in XMLTreeView via XML-File (vb.net)

    Note that lines #92 to #95 reserve the path in 'Name' property, which is latter used in line #113 to execute the file in `Process.Start`
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in set icon for nodes in XMLTreeView via XML-File (vb.net)

    Here the control is inheriting from TreeView instead of TreeNode: Imports System.Xml Imports System.Reflection Imports System.IO Imports System.Text Imports System.Text.RegularExpressions Public Class treeViewLoadXml Private Sub treeViewLoadXml_Load(sender As System.Object, e As …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in set icon for nodes in XMLTreeView via XML-File (vb.net)

    ![treeView4.PNG](/attachments/large/3/3a83419a293480cf874107a422eed05e.PNG "align-center") Let's see how it goes this time. I've left commented the old instruction to visualize better the change. Private Sub AddNode(ByVal inXmlNode As XmlNode, ByVal inTreeNode As TreeNode) …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in set icon for nodes in XMLTreeView via XML-File (vb.net)

    Sorry, I can't understand what's wrong now. Could you explain more? Your last image looks like what you were after. In any case, by now can't you resolve it by …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in Difficulty Connecting to Remote MS Access Database on LAN

    @dark.knight Let me suggest to you to start a new threat under Programming/Web Development/Asp.net, as this threat says it's been answered. Thank you.
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in How I can add a search string in a combobox?

    Possibly you're look for a solution like the one on this threat [Click Here](https://www.daniweb.com/programming/software-development/threads/507654/combobox-search)
  • Member Avatar for xrjf
    xrjf

    Began Watching How I can add a search string in a combobox?

    Hello, How I can add a search string in a combox? I create a project there are a form Add Category I attached the screen sort. Category Item show in …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in Difficulty Connecting to Remote MS Access Database on LAN

    For me the solution has been: 1) set up a home group 2) add a network location: in "This PC" right click and selected that option and followed the wizard. …
  • Member Avatar for xrjf
    xrjf

    Began Watching Difficulty Connecting to Remote MS Access Database on LAN

    I am currently developing in Visual Studio 2008 (Visual Basic) and I have no problem reading, editing, saving, etc. to a 2007 Access database that is stored locally using the …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in How to read csv file contents in VB.Net

    It's more practical to change the file extension from .csv to .txt and, then, open with Excel.
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in How to read csv file contents in VB.Net

    Here is a modification because it worked for comma delimited, but not for my contacts.csv semicolon delimited. Imports System.IO Imports System.Text Imports System.Text.RegularExpressions Public Class CSV Dim separator As String …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in How to read csv file contents in VB.Net

    I have tried to allow carriage returns: Imports System.IO Imports System.Text Imports System.Text.RegularExpressions Public Class CSV Dim separator As String Private Sub btnLoad_Click(sender As System.Object, e As System.EventArgs) Handles btnLoad.Click …
  • Member Avatar for xrjf
    xrjf

    Began Watching How to read csv file contents in VB.Net

    Hi, I want to read csv (Comma Separated Values) file content in VB.Net I want read entire values in file store in the fixed blocks ( say array ) Please …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in SQL query joining 6 tables in asp.net

    ![jointables.png](/attachments/large/3/256c3728e565d559606955673ba99b34.png "align-center") SELECT e.classid, a.planname, b.workoutname, e.date, c.timeslot, e.status, d.staffemail FROM tblclass e JOIN tblallocation f ON e.planallocationid = f.planallocationid JOIN tblplan a ON a.planid = f.planid JOIN tblworkout b …
  • Member Avatar for xrjf
    xrjf

    Began Watching SQL query joining 6 tables in asp.net

    Hello experts, I have to write a sql joining 6 tables. to retrieve classid, planname, workoutname,date,timeslot,status,staffemail and display them to a gridview. the tables are as below **tblclass** having columns …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in Finding the correct angle to an object from the ground in 3D space

    ![turretangle.png](/attachments/large/3/0aaf5412186dcf3117ee835052f23754.png "align-center") This is physics and has to do, in my opinion, with OOP more or less like physical. The solution I think is θ' = π - θ because …
  • Member Avatar for xrjf
    xrjf

    Began Watching Finding the correct angle to an object from the ground in 3D space

    Hello. I'm using Unity3d to create a simple turret simulation and I have run in to a problem. I need to find the angle to an object from the turret …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in set icon for nodes in XMLTreeView via XML-File (vb.net)

    Try this: Imports System.Xml Imports System.Reflection Imports System.IO Imports System.Text Imports System.Text.RegularExpressions Public Class treeViewLoadXml Dim imgLst As New ImageList Dim vImgPath(-1) As String, iv As Int32 = 0 Private …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in Need to make check before deleting row in gridview

    Perhaps you are asking for `DataGridView1.CellClick`event ?
  • Member Avatar for xrjf
    xrjf

    Began Watching Need to make check before deleting row in gridview

    Hi i have a gridview displaying data at page load and i added a column delete. i have the primary key of the table displayed in the gridview as foreignkey …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in What WndProc Windows Message for this

    You must develope and install a driver. Search for MS' DDK, driver deveopment kit.
  • Member Avatar for xrjf
    xrjf

    Began Watching What WndProc Windows Message for this

    Hi DW. Anyone know what/which type of WndProc Windows Message is raised when someone is burning a CD? What I mean here is that if I'm using a software like …
  • Member Avatar for xrjf
    xrjf

    Replied To a Post in Removing Item From Listbox And Updating Subtotal

    Be more explicit, please, and explain what amount, what listbox and what code is there. Copy here any code you have and tell what you expect the program to do …

The End.