You searched for the word(s): userid:692013

More Search Options

RSS Available

• Re: How to change the objectdatasource tableadapter query in runtime

  Hi m3rlin, There are a few solutions to that, here are a few options: Create a seperate method on your DataAdapater for each case and you can change which one to use at runtime. or Create a stored procedure that takes all the parameters you need and runs the appropriate query according to your logic. or use linq to entities :)

  Posted to Data Access and ObjectDataSource Control (Forum) by jogi on 5/1/2009

• Re: SQL Database connection

  Hi, What kind of error did you get exactly? -jogi

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by jogi on 4/9/2008

• Re: GridView doesn't work.

  huh?

  Posted to Data Presentation Controls (Forum) by jogi on 3/11/2008

• Re: Strongly-Typed Dataset from a View

  Hi Aaron, When you include more than one table, or base an adapter off a view, you just don't get the other methods autogenerated for you. You can still create them manually..here are some steps for you: Click on the title of the TableAdapter in your dataset designer (not the DataTable) which is right above the names of your methods like 'GetDate()' Open the Properties panel with the TableAdapter selected and you should see nodes for DeleteCommand, UpdateCommand, Select Command and Insert

  Posted to Data Access and ObjectDataSource Control (Forum) by jogi on 3/9/2008

• Re: How to change the objectdatasource tableadapter query in runtime

  Ah ok. I think I understand your problem now. Try this SQL instead: SELECT ProductID, ProductDesc, OrderDate FROM yourTable WHERE (@OrderDate IS NULL OR OrderDate = @OrderDate) Hope that helps! -jogi

  Posted to Data Access and ObjectDataSource Control (Forum) by jogi on 3/8/2008

• Re: dynamic tables

  This is a fun problem. I don't think there is a way to do this without writing a lot of code. I'd recommend creating a control to help reduce complexity in your page. Here is a quick sample that dynamically generates a calendar for anymonth (I did it for the month instead of a week just for the hell of it). I don't have a lot of time to work on it (because people are starting to come into the office ), but hopefully it will get you some ideas.... Enjoy! -jogi 1 //get the first day of

  Posted to Data Presentation Controls (Forum) by jogi on 3/7/2008

• Re: GridView doesn't work.

  You should probably use CommandType of type stored procedure instead of text. And programmatically create your parameters. Here is a kb article from msdn with a sample: http://support.microsoft.com/kb/306574

  Posted to Data Presentation Controls (Forum) by jogi on 3/7/2008

• Re: dynamic tables

  You'll need to create them dynamically if they will be based on data. Here is a quick sample: 1 Table t = new Table(); 2 TableRow tr = new TableRow(); 3 TableCell tc1 = new TableCell(); 4 TableCell tc2 = new TableCell(); 5 6 tc1.Text = "cell1" ; 7 tc2.Text = "cell2" ; 8 9 tr.Cells.Add(tc1); 10 tr.Cells.Add(tc2); 11 t.Rows.Add(tr);

  Posted to Data Presentation Controls (Forum) by jogi on 3/7/2008

• Re: How to change the objectdatasource tableadapter query in runtime

  Hi Philip, Here is a quick sample: ObjectDataSource1.TypeName = "mytypename.mytableadapter" ObjectDataSource1.SelectMethod = "GetData" 'here is how you change the parameters ObjectDataSource1.SelectParameters.Clear() ObjectDataSource1.SelectParameters.Add( New Parameter( "myparam" , TypeCode.Int32, "5" )) MyControlThatsBoundToIt.DataBind() Hope that helps! -jogi

  Posted to Data Access and ObjectDataSource Control (Forum) by jogi on 3/5/2008

• Re: Strongly-Typed DataSet/Nullable column issue

  I was referring to the Parameter. Not the column. -jo

  Posted to Data Access and ObjectDataSource Control (Forum) by jogi on 3/4/2008