ASP.NET

bind data from textboxes to griview

5-Sep-09 3:12

You seriously think of buying a book. OMG | :OMG:

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

The only change would be thn:

SELECT * from TBL1 WHERE NidTbl2 > 0

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.

Re: A Query

Blue_Boy5-Sep-09 5:28

Blue_Boy

5-Sep-09 5:28

I just agree with others who replied your question.
You have already answer for your question.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

Flavia A5-Sep-09 0:31

Flavia A

5-Sep-09 0:31

hi,

Is there some way in which i can bind the data of the textboxes,dropdownlists in a gridview,make it available for editing and then finally send it to the database.
the user should be able to see all the data that he has entered in the textboxes (temporarily)

Re: bind data from textboxes to griview

Abhijit Jana5-Sep-09 0:34

Re: bind data from textboxes to griview

5-Sep-09 0:34

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

Gridview having its inbuild features of that. Are you looking for something different ?

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Flavia A5-Sep-09 1:58

Flavia A

5-Sep-09 1:58

i guess the data can be retreived from the database in a gridview then the data can be edited and sent back to the database.But what i want is in one form if there are 2 textboxes and 3 dropdown lists the data selected in the dropdown and text boxes should be available in the gridview or something similar for editing before going into the database and later it can go into the database.ie a temprory storage which later gets finalized and then sent to the database.
This is possible in the window application using datagrid.

Re: bind data from textboxes to griview

deepseeindeepsy5-Sep-09 2:43

deepseeindeepsy

5-Sep-09 2:43

See, You can fetch data into DataGrid as u like. U can use templates to put custom controls,just like u told abt textboxes & ddl.After that u can edit the data as u like using ButtonField like features of DataGrid. Is it so in ur way?
Smile | :)

Repeater in update panel

Shahdat Hosain5-Sep-09 0:30

Shahdat Hosain

5-Sep-09 0:30

I want to develop status update like facbook's status update.
To do this job I use following technique.

I placed a repeater, textbox and button into a updatepanel. Repeater contain a label to show all status from DB. When a user click on the button, the text will save on DB. And all status( including new) will be shown automatically by repeater after updating database.

Here is my problem: After first clicking text is saved on DB. But page doesn't update with new status. After second click page update with the new status.

Have any problem in my concept? If yes. Plz inform me how can I update the repeater automatically after DB updating .

shahdat

Abhijit Jana5-Sep-09 0:37

5-Sep-09 0:37

When you are loading data in Repeater Control ? I guess there is problem related with PostBack.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Shahdat Hosain5-Sep-09 0:58

Shahdat Hosain

5-Sep-09 0:58

I seems as you. Plz verify my c# code

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

plz help me.

shahdat

Abhijit Jana5-Sep-09 1:25

5-Sep-09 1:25

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

Try this following,

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

And Call the ShowAlert Method After the Table, means on Share Button Click.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Shahdat Hosain5-Sep-09 2:22

Shahdat Hosain

5-Sep-09 2:22

Thanks Im successful on behalf of your suggestion.

But a little problem show yet. if more than one status post within 60 seconds then later post print under the previous one. Is it a mater of timer or anything else.

Plz suggest me.

shahdat

Abhijit Jana5-Sep-09 2:26

Can we have a masked textbox in asp.net website

5-Sep-09 2:26

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.

I didn't get your point. Sorry Confused | :confused:

Can you please explain me in little details . Hope I may help you Smile | :)

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Flavia A5-Sep-09 0:24

Flavia A

5-Sep-09 0:24

Is there any way in which i can have a masked textbox in asp.net website?
i want 4 alphabetical characters to be entered in the begining of the textbox and the remaining to be numeric .
or can i have a javascript code to validate the textbox.

Re: Can we have a masked textbox in asp.net website

CrazyCoder265-Sep-09 0:26

CrazyCoder26

5-Sep-09 0:26

download ajaxcontrolToolkit....you will find it there.

CC26

Re: Can we have a masked textbox in asp.net website

Abhijit Jana5-Sep-09 0:28

chek name is this exist or not in database

5-Sep-09 0:28

Flavia A wrote:
can have a masked textbox in asp.net website?

Here is few good reference for you Smile | :)

Xtended TextBox[^]
and
MAsked TextBox[^]

Hope this will help you Big Grin | :-D

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

rummer4-Sep-09 23:32

rummer

4-Sep-09 23:32

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

thanks
vivek

Re: chek name is this exist or not in database

Blue_Boy4-Sep-09 23:37

Blue_Boy

4-Sep-09 23:37

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

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

Re: chek name is this exist or not in database

Abhijit Jana4-Sep-09 23:39

check name allready exist or not

4-Sep-09 23:39

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

Create Simple SP, Pass the User Name as a parameter and check it is available in database or not. If yes, then alert user that User already exist, else go ahead.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

rummer4-Sep-09 23:02

rummer

4-Sep-09 23:02

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

Abhijit Jana4-Sep-09 23:07

4-Sep-09 23:07

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

Please dont cross Post.
No one can understand your question, if they didn't read the last post. So, Either reply of my question or Modify your Last Post Smile | :)

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Manas Bhardwaj5-Sep-09 0:39

5-Sep-09 0:39

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

Would you care to elobrate that?
What is the scenario? What have you done so far?

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.

Abhijit Jana5-Sep-09 0:52

5-Sep-09 0:52

He has asked the same question Three times, but He is not still clear what he want or may be he is not able to express.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Manas Bhardwaj5-Sep-09 1:12

5-Sep-09 1:12

That is why I loved this line which I read somewhere.
'Everyone can program, but not everyone can be a programmer'

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.

Abhijit Jana5-Sep-09 1:28

5-Sep-09 1:28

Manas Bhardwaj wrote:
I read somewhere.

May be from Here[^] Smile | :)

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Manas Bhardwaj5-Sep-09 1:45