|
Maybe your 0.05 is really 0.0466666666 ?
|
|
|
|
|
yes that is correct
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa[at]dotnetfunda.com
http://www.Dotnetfunda.com
|
|
|
|
|
Hi, I'm vickyraj.. I'm new to asp.net I'm creating studentrecord using database in asp.net.
I need prev and next button code i have tried to sort that one but i didn't get......
please... can anyone help me....to sort out here...
I'would be thankful to you....  
vickyraj
|
|
|
|
|
1. Read the guidelines on how to ask a question.
2. Pick the right forum - you really should ask this in the ASP forum.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You can use asp.net data-grid option control to populate your data into browser in the right side property explorer limit property set to as you want
In this case your data populate into pagination
Kumar Ashish
|
|
|
|
|
See the following scenario:
Tables for the question:
Table : T1
c10 c12
e1 A
e2 B
e3 C
Table: T2
c1 c2 c3 c4 c5 C6
1 P e1 e2 null X
2 Q e3 null null Y
3 R e2 e1 null X
4 S e3 e1 e2 Z
The c3, c4 and c5 columns of T2 table depends on c12 column of T1 table.
I want the following output:
c1 c2 c3 c4 c5
1 P A B null
2 Q C null null
3 R B A null
4 S C A B
Can you help me to write an SQL to retrieve the above output from the table T1 and T2?
The SQL may be like:
Select c1, c2, t1.c12 as c3....... from t1, t2 where join condition
But I am not getting the actual sql in my mind.
So please help me regarding this.
|
|
|
|
|
I think it would be something like this:
SELECT c1, c2, tbl1.c12 AS c3, tbl2.c12 AS c4, tbl3.c12 AS c5
FROM
T2 LEFT OUTER JOIN
T1 AS tbl1 ON T2.c3 = tbl1.c10 LEFT OUTER JOIN
T1 AS tbl2 ON T2.c4 = tbl2.c10 LEFT OUTER JOIN
T1 AS tbl3 ON T2.c5 = tbl3.c10
Jack of all trades ~ Master of none.
|
|
|
|
|
Here it is
select t2.c1,t2.c2,t1.c12 as c3,t11.c12 as c4,t111.c12 as c5
from table2 t2
inner join table1 t1 on t1.c10 = t2.c3
left join table1 as t11 on t11.c10 = t2.c4
left join table1 as t111 on t111.c10 = t2.c5
I Love T-SQL
"VB.NET is developed with C#.NET"
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Hi All,
I have two databases Example -A1 and A2, both are linked in SQL Server2008. I am pulling 3 tables information from A1 database and putting it into A2. But I am doing this manually by running the below queries
Example :
insert into TMP_ITEMS select * from A1..DEX.items
How to make this as a automatic process.
Thanks,
Vidya Sagar
|
|
|
|
|
How about using a trigger on the insert. As each record is inserted into one database, a similar record can be inserted into the other. 
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
Agreed. In my opinion, this is the best approach.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
I've done that with a Windows Service.
You could also use a Windows Scheduled Task.
|
|
|
|
|
|
Dear All,
I have a Point of sale system (Desktop application) , this system will be deployed on three different branches and one factory branch , we have also a dedicated server hosted online ,all places including the dedicated server having the same schema , i would like to replicate the new changes from branches and factory to dedicated server and vice versa , i tried to use merge replication but in vain , we could not set it up properly , we faced a problem with user account permissions , we got that message "Could not connect to distributor "DedicatedServer".
Could anyone please have a solid procedures to solve such a problem? or if there are some third party tools that could help us achieving that task ?
Your Response is highly appreciated !
Human knowledge belongs to the world.
|
|
|
|
|
What database system are you using? Oracle, MS SQL, Other?
I assume MS. It sounds like a permission problem. Might I suggest creating a SQL login with the desired permissions on all systems.
|
|
|
|
|
I'd have to know a few more details about your infrastructure to provide better feedback as to a course of action.
You may want to review this excellent series of concise articles on SQLServerCentral regarding SQL replication and how to choose the correct model for your needs:
http://www.sqlservercentral.com/stairway/72401/[^]
Best of luck!
|
|
|
|
|
can any one help me i am facing problem in writing query in my project.i am taking four link buttons in one page(test.aspx page) when i click on Test1 link it should show me the result on show page (show.aspx page) by retriving the data stored in database for Test1 table similarly if i click Test2 link it should show me the data on same show page(show.aspx page) retriving data from database for test2 table same for Test3 and Test4 link.database iam using here is sql server 2005.
|
|
|
|
|
How it's displayed and how the user interacts with it doesn't matter. What database system? What is your schema like?
|
|
|
|
|
Trap the click event from the buttons
Identify the button Test1-4 to determine the table
Create a query string to select the data based on the button clicked
Create a connection to the database
Create a command using the connection string and the query string that returns a data table
bind the datatable to the grin in your UI
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
@mycroftholmes can u plzz write query for me to retrive data from diffrent tables on a single pages.
|
|
|
|
|
Nope, I have better things to do that your work.
[edit]
I relent
Select * from TableName
there you go, just replace tableName with the table name.
[/edit]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
how to insert mathematical symbols like integration diffrenciaton symbols in database.so that it can be redable in .netframework when it is retrived from databse
|
|
|
|
|
You have not indicated what database and version you use. In simple terms, you've to use a collation that supports unicode characters. For SQL Server, this[^] will be a starting point.
|
|
|
|
|
shameel thanks for replying actually iam using sql server 2005 and sql database and i want to know how to insert signs of inegration, diffrenciation and limits in database....
|
|
|
|
|
Same answer still applies.
1. It depends on what you 'mean' by "symbol"
2. If and only if the answer to 1 means that unicode is suitable then you have the following choices
a. Set up the database to accept unicode.
b. Encode the data into the character set that the database does support (probably to base64) and live with the fact that you won't see the characters in the database itself - you will need to use your application.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
