|
from one sqlsever2000 i have two data base employeedb and companydb .how to create the connection string for this using asp.net with c#
and compare the values from two tables
|
|
|
|
|
Perhaps another way of addressing this would be to have a view or stored procedure in one database that gathers the data from the other so that you don't need 2 connection strings.Tychotics: take us back to the moon
"Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars."
H. G. Wells
|
|
|
|
|
can you give me the example how to read the table values from two connection string
using views or stored procedure
|
|
|
|
|
this works in sql server 2005! i haven't try in 2000!
SELECT * FROM Employeedb.dbo.TableOfEmployeedbDB INNER JOIN
Companydb.dbo.TableOfCompanydbDB ON
Employeedb.dbo.TableOfEmployeedbDB.IdField =
Companydb.dbo.TableOfCompanydbDB.IdField
You can access the dababase tables! even from another databases!
you only have to say to sql server where are you getting the data.
It's that why you need to specify the db in every Table sentence
good luck
|
|
|
|
|
Thanks to all code project team ...it really helps..
|
|
|
|
|
i am developing chat control in that when i click on online users then it open a chat panel only for single user .
My query is when i click next user then it should show next panel
just like when i click 10 users then it should open ten new panel for that ?
i want
(Note : i use linkbutton to show online users )modified on Monday, March 1, 2010 7:27 AM
|
|
|
|
|
|
|
I want to change format text in textarea.
FRANCE
Merhaba,arkadaslar
POLOGNE
Selam vatandaslar..
>/textarea>
I want just "FRANCE" bold or change fore color.
|
|
|
|
|
take a look
http://www.webmasterworld.com/forum21/10080.htm
|
|
|
|
|
I tried, but it doesn't work.
|
|
|
|
|
Do you just want to chang "FRANCE"?
If so, I think you must change your textarea to html editor.
April
Comm100 - Leading Live Chat Software Provider
modified 27-May-14 8:48am.
|
|
|
|
|
You can use Substring to intercept “France” out,and then give it the style.
April
Comm100 - Leading Live Chat Software Provider
modified 27-May-14 8:47am.
|
|
|
|
|
<style type="text/css">
textarea.special {
font-family:arial;
font-size:14px;
}
textarea.special:first-line {
font-weight: bold;
}
</style>
Like rakeshs312, this method is nice
|
|
|
|
|
Hi...
I have two DIV controls in my main.aspx page. 1st DIV's ID is COMPONENT and another one is COLOR.
in main.aspx.cs, I have code to retrieve some datas from database.
foreach (DataRow drRow in dtResult.Rows)
{
Loginname = drRow["name"].ToString();
password = drRow["password"].ToString();
Response.Write(Loginname + "-" + password);
}
It is printing the values in mian window.but i want to print the value of Loginname & password into the DIV - COMPONENT.
How to do this...
Any help will be appriciated...
Thanks...G.Paulraj
|
|
|
|
|
use labels in that div and write it there
|
|
|
|
|
yes... That is one method. But here i don't know how much rows are there.
So i have to include many labels... thats why i am asking to print with out labels...G.Paulraj
|
|
|
|
|
or use a multiline textbox and write like
TextBox1.Text+= Loginname + "-" + password + "\r\n" ;
|
|
|
|
|
Yes...
Its working.... But i need to give links to each login name.
for ex,
paul - www.paul.com
raj - www.raj.com
rakesh - www.rakesh.com
Thats why i am asking to print in DIV.
Thanks...G.Paulraj
|
|
|
|
|
<div ID="display" runut="server">
foreach (DataRow drRow in dtResult.Rows)
{
Loginname = drRow["name"].ToString();
password = drRow["password"].ToString();
disp.InnerHtml += Loginname + "-" + password;
disp.InnerHtml+=("<br>");
}
|
|
|
|
|
iam checking the user is valid or not from the data base using asp.net with c#. when user is valid i should get the right symbol beside this control....what control i have to use in ajax or any
|
|
|
|
|
Read this[^]. Does it looks that hard finding out?
|
|
|
|
|
I'm using asp.net and sql server, i have table loguser fields arelike this userid varchar(50)
tdate datetime
login datetime
logout datetime
timespend datetime
i want to findout between that how many hour he spend...
Ex:
Login Time: 11:50:39
Logout Time: 12:35:03
then again when he login Login Time:12:50:03
Logout Time: 2:35:03
i want to find out today how much hours he spend
and update the field timespend in database
|
|
|
|
|
This question better belongs to General database forum.
Since the database columns are of type DateTime, you will have the date as well. Now, use DateDiff function and find the difference between login and logout time. This would give the time spent. Make sure that the dates are for both login and logout. If the dates are different, then login time to midnight would be time spent today and midnight to logout time would be the time spent the next day.
|
|
|
|
|
Hi,
I think you can record the total timespend to db when he logs out: timespend =timespend + Logout Time - Login Time,
and you should check if the login is the first login of that day, if it is, set timespend = 0.
April
Comm100 - Leading Live Chat Software Provider
modified 27-May-14 8:47am.
|
|
|
|