Comments by njammy (Top 200 by date)

Please explain in more detail what Ageing column is for?

Can you not use a MS SQL Sequence object?

Where is your menu items markup?

Please can you update your question with markup for the menu items.

What is the type declared of model.ISBN?

Please can you update your question with markup.

How?

1. It could be that Gmail and yahoo have blacklisted the IP or source domain that you are using to send the emails.
2. You will not get a .net exception on failed email sending, because the Yahoo and Gmail services do not send a error response deliberately. This is so that potential spammers do not become wiser on whether the emails being spammed are valid or not.
3. The email accounts might be inactive or full, again the response will not be given due to reason 2.
4. Try using a well respected provider, if not already to send the emails from your system and see if the problem is recreated.

What is your question?
Please state the exact issue you are facing with reference to your lines of code.
Please give us idea of what the controls state is and where you are facing problem.

how did you deploy the app to the client?

what?

Then there is something wrong with the server not your code

What happens when you access the url from your browser directly?

Elaborate

Please move this code to the question main body

What is the version of the dll: "CrystalDecisions.Shared.SharedUtils"? (select the reference in visual studio and hit F4 to see properties)

In order to get an answer, please update your question with paragraph explaining your current problem and some sample code of what you already tried then we have more information to give an answer, thank you.

Ok good. So what does the line DropDownList dropDownLst = (DropDownList)e.Row.FindControl("ddlIndustrialarea"); return? I mean what is the value of dropDownLst?

What is the value of userdetailsBAL on the line:
<pre lang="c#">DataTable dt = userdetailsBAL.getindustrialarea();</pre>

Ok thanks for the tip. Happy trolling.

I have many a time taken inspiration from code from years ago, that's the
beauty of the internet. And someone may use my answer in 3 years time.

Book mark this page so you can further comment after 6 years.

Will only work if you know all possible unique ParentIds, or have the time to type it all out manually.

lol.

I meant what verbal spoken human language is it...

What language is that?
Look at development for multi-regional translation using resource file.

The view model and JSON can have totally different properties. Design your view model only for the data you need for that http response. and do the same for JSON objects. No need to copy and reuse view models when you don't need all fields.

This code will not work. You are assigning HTML content to html input fields, which require plain text, not html. I thought from your original question you want to display html returned from a ajax call? then is totally the opposite of what you want to do.

Looking back at your code, your method GetcompanyInfo is returning JSON data not html.

you need to change the ajax call config like my updated answer, and set the field values in the udpated logic in the answer.

Where are these values stored? text file? database? constants?

Your code doesn't set the data source to the report viewer control. Set that and then reaload it.

But you are not evaluating boolean to anything. It is better to just get rid of the if(true/false)

I'm afraid I don't have v12.0.0.683 to test if I can recreate the issue, but I used 13.0.2000.0 with VS2015 and works fine. Try that version.

Why have you placed a if(false) statement?

When you debug up to the line
ds.ReadXml(xmlData);
What does the DataSet look like? (how many tables, rows etc)

Which line is causing the exception?

Look into using logstache which is a nosqldb technology to index the content in the files. Setup some parallel processes to use indexed datasource and process data that way.

Without knowing your tool set skills set etc I'd suggest using DTS package or SSIS package to load txt file data to a database table then query only necessary data to build the output or processing. Much more efficient and parallel mechanics.

Are the files in any particular format?

Remove the customSessionProvider and use default see if it helps.

Check that your Web.config Authentication section looks similar:
<authentication mode="Forms">
<forms loginUrl="~/Login.aspx"
timeout="2880"
cookieless="UseCookies" />
</authentication>

Just a sanity check, create a brand new blank solution and one page which sets and gets a session var. Reply here with the results.

Code looks fine, what is the value of Session["EmployeeName"] when the debugger hits the "else"?

Where is the date format conversion code...

Are you sure there is no page validation at master page level that is being triggered when you click link button? Look again.

Ok and so what is the error you are seeing when master page is used?

No there is not, I mean the <%@ Page declaration with masterpage attribute.
Also, what is the exact error you are seeing?

...It will be good for you to also include your Masterpage declaration in your question too.

Debug13, Please click "Improve Question" and include your markup and code behind in your question.

No You can do a single query for the child data on page load or other load point, and then on row data bound for child gridview lookup the data from that child data.

If you do any query inside RowDataBound, you will be calling the database multiple times, which can hurt performance.

