|
nikhil1234 wrote: plz tell me sql
First of all This is ASP.NET Forum. And you question is related to SQL
nikhil1234 wrote: select name from names where name like '%jhone lee%' correct result
select name from names where name like '%lee jhone %' correct result
plz tell me sql
Then why you are not trying this:
select name from names where name like 'jhone %'
|
|
|
|
|
You can take this as an example:
DECLARE @Delimitedtext varchar(max);
DECLARE @Delimiter char(1);
SET @Delimitedtext = 'Manas Bhardwaj';
SET @Delimiter = ' ';
DECLARE @FName nvarchar(max)
DECLARE @LName nvarchar(max)
SELECT
@FName = SUBSTRING(@Delimitedtext,1, CHARINDEX(@Delimiter, @Delimitedtext)-1),
@LName = SUBSTRING(@Delimitedtext,CHARINDEX(@Delimiter, @Delimitedtext)+1, len(@Delimitedtext))
Select
[name]
from
names
where
[name] like '%' + @FName + '%'
or
[name] like '%' + @LName + '%'
I have assumed here that the name will always be comprised of FirstName and LastName.
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Hi,
There is a strange thing in 3.5 Ajaxtoolkit framework:
With Ajaxtoolkit first version (1.0) , put a wizard (and its wizard steps) in an updatepanel worked good.
It's not the cas with last version of Ajaxtoolkit (3.5) : it generates 405 and 120XX errors.
the code is very simple to test it:
<form id="form1" runat="server">
<asp:ScriptManager ID="asm" runat="server" />
<div>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:Wizard ID="Wizard1" runat="server">
<WizardSteps>
<asp:WizardStep runat="server" StepType="Start" Title="Ready!">
</asp:WizardStep>
<asp:WizardStep runat="server" StepType="Step" Title="Set!">
</asp:WizardStep>
<asp:WizardStep runat="server" StepType="Finish" Title="Go!">
</asp:WizardStep>
</WizardSteps>
</asp:Wizard>
</ContentTemplate>
</asp:UpdatePanel>
</div>
</form>
(Microsoft article : http://www.ibuyspy.com/learn/Ajax-Control-Toolkit/tutorial-45-cs.aspx)
Have you got the same ?
It does exist a solution ?
Si tu aimes ce que tu fais , tu finis par réussir !
(french proverb of David Zenou)
|
|
|
|
|
Hi,
I have a page which contains an Ajax Accordion control with multilple panels. Each panel contains one or more textboxes. What I would like to happen is this; when the user tabs from the last textbox in a panel, the next panel expands and the first textbox in that panel gets focus.
Is this possible? and if so could you please point me in the right direction. I know how to expand a particular panel but don't know how to catch the key press event on the textbox.
Thanks for your time.
|
|
|
|
|
The onblur method of the textbox on the client, will fire when the control loses focus.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Worked a treat, thanks
|
|
|
|
|
Liqz wrote: Worked a treat, thanks
Then you should marked that post as Good Answer
|
|
|
|
|
You're absolutely right, forgive me, I'm a forum noob as well as a programming noob!
|
|
|
|
|
Liqz wrote: I'm a forum noob as well as a programming noob!
All the best.
|
|
|
|
|
Abhijit Jana wrote: Then you should marked that post as Good Answer
And you get 5 from me for understanding him courtesy.
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Hai,
I Have done crystal report in my project.but how to upload in server.what are configuration i check.if you know replay me..
Thanks in advance.
|
|
|
|
|
Hi!
I have made a small project (in ASP.NET and C#) which connects to SQL Server 2000 Database through an ODBC DSN for which I have written the Query String in the Web.Config File.
The Project is running fine in the ASP Dev. Server.
When I hosted the Site in a Remote Server, its working fine there too.
But
When I am trying to Run it through IIS (locally) (The Project is still the same and No Changes has been made to it), then I am getting the following Error:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
|
|
|
|
|
Look at this[^]
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Good Day ALL
I have a UserControl that has a Dropdownlist. In the Hosting Page i have a Ultrawebgrid that gets updated based on the Selecteindexchange event the the dropdown. I have have another Control on the Left hand side that needs to be Updated on Selecteindexchange of the Drop down. Now the Left hand side Control Works and it gets updated but the Grid does not get updated. I have attached a link to photo of my design
http://www.vuyiswamaseko.somee.com/GRid_Update.JPG
Here is a Definition of my Grid
<igtbl:UltraWebGrid ID="Gridstaff" runat="server" Height="158px" StyleSetName="RubberBlack"
Width="400px">
<Bands>
<igtbl:UltraGridBand>
<AddNewRow View="NotSet" Visible="NotSet">
</AddNewRow>
</igtbl:UltraGridBand>
</Bands>
<DisplayLayout BorderCollapseDefault="Separate" LoadOnDemand="Automatic" Name="ctl02xUltraWebGrid1"
RowHeightDefault="20px" SelectTypeRowDefault="Extended" Version="4.00">
<FrameStyle Height="158px" Width="400px">
</FrameStyle>
<ActivationObject BorderColor="" BorderWidth="">
</ActivationObject>
</DisplayLayout>
</igtbl:UltraWebGrid>
Thank you
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.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Sounds like you bought a third party component, and should really be asking them how to use it.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I have Tested with MS Gridview and it does not get updated too.
This is how i Bind the grid.
In my UserControl i have Exposed the event to the Hosting page like this
public event EventHandler SubjectChange;
protected void OnSubjectChange(EventArgs e)
{
if (SubjectChange != null)
{
SubjectChange(this, e);
}
}
and in the selectedindexchange event of the dropdownlist i have the the code like this
OnSubjectChange(e);
and in my Hosting page i have
override protected void OnInit(EventArgs e)
{
this.ActivityCtrl1.TextChanged += new EventHandler(ActivityCtrl1_TextChanged);
InitializeComponent();
base.OnInit(e);
}
and the method InitializeComponent() is defined like this
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
SubjectSelector1.SubjectChange += new EventHandler(SelectedSubjectChange);
}
and the Subjectchange is Defined like this
private void SelectedSubjectChange(object sender, EventArgs e)
{
LoadControlsForSelectedSubject();
Bind_Staff_Cycle_Grid();
}
the Method Bind_Staff_Cycle_Grid() is the One that Binds the GRid
and i have defined it like this
private void Bind_Staff_Cycle_Grid()
{
if (!Page.IsPostBack)
{
BLL.BLL obj = new BLL.BLL();
String Subject_Descr = Convert.ToString(Session["SelectedSubject"]);
DataTable dt = new DataTable();
String DB = Convert.ToString(Session["ActiveDatabase"]);
try
{
obj.TRUNCATE_TABLE_FINAL(DB);
dt = obj.Get_Staff_Cycles(Subject_Descr, DB);
if (dt.Rows.Count > 0)
{
Gridstaff.DataSource = dt;
Gridstaff.DataBind();
UpdatePanel2.Update();
}
}
catch (SqlException ex)
{
lblGridStaff.Text = ex.Message;
}
finally
{
obj = null;
}
}
}
and my Gridview's Defination is
<asp:GridView ID="Gridstaff" runat="server" OnSelectedIndexChanged="Gridstaff_SelectedIndexChanged"
Width="385px">
</asp:GridView>
Thanks
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.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Remove if (!Page.IsPostBack) from Bind_Staff_Cycle_Grid. Becuase IsPostBack will always be true SelectedIndexChanged event.
Therefore the code inside the if(!Page.IsPostBack) will not be executed in that event.
|
|
|
|
|
Thank you that worked like charm
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.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
If you set breakpoints in all these methods, what do you find ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
The Break point does get to the method but the Grid does not get updated. i will check the blog
Thank you very much
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.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Good Morning Chriss
What dotnet buddy said it really worked it solved the Problem. thank you very much.
one more Question there is time when you asnwer posts here on the forum you always do somthing like
Vuyiswa wrote | .............
how do you do that? i mean the tags you use.
Thanks
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.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Hello All,
I want to draw a rectangle by using any image. Can any one please help me on this?
Thanks
Hitesh Rank
|
|
|
|
|
Your question makes no sense. Try asking it again.
The only ways to draw images on an ASP.NET webpage, are SVG ( if they can be forced to install it ), CSS ( if you want to draw just a rectangle ) or through styling the page with bitmap images.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Dear All,
My client given one web service. when i add the service using that method its showing following error.
Failed to get operation name from the incoming request
if any body have idea help me
|
|
|
|
|
Did you get the answer for this? If yew, please suggest me how to rectify this.
|
|
|
|