Home
Get Started
Learn
Downloads
AJAX
MVC
Community
Wiki
Forums
Sign in
|
Join
Home
›
ASP.NET Forums
›
Search
Search
You searched for the word(s): userid:644820
More Search Options
RSS Available
Matching Posts
Re: 1 To Many Relations
I assume that you are trying to insert a record into tblSource1. After that, you are trying to insert the SourceID i.e. RefID of tblSourceID into tblSource2 and tblSource3. One more assumption is that RefID is identity column. First insert the record into tblSource1 Then use IDENT_CURRENT ( 'tblSource1' ) to get the latest ID of tblSource1 and explicitly insert this value into tblSource2 and tblSource3. Your stored procedure can be something like the following: Insert into tblSource1(faq
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
vijayakrishna
on 10/9/2008
Re: Matching each value out of multiple values to single column value
I verified the function ufn_ALINES and it is working fine. To see it as working, run the following query in your SQL Server Management Studio. select * from dbo.ufn_ALINES('Builder Owner Agent', ' ' ) And at the same time you can run your stored procedure in the same place something like using the following dbo.flatsearch '1BHK','First Floor', 'unit,500,'Andheri',1000000,2000000,2,2,'feature1,feature2,feature3','agent builder' If user does
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
vijayakrishna
on 10/7/2008
Re: Matching each value out of multiple values to single column value
I have changed the inner join in Naom's query to Left Outer Join, try the following. I am not sure whether your column name is Poste_by or postedby. However I used postedby as you used it in the select query. SSMS means SQL Server Management Studio i.e. where you are creating your stored procedure. SELECT ptype, rate, location,area,areaunit, bedroom,features,bathroom,moreinfo,tel,mobile,email,postedby FROM sellproperty INNER JOIN dbo.FN_SPLIT(@featuresofflat) r ON sellproperty.features LIKE
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
vijayakrishna
on 10/7/2008
Re: Can this be done using Response Object ??
Google for RegisterClientScriptBlock and RegisterStartupScript
Posted to
Client Side Web Development
(Forum)
by
vijayakrishna
on 10/4/2008
Re: File.delete() isnt deleting the file after it's downloaded....help please
Response.TransmitFile(file.FullName) just sends a copy of your file to the user, it is not going to delete it. If it is so, you need not require the File.Delete() statement.
Posted to
Getting Started
(Forum)
by
vijayakrishna
on 10/2/2008
Re: File.delete() isnt deleting the file after it's downloaded....help please
[quote user="Mazenx"]I read somewhere that i cant download the file unless it's in the website directory [/quote] The above is wrong. To write a file to a folder permissions are required. In fact, you yourself accessing the files from C:\Uploads folder. So, try to transmit that file itself. There is no necessity of copying and removing it.
Posted to
Getting Started
(Forum)
by
vijayakrishna
on 10/2/2008
Re: Convert Stored Procedure to T-SQL
Your query can be something like this strSQL += "IF NOT EXISTS (SELECT UserID, PhoneID from Hyperion_Workflow WHERE (UserID=" + txtAssignedUser.Text + ") and (PhoneID=" + txtPhoneID.Text + "))" ; strSQL += " INSERT INTO Hyperion_Workflow(UserID, PhoneID, DateAssigned) VALUES (" + txtAssignedUser.Text + "," + txtPhoneID.Text + "," + "GetDate())" ; If the UserID and PhoneID are not numeric then make sure to enclose them with single
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
vijayakrishna
on 10/2/2008
Re: File.delete() isnt deleting the file after it's downloaded....help please
I achieved this in some different way. protected void Page_Load( object sender, EventArgs e) { string path1 = Server.MapPath(@ "images\Thirsty Crow.wav" ); FileInfo file = new FileInfo(path1); Response.ClearContent(); Response.AddHeader( "Content-Disposition" , "attachment; filename=Thirsty Crow.wav" ); Response.AddHeader( "Content-Length" , file.Length.ToString()); Response.ContentType = "application/octet-stream" ; FileStream fs = new FileStream
Posted to
Getting Started
(Forum)
by
vijayakrishna
on 10/2/2008
Re: Convert Stored Procedure to T-SQL
The following is working at my end on SQL Server 2005 protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strSQL = ""; strSQL += " IF NOT EXISTS ( SELECT [Name] FROM test1 WHERE [Name] = 'Paruchuri' )"; strSQL += " INSERT INTO test1([Name]) VALUES ( 'Paruchuri' )"; SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["vijayConnectionString"].ConnectionString); SqlCommand cmd = new SqlCommand
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
vijayakrishna
on 10/2/2008
Re: Convert Stored Procedure to T-SQL
Try this IF NOT EXISTS ( SELECT UserID, PhoneID from Hyperion_Workflow Where (UserID=@assignedUser) and (PhoneID=@assignedPhoneID)) INSERT INTO Hyperion_Workflow(UserID,PhoneID,DateAssigned) VALUES (@assignedUser,@assignedPhoneID, GetDate ( ))
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
vijayakrishna
on 10/2/2008
Page 1 of 23 (223 items) 1
2
3
4
5
Next >
...
Last ยป
WindowsClient:
ASP.NET AJAX 4.0 Data Binding on MSDN Magazine
TechNet Edge:
Improving Collaboration with SharePoint - Tech Focus December 2009 Part 1
Channel 9:
Channel 9 Live at PDC09: Scott Guthrie
Channel 10:
Get Bing Wallpapers on the iPhone
Channel 10:
Get Discounted Concert Tickets at the New Windows Section 7
Channel 10:
Bing Gets a New Toolbar
ASP.NET:
More on medium trust: what permission are you missing?
Channel 9:
Channel 9 Live at PDC09: Bob Muglia
WindowsClient:
Adventures With Windows Azure Diagnostics
Mix Online:
Adventures With Windows Azure Diagnostics
Channel 9:
Channel 9 Live at PDC09: Ray Ozzie
Channel 9:
Coding4Fun: DrinkTendr
Channel 9:
TWC9: Scott Hanselman, John Galloway, Bing, parallel unit tests, more
TechNet Edge:
ISA to TMG Migration Guidance
Channel 9:
Life at Microsoft: Episode 3
TechNet Edge:
Microsoft Windows Server 2008 to AITP
ASP.NET:
How important is medium trust to you?
WindowsClient:
Microsoft Web Platform & You
WindowsClient:
New Book: Developing for Microsoft Surface
Channel 9:
BugCamSmash in Action!
Microsoft Communities
ASP.NET
Channel 8
Channel 9
Channel 10
IIS.NET
Silverlight
TechNet Edge
WindowsClient
Mix Online