You're welcome happy coding.

I mean in the main solution answer text above.

Ok I understand what's gone wrong. Please check my updated solution. The placeholder visibility overrides all inner controls.

Ok please pinpoint the actual issue you are facing and explain the behaviour you are getting from this code now?

By the way, your markup for placeholder in this code does not have visible="false" attrivbute.

Please update your question and post the complete page markup and complete code behind.

I assure you it works.
Try it on a new page and then fix your own original page step by step.

schedule_Departure_Date

What is this value type being bound? String? DateTime? what?

You need display:none

brockeu, ppolymorphe has a good point, think about partial loading of file or content for better performance with suitable choice of controls.

brockeu wants to know an alternative text / drawing layout rendering controls to basic text box.

In MVC default project there is a web.config file inside Views folder.
You can also add this setting: "<add namespace="CrudeOperations.Models">"

<system.web.webpages.razor>
<host factorytype="System.Web.Mvc.MvcWebRazorHostFactory, System.Web.Mvc, Version=5.2.3.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"></host>
<pages pageBaseType="System.Web.Mvc.WebViewPage">
<namespaces>
<add namespace="System.Web.Mvc"></add>
<add namespace="System.Web.Mvc.Ajax"></add>
<add namespace="System.Web.Mvc.Html"></add>
<add namespace="System.Web.Routing"></add>
<add namespace="CrudeOperations.Models"></add>
</namespaces>
</pages>
</system.web.webpages.razor>

This then allows you to simplify the reference in cshtml (if it inherits that web.config) as

@model City

Hope this helps.

Project name is just visual studios way to include code files in one project.
Project name can be different to assembly name and namespace. Each project can have only one assembly name, but it may contain many namespaces.

If you right-click on project name and properties, you will see under "Application" page, "Assembly Name" and "Default Namespace".
Assembly Name: what the dll will be named when built.
Default Namespace: when adding a new class, Visual Studio will auto name the class inside default Namespace. Change it if you prefer to separate your code into domains or groups.

see https://msdn.microsoft.com/en-us/library/ad7d6w76.aspx

That's correct, each cshtml file must include a reference to the model class (if any is used or required).

Consider a normal C# class, it would look like :
"using CrudeOperations.Models; // namespace /assembly reference for when the class you are writing is in another namespace.
namespace WebApp1
{
public class TestClass1()
{
public City MyCity {get;set;}
public TestClass1()
{
MyCity = new City
{
StateName = "Florida"
};
}
}
}"

No that is not how it is.

Let me break it down like this:
CrudeOperationsDemo.Models.City
"CrudeOperations" <-- This is the assembly name and reference.
"Models" <-- This is the namespace "Models" i.e. many classes can have same namespace.
"City" <-- This is the class name. So "model => model.StateName" is referencing the City class instance.

"model => model.StateName"
"model" <-- MVC internally creates an instance of City class object and this is the same as doing:
City model = new City();


Hope this helps.

Is the control on the main page markup?
Where in the control hierarchy does it sit?

If you fixed it please upload your fixed code.

What do you mean DataTable in MVC format, please give more explanation instead of going around in circles.

I gave you an answer according to the question not this last comment.
What do you mean DataTable in MVC format?

That does not make sense sorry, the example I tried works. Check your SQL.

Why not just do
var statusCode = response.StatusCode;
and then handle it in a generic handler to build the appropriate response back to the client.

You're welcome, happy coding.

Hi Subhash PM
Please click Improve Question and post some markup you already have.

My initial thoughts are that your ASPX page inside the iFrame is not registering the bootstrap scripts or your main web application's bundles (css, scripts etc).

In developer tools in browser (F12 key) check the iframe page sources and check they're loaded.

Please click "Improve Question" and copy and paste the following:
- The markup for the page which contains the partial
- The control action of the container page
- The markup for the Partial View

All the best.

In my opinion asking a user to open and e-mail, click a link, then copy and paste the password from the (same? email?) is too many steps. What I would do is send the user an e-mail with a link with some kind of "access code" embedded e.g.
http://www.web.site/upload?key=SDFSASDNU23HD783.

So the idea is this part of the url "?key=SDFSASDNU23HD783". Let's suppose this is scrambled text from original string: "id:1,key:12345", where "id" is your users id and "key" is your uniquely generated access code. Let's suppose we convert the string id:1,key:12345 to base64 and get "SDFSASDNU23HD783" (not realistic but you get the idea). This may not be secure enough but that depends on how secure you want it to be, so it may actually be better to make the user copy and paste the code.

