Hi,
I am having two tables : Offer and OfferItems.Both tables having Identity fields as primary keys Offer_ID and OfferItem_ID respectively. the field "OI_OfferID " in OfferItem table relates the parent column Offer_ID. I am using stored procedures and configured dataset with these tables with relationship. My SP for inserting Offer also returns Offer_ID as OUTPUT value.
While adding OfferItem row ,I am...
PreethiParkavi
Last Activity: Nov 21 '08, 01:34 PM
Joined: Jan 20 '08
Location:
-
Send SMS using Bluetooth Device
Hi All,
I am .Net Guy and interested in Mobile application Development. I Want to send SMS to mobile thorough my PC using Bluetooth technology.But, I don't know where to start from.How to achieve this with C#?. Please help me.
Thanks,
Mathi. -
Hi Plater,
Thank you for your quick replies.I Got your point of "Using user credentials for all logins".but, the problem is,I want to auto login in my windows application when web page gives some download links.at that time ,my windows application (Download Manager) has to log in and display previous downloads of the user . I have created a window service which is identifying a download link clicked and invoke the windows... -
Hi,
I am trying to use HttpWebReques.w hile using the code,
It seems that It creates a new request to URL...Code:HttpWebRequest request = [B](HttpWebRequest)WebRequest.Create(url)[/B]; request.CookieContainer = new CookieContainer(); HttpWebResponse response = (HttpWebResponse) request.GetResponse(); response.Cookies = request.CookieContainer.GetCookies(request.RequestUri);
Leave a comment:
-
Reading Cookies from windows application
Hi All,
I am developing a download manager for a a website downloads.The problem is , I have to login in my windows application with same user credentials of web login when I logging in web application.In web application , I set cookies with user credentials ; but, Not able to read them in windows.I have tried the ideas suggested by http://p2p.wrox.com/topic.asp?TOPIC_ID=29325 .
I am not able to read the cookies created in Firefox... -
PreethiParkavi started a topic Downloading withCustom Download Manager instead default download programin .NETDownloading withCustom Download Manager instead default download program
Hi All,
I am trying to develop a custom download manager for my website and I have partially succeed.The Problem is, When I download a file, The browser opens default download manager Instead of my download manager.
The MSDN http://support.microsoft.com/kb/327865 guides to use The COM object to achieve this .As I am new to COM object, I am not able understand the stuff.is there any interface like IDownloadManage r in C# ? .Please... -
It will be use ful for all of us if you send the block diagram links as a post in the forum.
Thanks,
PreethiLeave a comment:
-
How to find whether a property has changed ?
Hi all,
I am not enough clear with "PropertyChange d" event handler.I want to do some operation if a specified property is changed.How do I know that a property has changed".Please help me in this issue.
Thanks,
Preethi -
Hi,
You can import data from Excel through the query.for example
Here , 2 columns are imported...Code:SELECT * INTO #tmp FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=d:\mathi\sample.xls', 'SELECT ID,Name FROM [sheet1$] order by name') select * from #tmp INSERT INTO SAMPLE (ID,NAME) select ID,NAME from #tmp select * from sample drop table #tmpLeave a comment:
-
Is it possible Paging in repeater
Hi this is arun.I need urgent help that is it possible to use paging in repeater control in c# .
If possible please send the codingLast edited by jhardman; Feb 13 '08, 05:45 PM. Reason: moved to .Net forum. ASP forum is for "classic" ASP -
PreethiParkavi replied to How to identify a user of concurrent users in centralized sql server databasein SQL ServerThank You to you CK for spending your valuable time for me. I am trying to implement the third option with triggers and updated field and ask your help if I needed.
With Thanks ,
Preethi.Leave a comment:
-
PreethiParkavi replied to How to identify a user of concurrent users in centralized sql server databasein SQL ServerHi CK,
You are right in that I am using Front-End application which holds logged user details.I Could not understand the "Updateable View" concept.Could you explain it for me to implement audit-log.
Thanks with Anticipation,
PreethiLeave a comment:
-
PreethiParkavi replied to How to identify a user of concurrent users in centralized sql server databasein SQL ServerThank you CK for your helps.
I am thinking of passing log in user name (which is in "Employee" table) as argument.with this, we can insert the audit log which record is manipulated by which user.How to we accomplish this through triggers/any other T-SQL code ?
Thanks,
PreethiLeave a comment:
-
Hi Friend,
The use of ISNULL operator is assign the value to a variable, when it is NULL and it's intention is not to check for NULL value. we can check for NULL value with
clause.so, we can change your T-SQL to :
DECLARE @i VARCHAR(20)
BEGIN
SET NOCOUNT ON
CREATE TABLE #temp (Item varchar(20))
INSERT INTO #temp(Item) VALUES('erty')
SELECT @i = Item FROM #temp WHERE Item =...Leave a comment:
-
PreethiParkavi replied to How to identify a user of concurrent users in centralized sql server databasein SQL ServerThank You CK.I thought ,As you say ,It is good to have "UpdatedBy" field in every tables which are going to be audited.Before implementing this, I am having doubt,
Is it possible to pass argument to a trigger which will resolve this problem with less effort from client program?.please advice me.Leave a comment:
-
PreethiParkavi started a topic How to identify a user of concurrent users in centralized sql server databasein SQL ServerHow to identify a user of concurrent users in centralized sql server database
Dear Friends,
We are developing an inventory maintenance project in C#.net 2005 with MSDE as back end.Data can be accessed by multiuser at the same time, because they are from a single centralized database.
Now, we are planning to implement audit trail to track which record is manipulated by which user.
No activity results to display
Leave a comment: