|
hi all,
i write a query which return rows for selected column.In Addition to Table's column ,i also want to return Serial number of each row. let me explain. Assume i write following query
"select Name from table1"
suppose this query return 2 records which value is name1 and name2.Now i want to add s.no. of each row like
1 Name1
2 Name2
so how can i write these type of query ?
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
Serial number? 
Are you talking about the Primary Key (ID field) column you have on this table?? You do have a Pimrary key defined on this table, right?
In that case, all you have to do is specify it's column number in the SQL statement:
SELECT MyIdField, Name FROM MyTable WHERE expression
|
|
|
|
|
No sir,
i m not talking about Primary field. I just only want to attach "Serial Number" field with each row returned by query.
in primary key field, it is not essential that all records follow sequence because where clause is attach it
hope you understand my problem.
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
I still don't have any clue what you're talking about when you say "Serial Number". Is this is field in the database table already or something the database needs to generate or what??
|
|
|
|
|
Is this is field in the database table already or something the database needs to generate or what??
sir, this is not a database field. I just want to generate serial number for each row returned by query.
let me explain. suppose i write following query
"select Letter from alphabet"
above query return all rows from alphabet table(but with single column). which is ---
Letter
a
b
c
d
.
.
.
z
but i want to result in following form without adding any additional field in database'table
S.No. Letter
1 a
2 b
3 c
4 d
. .
. .
. .
26 z
so how can i write query to generate this type of result
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
You can't do this without another field in the database. You MUST add a Primary key column, probably an autonumber, and that will give you your "serial number" for each row. When you execute a database query, unless you specify otherwise, rows are returned in whatever order the database sees fit at the time. There is no guaranteed order, therefor, any "math" you do to assign a serial number, which is going to end up being another column anyway in the DataTable, can be different for each row the next time you run the query.
|
|
|
|
|
Okay, I know how to zip a file, but is there a way to zip an entire folder?
|
|
|
|
|
It's the same as zipping a file. You just have to zip one file at a time into the same archive.
|
|
|
|
|
So, I just create a zip file called zip.zip, and just keep calling that same file in my zip function until I finish all of my files?
|
|
|
|
|
It depends on the library you're using, but yes, add one file at a time to the same .ZIP file.
|
|
|
|
|
I have an item called DashboardItem with inherits Windows.Forms.UserControl and declared the class as MustInhert :-
Public MustInherit Class DashBoardItem<br />
Inherits Windows.Forms.UserControl
I have then added some common features, such as a close button and title label.
The next step is to inherit DashboardItem into another class :-
Public Class VehicleTracking<br />
Inherits PDM.Session.DashBoardItem
The problem I have now is the designer reports :-
The designer must create an instance of type 'PDM.Session.DashBoardItem' but it cannot because the type is declared as abstract.
I need guidance on what to do to resolve this issue.
I checked out the MSDN Online help which was not very helpful at all, check out the description of the error message: http://msdn2.microsoft.com/en-gb/library/aa289354(VS.71).aspx[^]
Any help is appreciated
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
It doesn't work because Visual Studio can't create an instance of ab abstract type anymore than your code can. For example, when you design a new form, Visual Studio creates an instance of System.Windows.Forms.Form and lets you drop controls on it, right?
Why is it creating an instance of Form instead of your class called Form1?? Because Form1 isn't compiled and doesn't yet exist. The Designer always creates an instance of the base class of the type you want to design. So, in your case, when you try to design a new control based on DashBoardItem, the Designer tries to create an instance of DashBoardItem and can't, because it's MustInherit (abstract).
Read more on why it doesn't work here[^]. There's a followup post on a possible work around here[^]. Just a warning, it's a bunch of work on your part to put this workaround in place. It's even more of a pain to get it to actually work.
|
|
|
|
|
I found the solution, although I do not think it's right. If I remove the MustInherit clause the the DashboardItem class, it works fine
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
Yep, but then it's no longer an abstract class. If this is acceptable in your design, great, if not, well....
|
|
|
|
|
Hi All,
In my application, i am using vb 6.0 as front end and MS-SQL Server 2005 Express Edition as Back End.
SQL Server 2005 is installed in another system called Sys2.
I am using the following connection string in Visual Basic, to connect to SQL Server.
Conn.ConnectionString = "Driver={SQL Native Client};Server=Sys2\SQLEXPRESS;Database=OT_LOG;Trusted_Connection=yes;"
But when I try to run the application, its giving the following error:
[Microsoft][SQL Native Client][SQL Server]Login failed for user". The user is not associated with a trusted SQL Server connection.
Please help me in this issue.
Thanks in Advance,
Regards,
|
|
|
|
|
|
|
If you are using a trusted connection, then your account must be defined on the remote node (Sys2 in your case).
A probable better solution is to use a defined account and password;
for example:
Driver={SQL Native Client};Server=Sys\SQLEXPRESS;Database=OT_LOG;uid=OT_Log_User;pwd=OT_Log_User_PWD
The username and password can be stored in the registry, a config file, and INI file, etc.
Hope that helps.
Tim
|
|
|
|
|
Hi Tim,
Thanks lot for your help.
Can you give me some idea about that username and password.
Is that username and password same as windows username and password or we need to create specific for this. If so, how to do with that.
Regards,
|
|
|
|
|
The username and password can be whatever you want; there are defined on the SQLServer end. Create a user account, define the password, and grant access to the database.
|
|
|
|
|
Hi,
I am dealing with one windows application. In this application I m using DataGridView control. I have used multi threading on this control to display updated data continuously. But When second thread displays the data both scroll positions reset to original state. I want retain scrollbar positions. I request you to plz guide me for the same
Thanx
Gurudatta B. Shelke
|
|
|
|
|
There's no managed code way to do this. You've have to use the Win32 api to do it. The DataGridView is a bit problematic in this. You can find out more about it here.[^]
|
|
|
|
|
Hello all,
I need to take in today's date in parts (using datetime.now.day etc.) and output them. The problem is that if the date is less than ten it is shown as "9" instead of "09". Same with the time.
Is there an easy way to show it in the format i want or do i have to get each ones length and check if it needs adding to?
Any help will be appreciated.
|
|
|
|
|
Use Format Function
Ex : format(now.day ,"00")
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
.... or now.Days.ToString("D2")
Luc Pattyn [Forum Guidelines] [My Articles]
This month's tips:
- before you ask a question here, search CodeProject, then Google;
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get;
- use PRE tags to preserve formatting when showing multi-line code snippets.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
