ASP.NET

nikhil1234 wrote:

plz tell me 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

select name from names where name like 'jhone %'

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  + '%'

Liqz wrote:

Worked a treat, thanks

Liqz wrote:

I'm a forum noob as well as a programming noob!

Abhijit Jana wrote:

Then you should marked that post as Good Answer

public event EventHandler SubjectChange;

protected void OnSubjectChange(EventArgs e)
{
    if (SubjectChange != null)
    {
        SubjectChange(this, e);
    }
}

OnSubjectChange(e);

override protected void OnInit(EventArgs e)
{
    this.ActivityCtrl1.TextChanged += new EventHandler(ActivityCtrl1_TextChanged);

    InitializeComponent();

    base.OnInit(e);
}

// On main page handle the incomming events
   private void InitializeComponent()
   {
       this.Load += new System.EventHandler(this.Page_Load);
       // Catch SubjectChange events fired on the subject selector
       SubjectSelector1.SubjectChange += new EventHandler(SelectedSubjectChange);
   }

// When a subject is changed on the subject selector
private void SelectedSubjectChange(object sender, EventArgs e)
{
    LoadControlsForSelectedSubject();
    Bind_Staff_Cycle_Grid();
}

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;
           }
       }
   }

<asp:GridView ID="Gridstaff" runat="server" OnSelectedIndexChanged="Gridstaff_SelectedIndexChanged"
                                                           Width="385px">
                                                       </asp:GridView>