|
That first link doesn't seem to help because i tried those things so many times but that second link which is in french seem to be very useful so please help me transalting it.
Thanks,
Rachit Damani.
|
|
|
|
|
hi everybody
I have 3 tables employe,earning,deductions
table employe
id name
1 shekar
2 vijay
3 mohan
4 kiran
table earning
id desc amt
1 basic 1000
1 hra 850
1 ta 150
2 basic 3000
2 hra 350
2 ta 200
3 basic 4000
3 hra 700
3 ta 100
4 basic 5000
4 hra 600
4 ta 170
table dedu
id desc amt
1 pf 50
1 it 100
1 pt 60
2 pf 50
2 it 100
2 pt 60
3 pf 50
3 it 100
3 pt 60
4 pf 50
4 it 100
4 pt 60
is it possible to get the o/p like this
id name basic hra ta pf it pt
1 shekar 1000 850 150 50 100 60
2 vijay 3000 350 200 50 100 60
...
regards
chandru
|
|
|
|
|
dear chandru,
I strongly recommend you to change the structure of your table....Why not to keep three different fields basic/hra/ta in earning Table And pf/it/pt in the deduction table....
Tirtha
Miles to go before I sleep
|
|
|
|
|
Dear Tirtha,
Why i created in different tables beacuse user can create new fields by his own if any new benfits, deducutions as and when he come across without contacting the developers.
I have diffent table where i hold these field name,formulas e.t.c., where they will enter details of fields & formulas for that fields. and add the field name to the employee id.
I am using sql server 2000
regards
chandru
|
|
|
|
|
You can certainly do this but I agree with another reply for this post to normalize the tables ... In any case you SP should do some thing like this
1. Create Temp table with the required columns
2. Select the required information from all the table using join
3. fill the temp table
4. Select from the temp table
If you are using MS SQL 2005 then there is something like Pivot tables through which you can still achieve the same ...
Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com
|
|
|
|
|
I am a beginner of SQL SERVER 2005 and I need to create a database server to be able to share data in other computers inside and outside of my network. Please show me web pages about this topic. This is one way to learn, beginning to create databases configuring firstly the network. thank you.
SQL SERVER
|
|
|
|
|
Hi
When I view a table withen DataGridView . for eg .. then rows count on the table is 5 rows .. you found at the end of rows on the dataagrid control a balck area with the back color ,,,
Can I make the DatagridView Countinue view it's rows even it is empty ..
I hope that my idea is clear
jooooo
|
|
|
|
|
If you are saying some like making pagination static, then I would say it is possible only thing you would require to put the empty pagertemplate then in the data bind event associate the pagination information to a user defined control for pagination.
Hope thats clear.
Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com
|
|
|
|
|
hi,
The back ground of the grid view changing based on records, if it yes
go for this solution, i hope it will clear ur problem
give ur <grid view=""> of grid veiw.it will solve ur problem.
with regards,
sudhakar.vaddepalli.
|
|
|
|
|
Thanks my friend ..
I can't understand what you mean ..
I mean the backcolor of the blank area of the Grid , not the backcolor of the rows . ..
jooooo
|
|
|
|
|
hi,
it is for blank space of Grid view n't for grid rows.
what i said & what u want is same.give the height to td tag of html designer or web page where u kept the Grid view tag like below
height="Some height">
Grid View control ...................................
|
i think now u will get it.
|
|
|
|
|
Can anyone tell me the best way to get a list of all the queries ran against a particular database on my server? I don't need queries ran against System Tables only the tables I've defined. As mention in the subject, it's SQL Server 2005. I've ssearched the Web as well as help files but apparently I'm not using the correct keywords in my search as I haven't found anything.
|
|
|
|
|
I would get a good sql log file parser. There are some good tools out there. The information you want is only in the log files.
Hope that helps.
Ben
|
|
|
|
|
Ok, I'll try that, but I also thought SQL Server 2005 has a lot of new statisitcs and usage reporting built in?
|
|
|
|
|
I would suggest use SQL profiler tool, and start the session. That will record all the queries that are running on the DB.
Hope that solves your problem
Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com
|
|
|
|
|
I am trying to run an update query in vb.net using MySQL back end but I keep getting the following syntax error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' OrderItemSource = 'MD' , OrderType = 'Ron Ayers MotorSports'' at line 1
Here is my code:
Private Sub UpdatePrice(ByVal PartNum As String, ByVal PartRetailPrice As String, ByVal PartSalePrice As String, ByVal PartSource As String)
Dim myConnString As String = My.Settings.ConnectionString
Dim MyConnection As New MySqlConnection(myConnString)
MyConnection.Open()
Dim MyCommand As New MySqlCommand("UPDATE ls_orderitems SET OrderItemRetailPrice = '" & Trim(PartRetailPrice) & "', OrderItemSalePrice = '" & Trim(PartSalePrice) & "' WHERE OrderItemPartNum = '" & Trim(PartNum) & "', OrderItemSource = '" & Trim(PartSource) & "', OrderType = 'Ron Ayers MotorSports'")
MyCommand.Connection = MyConnection
MyCommand.ExecuteNonQuery()
MyConnection.Close()
End Sub
Any suggestions would be greatly appreciated.
jds1207
|
|
|
|
|
Your where clause is the problem you have:
WHERE OrderItemPartNum = '" & Trim(PartNum) & "', OrderItemSource = '" & Trim(PartSource) & "', OrderType = 'Ron Ayers MotorSports'")
should be:
WHERE OrderItemPartNum = '" & Trim(PartNum) & "'And OrderItemSource = '" & Trim(PartSource) & "'And OrderType = 'Ron Ayers MotorSports'")
Hope that helps.
Ben
|
|
|
|
|
Hi all,
I am developing an asp.net application and i want to develop data access layer that is applicable for any data source type for example(sql server orcle).
is there any one have an idea about implementing this data layer without using oldbe connection.
it is important to say that i don't use any stored procedure ,I am dealing with database at run time using .net without any stored procedure or functions.
I will be gratefull if anyone can help me with this issue
Best regards,
Hassan Amaar.
Hassan Amaar
|
|
|
|
|
If you are dealing with multiple sources, you need to consider using the Factory pattern. Fortunately for you, MS has spent a lot of time and money extracting the interfaces out into relevant factories. This article is a small starting point for you: http://davidhayden.com/blog/dave/archive/2006/04/04/2900.aspx[^]
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Thanks alot I do appreciate your help
Hassan Amaar
|
|
|
|
|
Not a problem. I'm glad to help with questions like this.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hello,
I have one data table with fields SerialNo, manufacturer, and model. Called AllParts.
Hello,
VS 2005
I have 3 other data tables (software, components, equipment) that have those same fields plus some extra fields.
I want to fill this allParts with the serialNo, manufacturer, and model from the other tables.
So allParts will contain rows from software, components, equipment
a bit like copying all the contents from the 3 tables and merging them into a single data table called allParts.
Can anyone help me with this.
Many thanks,
Steve
|
|
|
|
|
You could create AllParts as a view and then UNION the data from your three tables into here.
|
|
|
|
|
hi
see this link u will get an idea
http://www.vbdotnetheaven.com/UploadFile/gulatisa/MergeTables11272006232307PM/MergeTables.aspx
DataSet dsContract = new DataSet();
DataSet dsMergedContract = new DataSet();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "usp_getContracts";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "UWYear", DbType.Int32, UWYear);
db.LoadDataSet(dbCommand, dsContract, "ContractDetail");
dsMergedContract.Tables.Add("ContractDetail");
for (int i = 0; i < dsContract.Tables.Count; i++)
{
dsMergedContract.Tables["ContractDetail"].Merge(dsContract.Tables[i]);
}
return dsMergedContract
|
|
|
|
|
If this is just done at the run time and only resultset is required, then I would suggest create an stored procedure which does the following
1. Create a temp table in SP
2. fill this table one by one with the required information
3. execute a select query on this temp table
Hope this solves your purpose
Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com
|
|
|
|