Now you can store this in a new database table along with your users id, and a column called "Expiry" (DateTime). When you generate a code, set the expiry.
In my example url, when the upload page receives the request, first query the DB to see if the access code part of the query string is expired or not. if not, authenticate the user, if user is not correct, send them away and update the access code database table value as VOID, because someone tried to attempt to access with wrong code/username combo.

Make sense?

Ok, hope this helps. Reply anytime once you start your development and need any technical development help.

Okay......so I ask again...what is the error

I can't see any other solution other than the stack overflow one. Sorry.

Please can you post text of the error you are getting. Or take a screenshot and upload to imgur share link.

Check link in ans.

This is the only piece of data you have in string format or DateTime?

Are you able to use jQuery for this or not? it may help make it easier.

Are you using async task or similar threaded logic to detect when a command is complete? Sometimes the commands don't get acknowledged until a previous one returns a completed signal.

Post some code.

What is the "name" attribute of your connection string set to?

Eh?

I think everyone will agree that you should have mentioned your custom database in the first line of your question as it's pretty important.

What do you want to "set" the combobox to?
Also, this line gridControl.AllowAddNew = false; is not winForms standard. Please can you be very detailed in the techonology and controls/plugins you are developing with?

Please clarify your question referring to your code and where it is not working as you expect. Click on Improve question to update it.

Please show us the <entityframework></entityframework> section in your app.config/web.config.

Hi Pinky,
please clarify something, your question is about how to retrieve a control from a grid control but your code sample is showing us how to add a control. This is confusing.

Can you please explain the technology you are using as well, 'web forms', 'win forms' etc.

You're welcome. Please post your final solution sample when you get it for helping others in future.

This part of you code doesn't seem to make any sense, can you please explain the code:

var lable = document.getElementById("<%=title1.ClientID %>");
var titl = $("[id*=title1]");

You seem to be trying to access the same element using two different approaches.
Try replacing 'titl' var with 'lable'

Consider distributed processing via multiple services/transactions and keep track using a more efficient model.

It absolutely works with many items.
By the way this will work async as well if you replace my code "beginForm" with Ajax form.

ok...please mark as answer if this helped. And if possible put some example of your solution for helping others.

Have you checked if the cookie is expired or somehow invalid and causing the page to logout due to this?

Which line of code is not working as you would expect?

Is this in ASP.NET?

What are the requirements for this? i.e. How will this position be used.

Please can you post your JavaScript code as well.
By the way, is your issue that the click event you declared is not firing?
Or that the controller action is not being called on click?

Please update your answer with the code it created and I will have more detail in order to answer.

I agree well done for a solution none-the less, one day someone may come here and choose to adopt the Linq solution if in fact they are able to utilise it in their solution.

That's how we all learn anything.

Are you able to use Linq in your solution? let me know. otherwise I will give an alternative.

You're welcome, if you get a chance please rate my answer too using the stars to help others find the solution more efficiently.

What framework are you developing a form for? Web forms? MVC? WinForms? Please update your question with more detail.
Please also post some code you used so far.

Thank you all the best

Please update your question with HTML markup, button events and code behind you have already got and I will help with this further detail.

While I am happy to see you have solved it, it's not cool to accept an answer, then undo the accept, only to add your own answer. If my answer helped then please mark as accepted for other developers facing this issue in the future, for their benefit.

What level of developer are you? are you professionally employed or do you want to develop something in your spare time?

What is the data source? MySql, MS SQL, Oracle etc???

Please update your question with more details:
Which method are you attempting to access the drop down list?

Please update your question with the code for the 'Home' model class.

What does your "sendToEmail" functionality/code look like? Please post it.

Also please post your email template, or how you want it to look?

I don't think you should be trying to "send" your grid view to the email.
You should be constructing a new layout specifically for email content.
The grid view's only purpose should be to manage the data records before doing something with the data. i.e. if the user deletes a record, the email is only interested in what data is left.
Ideally you should be updating a data source data table in memory and using the GridView to update it.
When you want to send the email, retrieve the memory data table and it will be the source data for your email template. If I have understood anything wrong, please explain.

Please update your question with your code and what your mappings look like.

Please update your question with any code you have written already which wants to call "RenderViewAsString" method.

