|
Hi,
<asp:SqlDataSource ID="grid_source" runat="server" ConnectionString="Data Source=db;Initial Catalog=faq;User ID=sa;Password=mercury"
ProviderName="System.Data.SqlClient"
SelectCommand="SELECT [c_empcode], [c_name], [c_designation], [c_department], [c_emailid], [c_reportingPerson], [c_passwd], [n_status] FROM [Employee_Mst] where n_deleted =0"
OnSelecting="grid_source_Selecting"
FilterExpression="c_name like '{0}%' and c_department like '{1}%' " >
<FilterParameters>
<asp:ControlParameter Name="c_name" ControlID="txtname" PropertyName="Text" />
<asp:ControlParameter Name="c_department" ControlID="txtdepart" PropertyName="Text" />
</FilterParameters>
</asp:SqlDataSource>
This is my sqldatasource in that i used filter expression for filtering data . if txtdepart textbox is empty means its
not filtering records according to what i entered in txtname texbox .if i am entering some datas in all two textbox's then its
showing filtered records . can anyone tell me the solution for this ?
also i need how to change the filter expresion at runtime according to these textboxes values .
Thanks in advance
|
|
|
|
|
The SQLDataSource classes are not suitable for real world programming. If you're doing a professional project, you should not use them.
What you're describing seems to me to be a bug in the classes tho, what have you turned up on google, I'd expect other people would have asked the same question.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
i m using serverside object tag in my application
it is showing an error
Error 4 Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
any one can help me?
|
|
|
|
|
Wow - you're really stupid, too.
1 - this has nothing to do with ASP.NET, it's a pure HTML question
2 - perhaps you could tell us why you think you've entered a valid GUID, and post your code, so we can explain to you why you're mistaken. The answer is, you need to enter a GUID in the correct format. That's what the error says.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
i m not playing with guid anywhere
i m new to asp.net
how can i fix this error
|
|
|
|
|
i write this code in my sqlserver does anybody know why it doesnt work. it has error in inner join. plz help 
UPDATE [servername1].[WebSite].[dbo].[Table_1] INNER JOIN [servername2].[website1].[dbo].[Table_2] ON Table_1.id = Table_2.id SET Table_1.name1 = [Table_1].[name2]
|
|
|
|
|
This is ASP.NET Forum , please post it in SQL Forum.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Do not Post SQL Questions here. I hope its the Last time you do this. You need to use a "from" like this
UPDATE [servername1].[WebSite].[dbo].[Table_1]
SET Table_1.name1 = [Table_1].[name2]
FROM [servername1].[WebSite].[dbo].[Table_1]
INNER JOIN [servername2].[website1].[dbo].[Table_2]
ON Table_1.id = Table_2.id
pre>
Check the your Statement from the Bolded and what ever follows
Hope this Helps
Vuyiswa Maseko
<div class="ForumSig">Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http:
vuyiswa@its.co.za
www.ITS.co.za
</div>
|
|
|
|
|
thanks for ur help, yes is it work now but if my tables be in diffrent server it has error i have problem when i have 2 server
and thats error is : Could not find server 'SPSERVER16' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
|
|
|
|
|
Check your Permissions in the Link Servers
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
i run this:
EXEC sp_addlinkedserver
@server = 'SPSERVER16',
@srvproduct = '',
@provider = 'SQLNCLI',
@datasrc = 'SPSERVER16'
GO
and then run this:
EXEC sp_addlinkedsrvlogin spserver16, FALSE, sa, 1234
and its succses
and then run:
EXEC sp_tables_ex spserver16
GO
and it has this error:
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
|
|
|
|
|
Why don't you add a link Server manually not from T-SQL, supplies the credentials there , and in your Code you call the name of the Link server. Doing it in T-SQl you might encounter credentials Problem
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
both of them is equal, when i manually create linked server i has this problem too
|
|
|
|
|
Talk to your DBA about the Problem , remember again not everyone can create a Link server, sometimes you might Create a link server and not have permissions to access data on the Other side. Your have a permission Issue.
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
heyyy finally i can solve the problem this form with 3 procdure:
///////
1.
EXEC sp_addlinkedserver
@server = 'SPSERVER16',
@srvproduct = '',
@provider = 'SQLNCLI',
@datasrc = 'SPSERVER16'
GO
////////
2.
EXEC sp_addlinkedsrvlogin spserver16, FALSE,SADAFIT-9D6E926\administrator,sa ,1234
////////
3.
EXEC sp_tables_ex spserver16
GO
thanks for ur help Vuyiswa Maseko![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
am Glad you Solved it ,
Welcome 
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
Hi,
What's the attribute for showing a custom event of a usercontrol in properties window of Visual Studio?
Best wishes
|
|
|
|
|
Hi.
How can I handle Print event of Microsft ReportViewer control?
There is no explicit event for it, but I need to do something when print is fired.
Best wishes
|
|
|
|
|
Any Luck with this? I am trying to achieve the same thing.
|
|
|
|
|
Actually No!
Aware me if you find a way, please
Best wishes
|
|
|
|
|
Didnt really find how to do it in Native Report Viewer (MS Control) so far.
therefore, we are looking into third party controls.
So far, the reportViewer in ComponentOne
(Link) looks promising, and it supports SSRS. Also, AJAX is a prerequisite for this, which might be benifitial.
Another one was Telerik which allows you to monitor Client Side Events on server, but the only problem with that is, you have to design reports in their designer only, and thus, no support for ".rdl" files.
i am going to look further for about another week, if i find any solution, would definitely let you know.
Best
SD
|
|
|
|
|
|
Hi,
I am developing web app and:
I have a text box and a drop down list.If i enter a data into the text box i've to show the new entry in the dropdown list at that time itself.If i refresh the page i could see the change ,but is there any other way?
Help me.
|
|
|
|
|
Subin Alex wrote: .If i enter a data into the text box i've to show the new entry in the dropdown list at that time itself.If i refresh the page i could see the change ,but is there any other way?
I didn't get your question.
My understanding is that,You have one textbox and a dropdown list, You are entering some data in textbox and you want some data will be populated to dropdown list. Is it correct?
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
