ASP.NET

mehrdadc48 wrote:

Hi,
I have a table 'Tbl1' with 3fields: NidTbl1, NidTbl2,number.
NidTbl1 is primary key and NidTbl2 is a foreign key.
Now how can I get the NidTbl1 which all number fields are greater than 0

mehrdadc48 wrote:

Now how can I get the NidTbl1 which all number fields are greater than 0

Select NidTbl1 from Tbl1 where number >0

mehrdadc48 wrote:

Now how can I get the NidTbl1 which all number fields are greater than 0

Select * From Tbl1 Where NidTbl1 > 0

mehrdadc48 wrote:

Sorry I went wrong,
I meant the NidTbl2 s which all number fields are greater than zero

SELECT * from TBL1 WHERE NidTbl2 > 0

Flavia A wrote:

the user should be able to see all the data that he has entered in the textboxes (temporarily)

protected void Page_Load(object sender, EventArgs e)
{       ShowAlerts(_alertService.GetStatusAlertsByAccountID(_userSession.CurrentUser.AccountID));          
}

public void ShowAlerts(List<Alert> Statusalerts)
        {
            repStatus.DataSource = Statusalerts;
            repStatus.DataBind();
            if (repStatus.Items.Count == 0)
                lblStatusMessage.Text = "You don't have any status alerts yet!";
           
}

        protected void btnShare_Click(object sender, ImageClickEventArgs e)
        {
            
            StatusUpdate su = new StatusUpdate(); // Statusupdate table
            su.Status = msgText;
            _alertService.AddStatusUpdateAlert(su);
             }                     
            txtStatusUpdate.Text = "";            
        }

MD. SHAHDAT HOSAIN wrote:

protected void Page_Load(object sender, EventArgs e)
{ ShowAlerts(_alertService.GetStatusAlertsByAccountID(_userSession.CurrentUser.AccountID));
}

protected void Page_Load(object sender, EventArgs e)
{      
if(!Page.IsPostBack)
 {
 ShowAlerts(_alertService.GetStatusAlertsByAccountID(_userSession.CurrentUser.AccountID));          
 }
}

MD. SHAHDAT HOSAIN wrote:

But a little problem show yet. if more than one status post within 60 seconds then later post print under the previous one.

Flavia A wrote:

can have a masked textbox in asp.net website?

if(select count(*) from tablename where username='username') >0)<br />
begin<br />
print 'Username exists'<br />
else<br />
print 'username does not exists'<br />
end

rummer wrote:

Hi i want to check that this name exist in database or not.

rummer wrote:

ya also we want to check that name is allready exist or not