Please post some sample HTML/ASP.NET markup, and code (Vb.net or C# etc?)

You state in your question:
"I have tried to change the table name"
This implies you want only one table with all data from Excel file worksheets in one table?
If so, then I suggest you use ODBC connection to Excel file and construct query in code to group all data from all sheets and read into a single DataTable object.

Are you allowed to or able to use Javascript client side to achieve this?

Are either of these two methods causing a long running process or query on the database or server-side?

LoadOutwardGrid(curPage, 10, Convert.ToInt32(Session["SELECTED_DEPT"]));
LoadInwardGrid(curPage, 10, Convert.ToInt32(Session["SELECTED_DEPT"]));

How long do they take to complete?

I have tested your code using dummy data and I cannot reproduce the issue.
Please can you explain what type is returned by the statement:
frm["ApplicationValue"]?
I presume it's a string value but please confirm.
Maybe the error is elsewhere.

Please post code and what you have so far so I can offer best help.

Please can you use the Improve Question option to add the method / event in which the code you posted is being called from?

Also please use the Improve Question option to explain the current problem you are getting; "Unable to store value" could mean lots of different possible problems, please explain.

Please can you give me the value of TextBox1.Text after you click Button2_Click? Hit reply to this comment and let me know.

Is there a reason you cannot use a .NET data bound control e.g. data list view or gridview or Details View to achieve this?

Are you able to use JavaScript in your solution? I ask because if you can, then a new window launcher script can be bound to a control in the GridViewRow and then trigger the browser print function on the 'Invoice' page.

Please can you update your question with more detail e.g. a design, what you want to achieve, and page names or examples.
thanks

Why do you need to use cookies?

Are all the column values non-null when it is being read by the code? That can sometimes cause the col count to be less that what is physically in the file.

Are you getting some sort of error? or are you seeing unexpected grid view results as a result of the query? Please elaborate.

Does it work if you try one datasource per report? It could be conflicting when trying to use the same for both.

Please explain further with code sample, what you have built so far, and what data you need to search on?

Do you have access to a SQL Server instance? Ideally you should create scripts from your localdb mdf database (manually or via SSMS) and run on the live server.
Then point the app to the new db on live, using app.config connection strings.

Normally results are printed out and pinned to a wall.

Should this question read something like "Teach me MVC development?"

Well it won't save the file to Client PC because the web application is running on the server and the export code is executing on that end.

You need to push the file content to the client browser using the HttpResponse object.

In the link I provided previously, have you tried the HttpResponse (add header, flush) approach? Only that needs adding to your code at the end, set the content type to pdf and see if that works.

This example is more suited to PDF file saving.
http://stackoverflow.com/questions/5586772/asp-net-sending-a-pdf-to-the-user

Hopefully can help you. Can you confirm the value you are getting in the label1.Text property in line :
try
{
this.grupeTableAdapter.FillBy12(this.dbDiplomskiDataSet.grupe, label1.Text);
}
?

Also it seems from your code logic that each time you loop over the data grid view row, the table adapter you have there will overwrite any previous rows data retrieved. Technically you should only get the last selected row data.

Does your GridView render on only first page load? or never? or when Button1_Click is raised?

Are the headers going to be static list of items? Or may they change?

Sorry this is not the direct answer to your question but one thing that stood out to me in your example code, is that your code is making a database call for EVERY data row in the gridview. This should be done as a pre-load method. Then when you generate your dynamic column, load the correct value from the pre-loaded data from other datasource.

Also, If you put the foreach() loop inside the RowDataBound event it will only set the label value to the LAST records values. You need to move this logic outside.

Please try and create a new vs2005 project and recreate a simple tree view with default image set. see if it works. If it works, copy the web.config httphandlers section and others which reference webresources, web controls and extensions to your ported project.

I would bind the initial check box changed event to an ajax call to retrieve more data.

With that data, construct more checkbox list items and render using jquery.

Does the web config correctly reference the httpHandelr section for WebResources?

What version of IIS are you using? are the .axd file mappings setup correctly on the IIS mappings served?

Please share the image properties from the browser inspect element i.e. <img src=?.../>

When you debug the front end page, please share with us the image source the browser is trying to bind to the image. (Right click image and look at source or use developer tools F12 (IE) or right click and inspect element.)

Where is the code or css/skin to assign the image to the tree control?

Your welcome. If this was the answer you were looking for I might suggest you re word your question to something like 'How to populate gridview from SQL query.' to help others at your stage.

What is in your SetRowData() method

Please post your markup and current code behind so far.

If it is an ajax call making the upload, then the textbox is client side at that point, so it should be updated via the ajax upload events.
Please post your code behind.

Post the code and markup you have implemented so far please, including your use of the "non" .net framework button.

Simple but, Have you tried rebuilding the solution?

"...i can post my question in detail"

Yes, please do.

No problem, did my solution work for you? If so, please mark so other users can find it helpful or I will update it again for you.

Please use the improve question function to add more detail to your question like what data you want to enter, how you wish to preview it, and what exactly you want to preview.

Person person = AccountManagement.ApiLogin(username, password);
This line shows that AccountManagement.ApiLogin return type is Person.

What it actually does is unknown. Assuming you want to achieve the same goal of logging a user in or 'authenticate' you can create a similar method as ApiLogin and call it Login(username,password). Within that method you will verify the username exists, then verify the credentials are valid.

Look at using AjaxControl tool kit, specifically the dynamic populate control.
Drop one of them on the page, link it to a div or other control.
Add javascript onclientclick event to the calling button/control. The javascript onclientclick event will construct e.g. pipe separated values e.g. user=john|maxrows=20|search=dbSearchString. Pass this parameter set into the dynamic populate controls 'populate()' method in js.

Put your Database search methods in a web method in a new web service. Set the dynamic populate control's servicePath property to this new web service name. e.g. fooBar.asmx and set the method name which will do the search.
Add a parameter to the search method / web method to accept a contexKey: your parameter set.
Split this by pipe character into key value pairs.

Use them in your DB search. once the data is back from the DB within your web method, construct html e.g. <table> and populate it with <td>'s etc for each data row returned.
Return the html markup from the web method. The dynamic populate control has a target control id, which you can assign to a div:id e.g. <div id='dbSearchResults'></div>.

The dynamic populate result will stuff the div with the markup from the web method.

there is no postback involved and you can show updates this way.

What is triggering your content page dlTopProducts_ItemDataBound event?

Did you rebuild your solution after adding it?
Can you access it from code behind? i.e. FileLocationsTableAdapter fTa = new FileLocations TableAdapter

Reset the browser tab settings to default and report back.

This can depend on the user's browser tab settings which may override your code. IE has options like 'Open pop ups in new tab,new window' then theres options in there to 'switch to new tab when opened' etc.

Please see my updated solution.

Yes you can output types other than varchar. See my updated solution.

My suggestion is use Session variable of DataSet or List<> objects.
Even better, construct classes for your objects and populate them from gridview data entry and stick them in session variables.
(Remember to clear, rebuild session variables on the appropriate first page load events etc.)
Google "Disconnected datasets", as it is a big area of discussion.

I didn't think it's possible to just send once, because it's a request and response mechanism. once the response is back it is 'game over' and all abandoned.

Even in IE or other browsers, you can ask it to remember credentials, but the browser still sends the credentials on your behalf for every request/access to the site.

Debug and look at the Datasource, to see its structure, and properties.
You may need to get rows by indexed reference.

Please post your markup as well.

Which panel is it please post it separate to your main code or annotate it/highlight.

Did you try my suggestion...

This looks like a good solution.

Still unclear. Share the part of code which isn't working...or explain.

Is Me.WilperDataSet's rows set to modified or added? Check the row state in that dataset.
You may need to call the insert methods manually.

Please use the edit function and re-type your question as it is unclear.
What is the problem your having? Is the redirect not working from the javascript alert OK/Cancel button? Is that the issue? Please explain clearly. Your question is more a requirement not a issue.

I already gave you a suggestion read my previous message.
Use URL Query string paramter, then pass it into the SQL retrieval code as paramater.
OR... put user entry from text box into session variable and get it in the grid page.

I suggest you keep the controls in the same page as the grid view.
But this is how it can be done:

Form1: user types search value, then on button click you do Response.Redirect("gridpage.aspx?name=" + textbox1.Text);

Then page2(grid) get the query string param :
string searchValue = Request.Querystring("name");

This is not advised to use query string parameter from one page to another to do SQL query (SQL Injection risk). so make sure you validate the query string parameter from page 1.

I don't understand what you mean. The user types into textbox the ID they want, or the name or some other field, then in code you do:
parameter(...).value = textbox1.text <-- this is the user entry.

You need to set sql command parameter value = user entry e.g. from a text box. That was just my example of hard coded id=1.

That's right just for illustration. In my example the rows states are set to modified so you can submitchanges back.

If it's readonly, why will the change event fire...

Is this a problem in other browsers like FIrefox or Chrome?

IE tends to cache some elements of web site content. try ctrl+F5 or reset browser settings/clear files. A very good tool if you didn't know is F12 key brings up developer tools. Do the clear from there as well as in control panel IE options.

What do you want to display in the pop up? just a text box? This seems pointless. Any other controls to be in pop up?

Anyway, You can add onclientclick="showPopup(this)" event to textbox and write javascript to show popup. in the JS function use hidden field to store 'this' value which is textbox id.
Inside popup, user types value and then clicks 'ok' or whatever. on 'ok' click, do JS function to hide popup and copy popup.textbox.value to textbox.id in hidden field.

Beware of this approach may cause the data to be lost on postback i.e. grid view update etc.

Can you try something, in Visual studio, go to Project > ASP.Net configuration.

Does the built in web admin pages load up? if not, try adding this to web config after opening tag of connection strings:

<connectionStrings>
<remove name="LocalSqlServer">
...

In the error at line
DirectCast(e.Row.FindControl("ddlschool"), DropDownList).DataSource = DirectCast(ViewState("School"), DataSet)
is the control ddlschool null or viewstate("School") null? one of them must be null.

you should separate this logic into:
dim ddlschool as dropdownlist = e.row.findcontrol(...)
this approach helps debug better as well.

Post some more example of markup (controls) that are not enabled and your code behind.

Please explain your current page and next page more clearly, i.e. what do they do? What do you want to show in the progress bar?

As far as I know progress bar cannot be used like this. You can however show it, but it will disappear because the page is changing due to postback or redirect. Progress bar is usually for 'Loading...' message when user stays on same page and updates or loads something.

Please submit some examples of your entities concerned, the data source(s) and the functions you want to separate.

Generally, the MVC principle is to remove all action events and code from the presentation layer. You can do this simply in ASP.net by adding EF to a BL project/assembly. Keep your code separate : PL calls BL methods, passing parameters and Class objects, BL calls DAL methods/transactions and logs events. Hope this helps, but do post back for more discussion about what code you have so far.

Please post some code and example.

I agree you need to show your code and logic.
To be a bit helpful, here's a quick example that works. It can be modified to use id's and other data to get the row to delete.
///

/// Add row
///

/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string rowValue = textBox1.Text;
dataGridView1.Rows.Add(new object[] { rowValue });
}

