|
Help me
I have a trouble again with M.Access. I have a combo-box on a form, and this combo-box has the responsibility on showing the Query which creates the 4-column table, including Company,Name,Address and ClientID.
My purpose is that I want to show this Query in the combo-box in the order A-Z, before the blank company items.
My solution:
I create a query like below:
select .........
from nhanvien
where company is null
union
select .........
from nhanvien
where company is not null
However, the result isn't right like my hope. I think that the reason is because of the order of the ClientID which is the primary key...As a result, the destination query automatically sorts on the ClientID order.
Thinking of the solution :
I don't know how to do to archieve that result. I think so much about the SQL sentence of the above query. I believe that there's another SQL sentence helping me to solve this problem. I'm very happy whether you give me a SQL sentence to do that or another solution to obtain the same result ....
Thanks so much <vtalau>
|
|
|
|
|
vtalau wrote:
select .........
from nhanvien
where company is null
union
select .........
from nhanvien
where company is not null
Try This
<br />
select 1, .........<br />
from nhanvien<br />
where company is null<br />
union<br />
select 0, .........<br />
from nhanvien<br />
where company is not null<br />
order by 1<br />
What I did was add a new column in front of your currently selected data and then sorted by column number 1. That should put all of your null items last.
Have a great day!
j2associates_NO_SPAM_@yahoo.com
|
|
|
|
|
Can anyone tell me whether a webbrowser (MS Internet Control) can navigate to a file included in the vb6 resource file directly without transferring the file to a directory? Thanks.
|
|
|
|
|
|
|
Hello im using MessageBox.Show() to display popup message boxes, i am trying to create a new line for some text im using. I have tryed /r/n and /n both dont work.
How can i create a new line?
Thanks
Oi
|
|
|
|
|
Environment.NewLine
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Thanks worked fine 
Im also trying to hide a proccess when its run can you help with this
The code i am using is as follows
Dim startInfo As System.Diagnostics.ProcessStartInfo
Dim pStart As New System.Diagnostics.Process
startInfo = New System.Diagnostics.ProcessStartInfo("C:\test.bat")
pStart.StartInfo = startInfo
pStart.Start()
pStart.WaitForExit() 'Your code will halt until the exe file has executed.
The batch file is shown as it executes how can i hide this?
Thanks
Oli
|
|
|
|
|
Unless you can get a handle on the console window and then hide it in code, I'm afraid I don't know.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
I don't know which one works best, but you can use one (or both) of this:
startInfo.CreateNoWindow = True
startInfo.WindowStyle = ProcessWindowStyle.Minimized
Have fun with it! 
|
|
|
|
|
I am building a website using visual studio and an access database. When more than one user is entering data and they submit the info is going to multiple pages. It should only go to the pages that are designated. this does not happen if it is only one user. Is this my dataSets or am I missing something.
|
|
|
|
|
are you using application items?
"People who never make mistakes, never do anything."
My blog
http://toddsnotsoamazinglife.blogspot.com/
|
|
|
|
|
I am not using any that I am aware of
|
|
|
|
|
What do you mean by "the data is going to multiple pages"?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
The data is going to multiple records in the access database if there are more than one person entering data at the same time.
|
|
|
|
|
could it be a problem with my datasets
|
|
|
|
|
I was wondering if I could insert a file into resource (.RES) file during runtime instead of inserting a file using resource editor at design time. Could anyone help me with this information ? Thanks in advance.
rudysup
|
|
|
|
|
No, you can't.
Since the resources are compiled into the target .EXE at compile time, any changes you make to the file won't be reflected in the target .EXE until you recompile it.
The resource editor is part of the Visual Studio IDE and is not available to your .EXE at runtime. That is, unless your making a Visual Studio add-in...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
This is the source code  
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Imports System.Data.SqlClient
Imports System.Data
Private str_connection As String = "workstation id=""MAX-IT10Q0"";packet size=4096;integrated security=SSPI;initia" & _
"l catalog=Addressbook;persist security info=False"
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim cnsql As SqlConnection
Dim load_dataset As New DataSet
Dim rpt As ReportDocument
Dim str_query As String
rpt = New ReportDocument
rpt.Load("..\CrystalReport2.rpt")
cnsql = New SqlConnection(str_connection)
cnsql.Open()
str_query = "select name,Address from tb_abook"
Dim load_adapter As New SqlDataAdapter(str_query, cnsql)
load_adapter.Fill(load_dataset, "tb_abook")
rpt.SetDataSource(load_dataset)
CrystalReportViewer1.ReportSource = rpt
End Sub
The report is loading properly but data is nothing no error message
Report :Crystelreport 9.0
Os: XP
visual studio.net 2003
Continue...
|
|
|
|
|
I am not sure I am calling this user defined function correctly. I have set the variable ID equal to the value from a drop down list and am trying to pass the variable to the user defined function.
Dim id As String
id = ddlDriver.SelectedValue.ToString
Dim conn As SqlConnection
Dim cmd As SqlCommand
Dim dn As DataSet = New DataSet
Dim da As SqlDataAdapter = New SqlDataAdapter
conn = New SqlConnection(server information)
cmd = conn.CreateCommand()
cmd.CommandText = "dbo.get_tractor'" + id + "'"
da.SelectCommand = cmd
da.Fill(dn, "tractor")
I keep getting an error and have checked the dataset through the quickwatch and it always comes back null.
Scott Moore
|
|
|
|
|
cmd.commandtext = "select dbo.get_tractor('" & id & "')"
"People who never make mistakes, never do anything."
My blog
http://toddsnotsoamazinglife.blogspot.com/
|
|
|
|
|
|
|
|
I just need some help on how to build a file & folder finder (any).
I want to use a textbox, a button and a msgbox to display the findings.
I can find files by using " exists " and hard code path, but I'd like to do it
differently, like more user friendly, like typing the file name (any file) in the textbox and then
clicking the " find " button.
I'd know how to use the system.io namespace for file & folder manipulation, but i do not know how
to combine both.
Like how can you type a file name in a textbox, and get the location of that file?
Is that possible?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
