|
Hi all,
I have the following gridview which has got a text box for any record entry of data on the grid.
when i want to write some code for the TextBox, I cant see it on the code View.Is there any way i can access Textbox1 on the code associate it with the record on the grid.
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="LiveMsg" DataSourceID="SqlDataSource2">
<Columns>
<asp:BoundField DataField="LiveMsg" HeaderText="LiveMsg"
SortExpression="LiveMsg" />
<asp:TemplateField HeaderText="Message">
<ItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Width="1000"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText=" ">
<ItemTemplate>
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
<asp:Button ID="btnSend" runat="server" Text="Send"/>
</ItemTemplate>
</asp:TemplateField>
</column>
</Gridview>
Thanks in advance for your help.
-- Modified Sunday, February 21, 2010 2:16 PM
|
|
|
|
|
When you bind to multiple rows, what would you expect to see with a single ID for the textbox? You can't have multiple items called the same thing so you need to get at it some other way; and that way (unfortunately) is to use the Cells collection of the row you're interested in. This property provides you with indexer access to each cell, so you'll have to refer to something like Cells[0] to get the first textbox (bearing in mind you'll need to cast it to the appropriate type)."WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
I have a service running which runs FileWatchers to detect changes and new accounts.
Currently when a file is received I call my file manager which:
creates the context for incoming db and outgoing db
adds/updates account
submits changes
destroys contexts
My Problem: My service regularly dies on what appears to be the second record stating that the first context failed to connect because it could not log in. This happens when I use the service ID as well as using sa!!! The interesting thing is during debug my SECOND context connected correctly and I could access everything.
This leaves me wondering if I should create the context's at the service start, continue to use them over and over again, then destroy the context only when the service shuts down.
It seems that while it keeps a resource around for a long time, it should be okay since the context functions in a disconnected fashion.
Comments?
Thanks.
|
|
|
|
|
No, you should not create the context when the service starts. Create and open the context when necessary and close it as soon as you are finished, let the connection pool manage when to destroy it.
What credentials are you using in the connection string? Do they have the proper access? You should not be using the sa account.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
I setup the service with it's own ID. Established access and Securables.
I double check the accesses both from my workstation as well as my server using a query tool to ensure I'm connecting the same way the service is.
I start the service then move the files into the folder. The first context ALWAYS fails when created by the service yet succeeds when I use the query tool to connect specifying the same database as my starting database.
When I change the ID to 'sa' I also get the SAME FAILURE. At time I get the service running and it succeeds but later when a new account comes in the service crashes due to login failure.
I've run the debugger against it and the same credentials going against the other database works just fine. When I check the Sql Server log it shows 'login failed for user id {my service id}'.
I'm at a TOTAL loss as to what to do. I've approached this problem from EVERY angle including posting the issue to the MS forums hoping MS can help as well and have yet to find the fix to the problem.
|
|
|
|
|
Member 6966224 wrote: including posting the issue to the MS forums hoping MS can help as well
It's not a Microsoft problem.
Member 6966224 wrote: using a query tool
What tool?
You clearly do not have the proper connection string or are not using it, or the objects, properly. Show what you are doing and maybe we can help point out your problem.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
I downloaded a query tool (not the Sql Manager Studio) to do the test. I'm not at work so I don't know the name. I know it isn't an MS problem but they may be able to provide an answer. Everything there says the connection should work.
|
|
|
|
|
The microsoft forum ended up being a help.
One poster had indicated that the only thing that can be wrong is my connection string.
Well, I looked at every single bit of it after that and opened up my Sql browser and compared table names, database names, etc.
it ends up I had the absolute worst bug to find: I typed an 'o' when I should have typed an 'a'. After that the service ran just fine.
|
|
|
|
|
Hi,
Can anyone tell me how can i retrieve my MS Access database on a webpage by using web service? i need to do this using asp.net in c# language.
thanks.
|
|
|
|
|
And what do you know about web services? Have you done any research?
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
dalila y wrote: Can anyone tell me how can i retrieve my MS Access database on a webpage by using web service? i need to do this using asp.net in c# language.
I just finished watching a video[^] on Channel9 - takes 10 minutes of your time. They're using SQL Server and not MSAccess, but it should be enough to get you started  I are Troll 
|
|
|
|
|
Hello all - I'm curious as to whether anyone on this forum knows of any generics "labs" that exist. Specificially, I'm looking for exercises where I need to come up with a solution and have access to an answer when I get stumped or can find out the "real" (or better) way to solve the question.
|
|
|
|
|
None that I can think of.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi,
I have wriiten a little application that runs mainly in the background. There is a U.I. trhat can be accessed by double clicking its icon in the notification bar. The problem is when I try to restart or shut down my XP machine the application will not close. This appears to be not an issue on Windows 7 as it shutsdown fine, I suspect Vista could be ok also.
I checked the event viewer the event was to the effect The attempt to reboot PC failed. I have read a little and I added the following to my code
private int WM_QUERYENDSESSION = 0x11;<br />
<br />
protected override void WndProc(ref Message m)<br />
{<br />
if (m.Msg == WM_QUERYENDSESSION)<br />
{<br />
Application.ExitThread(); <br />
} <br />
base.WndProc(ref m); <br />
}
This works in as much as the application closes when I try to restart my machine, but the machine does not restart I have to tell to restart once more before it restarts. I feel it's almost there but I am not sure what is missing.
Help if you can, Dave.
|
|
|
|
|
I have also added : Application.Exit(); to the above code to no effect
|
|
|
|
|
I would guess that your problem is that your call to Application.ExitThread() means that the call to base.WndProc(ref m) never happens. What happens if you call the base function first?
|
|
|
|
|
Tried what you suggested. Still have the same problem, in that the app closes but seems to stop the machine from closing down until I try to restart for the 2nd time.
|
|
|
|
|
Hi,
AFAIK there is no need to override WndProc for this. Just add your handler to the SystemEvents.SessionEnding event and exit the application.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that. All Toronto weekends should be extremely wet until we get it automated in regular forums, not just QA.
|
|
|
|
|
|
Why would SessionEnding, that has exactly the purpose you're after, not work, when Microsoft has offered it since day 1 of .NET?
May i suggest, when you read some stuff, you read it carefully, all the way to the bottom.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that. All Toronto weekends should be extremely wet until we get it automated in regular forums, not just QA.
|
|
|
|
|
Houdy,
I need a class that checks/validates file types.
Of course this is needed in cases where you can't trust the extension to supply that info.
I thought about Magic Numbers as an option - does anyone have an already built app - any language will do
Also if you have ideas on how to accomplish this task (like MIME etc) in a better way I am all 
Surprising to see so few samples and sources for Magic Numbers on google...
Thanks a bunchTzumer
|
|
|
|
|
hi
how i can return dataset to datagriedview
My business layer is memberBL Class
My Data Access Layer Is memberDA Class
My view Dataset Code in memberDL Class is:
public DataSet View(memberBL member)
{
DataSet ds = null;
try
{
OpenCnn();
String selectStr = "select * from " + thisTable + "'";
OleDbDataAdapter da =new OleDbDataAdapter(selectStr, cnn);
ds = new DataSet();
da.Fill(ds, thisTable);
CloseCnn();
}
catch (Exception e)
{
String Str = e.Message;
}
return ds;
}
How I Can return Dataset in GriedView in Form?
hoW i can use in ds IN windows FORM?
|
|
|
|
|
well that's easy. Something like:
dataGridView1.DataSource = ds.Tables[0];
|
|
|
|
|
program is layering & ds in not known in form
first ds come in business layer then view in datagried
it is not easy my dear friend
|
|
|
|
|
I'm sorry I don't understand.
what do you mean by "ds in not known in form"?
An by this "first ds come in business layer then view in datagried"?
Do you have problem returnig the dataset from your bussines layer to your UI?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