///

/// Delete row
///

/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
DataGridViewRow row = dataGridView1.SelectedRows[0];
dataGridView1.Rows.Remove(row);
}

Generally though, before delete event, the data should be stored in at least a Dictionary object or a class as that can be added to a collection. This can be bound to a DGV and refreshed to get around your issue.

First of all, you have VB.net code in there.

Please see my example in c#. The error "dr is a variable but is used like a method." means that
1. the While loop in c# is while (lowercase),
2. Server.Transfer means that the page will change. The code to set textbox1,3.text is pointless.

See fixed code below. it works:
protected void Button1_Click(object sender, EventArgs e)
{
OleDbConnection con = new OleDbConnection(@"data source=C:\dev\test\testmsaccessdb.mdb;Provider=Microsoft.JET.OLEDB.4.0");
con.Open();
OleDbCommand cmd = new OleDbCommand("select * from client where id= " + TextBox1.Text, con);
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
TextBox2.Text = dr[1].ToString();
TextBox3.Text = dr[2].ToString();
}
//Server.Transfer("Default.aspx");
con.Close();
}

This error means you need to pass a value for a parameter in your select query.
The parameter is @id.
Look at my example, this is how you should do it (add a OleDbCommand and set it's parameter(s)).

protected void Page_Load(object sender, EventArgs e)
{
OleDbConnection con = new OleDbConnection(@"data source=C:\dev\test\testmsaccessdb.mdb;Provider=Microsoft.JET.OLEDB.4.0");
OleDbCommand cmd = new OleDbCommand("select * from client where id = @id", con);
cmd.Parameters.Add("@id", OleDbType.Integer).Value = "1";
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "client");
clientGridView.DataSource = ds.Tables["client"];
clientGridView.DataBind();
}

Do you mean like a search function?