DataSource Controls - SqlDataSource, ObjectDataSource, etc

Data Overflow The Parameter Data is too large to fit into the host field

2013-06-18T15:15:24.227-04:00

I'm doing parameter substitution into an sql statement which is being used to change the SelectCommand in a SqlDataSource being used to load a GridView. The connection is an OleDb connection.

The exception reads... {"Conversion failed for command parameter[0] '' because the data value overflowed the type used by the provider.
"}

...and the Inner exception reads... CWBZZ5012 Data overflow - the parameter data is too large to fit into the host field

...the SQL statement is...

SqlDataSource1.SelectCommand ="select order, recalled, edte, acct, sub, name, add1, add2, add3, code from lib.tablename t1 where code in ? and edte >= ? and edte <= ? order by t1.order desc"

...and the parameter substitutions are...

SqlDataSource1.SelectParameters.Add("@codelist", CodeList)

SqlDataSource1.SelectParameters.Add("@startingdate", startingdate)

SqlDataSource1.SelectParameters.Add("@endingdate", endingdate)

...with the fields defined in code as...

Dim CodeList As String

Dim startingdate As String
Dim endingdate AsString

...and viewing the contents of the fields in debug reveals...

CodeList value is ('CCM', 'CCS', 'CDR', 'CIR', 'CLM', 'CLP', 'CMC', 'CML', 'CMS', 'CNI', 'CRB', 'CRD', 'CRW', 'CTP', 'CTU')

startingdate value is 6/3/2013

endingdate value is 6/7/2013

Looks like it is failing on CodeList substition...can someone tell me why and what I need to do to make it work?

Thanks much in advance for any help, Roscoe

SqlDataAdapter fails to return any data, but Reader.read() returns data?

2013-06-18T15:59:26.093-04:00

Using SQL Server Management studio 2012 with VS 2012

Function is as follows:

public DataTable GetInvoice(){
string connstr=@"Data Source=........" //this connection string there is nothing wrong
string sql="SELECT * FROM Invoice";
Datatable dt= new DataTable();
using(SqlConnection con=new SqlConnection(connstr)){
try{
con.Open();
}
catch{

return dt;
}
using(SqlCommand cmd =new SqlCommand(sql,con)){
using(SqlDataAdapter adp=new SqlDataAdapter(cmd)){

adp.Fill(dt);
}
}



return dt;

}





}

This does not work, however if I use

SqlDataReader reader=cmd.ExecuteReader();

reader.Read();

int invoiceid=(int)reader["InvoiceID"];

It is able to read

What does this mean?

Error when Debug

2013-06-19T05:05:44.837-04:00

Hi. Everybody can help me fix error

Code page asp have only a buton

When Debug it display

Server Error in '/' Application.

Specified argument was out of the range of valid values.
Parameter name: site

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: site

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: site]
   System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags, PolicyLevel policyLevel, Exception appDomainCreationException) +298

[HttpException (0x80004005): Specified argument was out of the range of valid values.
Parameter name: site]
   System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +9874568
   System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +101
   System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +254

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18044

Need DataTable-like object for use with Stored Procedures

2013-06-17T18:58:02.28-04:00

I have a website using web forms. The data layer consists of class files with functions which execute stored procedures and return DataTables used by my pages as the datasource for controls such as ListViews and GridViews. I'm happy with this structure for result sets; however, I am unhappy with this structure in dealing with the stored procedure output parameters and return values because those values are not inherently accessible in the DataTable. My solution has been to add columns to the DataTable containing the output parameter values (and, the return values).

For a multi-row result set, I am obviously producing redundant data for the output and return values which are duplicated in each row.

I tried to find an object similar to a DataTable, but with properties for output parameter and return value which are easily accessible. Am I missing something? If not, can you suggest a solution?

Here is an example: I have a stored procedure which asks survey questions related to a product being purchased. My stored procedure has 3 input parameters (@user_id, @session_id, @product_id), and returns a list of survey questions. Additionally, it returns output parameters including the user's first_name, last_name, the product name, purchase notes, status_code, status_message.

// Add parameters.
cmd.Parameters.AddWithValue("@user_id", Convert.ToInt32(HttpContext.Current.Session["user_id"]));
cmd.Parameters.AddWithValue("@session_id", HttpContext.Current.Session.SessionID);
cmd.Parameters.AddWithValue("@product_id", product_id);
cmd.Parameters.Add("@first_name", SqlDbType.VarChar, 30);
cmd.Parameters["@first_name"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@last_name", SqlDbType.VarChar, 30);
cmd.Parameters["@last_name"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@product_name", SqlDbType.VarChar, 512);
cmd.Parameters["@product_name"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@purchase_notes", SqlDbType.NVarChar, -1);
cmd.Parameters["@purchase_notes"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@status_code", SqlDbType.Int);
cmd.Parameters["@status_code"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@status_msg", SqlDbType.NVarChar, -1);
cmd.Parameters["@status_msg"].Direction = ParameterDirection.Output;

Local Report DataSource

2013-06-12T13:30:13.783-04:00

I am trying to learn how to do Local Reports is VS 2012. I have the Client-Side reporting book and am trying to get the 1st example to work. When I try to run it I get this error: A data source instance has not been supplied for the data source 'DataSet1'.

ReportViewer1.LocalReport.DataSources.Clear();

//prepare report data source
ReportDataSource rds = new ReportDataSource();
rds.Name = "dsAgedAR_dtAgedAR";
rds.Value = dsReport.Tables[0];
ReportViewer1.LocalReport.DataSources.Add(rds);

I don't understand the error or what to do about it. I can find DataSet1 in the XML for the Report so it must be some built-in thing but it seems like it should be overwritten by the assignment above.

DBNull Error exception

2013-06-13T14:41:51.59-04:00

I am trying to store value from XSD column but getting DBNull exception error. When I tried to change the NullValue in XSD it is not allowing me to change it to Nothing . Any Suggestions how to handle this?

I have already tried IsDBNull() and it doesn't work . the datatype of column is Decimal.

Convert DataGrid to Excel but include image when datagrid only has image URL

2013-06-18T04:21:41.963-04:00

I have some code that converts a Datagrid to Excel and it works fine

But I now a DataGrid that includes a image . The image is genera; in the DatGrid by using URL to a file on the server.

When converted to Ecel the image doesnt show because the URL wont work as the EXcel sheet is displaying on my compter

I neeed to convert Link into .jpg file before converting to Excel

The code i am using is below

private void Excel(object sender, System.EventArgs e)

{

//export to excel

Response.Clear();

Response.Buffer =

true;

Response.ContentType =

"application/vnd.ms-excel";

Response.Charset =

"";

this.EnableViewState = false;

System.IO.

StringWriter oStringWriter = new System.IO.StringWriter();

System.Web.UI.

HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

//this.ClearControls(GridView1);

MyDataGrid.RenderControl(oHtmlTextWriter);

Response.Write(oStringWriter.ToString());

Response.End();

}

Default sort order in ObjectDataSource

2006-02-03T16:32:48.103-05:00

I have a GridView bound to an ObjectDataSource using my custom methods for retrieving data, paging, sorting, etc, but I would like to specify the default sort order for the first time the page is viewed.

I tried this by setting the SortExpression in the ODS_Selecting event like this:

if (!IsPostBack)
{
e.Arguments.SortExpression = "SortColumn";
}

But that throws a seemingly unrelated error:
"The data source 'ObjectDataSource1' does not support sorting with IEnumerable data."

(I am returning an array of a custom class to my grid, but everything works great if I don't have the Selecting event with these 3 lines of code.)

The reason I want to specify the sort order is so I can put a sort indicator on the column that is initially sorted by. As I have it now, there is no sort indicator (because the SortExpression is "") and, even though I could set the default sort order in my select method, the user would have to click the column twice to get the descending sort.
First visit - SortExpression = ""
Click the column - SortExpression = "ColumnName"
Click the column again - SortExpression = "ColumnName DESC"

I would like to set the SortExpression on the first visit to the page.

Another related question - Why does the Selecting event fire twice?

ReportViewer and filtering

2013-06-11T16:23:52.117-04:00

Hello,

I am try to manually; no wizard, populate a the ReportViewer control. I have been successful in doing so, by using a SQL Data Access utility class I've created. But I wanted to be able to filter result of the report as well, and as such, I explored passing in parameters and filtering based on the paramater passed in. This also works, but by placing a parameter on a field in report, if do not set; in others words leave it empty, the report itself is empty. I result are there but they are not being shown, because the filter is being applied on load; I can tell because I have other textboxes on the page that make use of the values of the report via some expressions I've written.

Is there a way to by default ignoring the filter, initially on load? I am not the best at using the ReportViewer but I am learning so please be patient with me if I ask some seemingly dumb questions. Also, is there a way to remove a filter once you no longer have use for it during runtime?

Multiple colum count

2013-06-17T22:53:29.89-04:00

I have table with 4 players column like player 1, player 2 , player 3 and player 4. I am counting them like this

SELECT COUNT(*) FROM dbo.Hockey;

But it is showing 3, In my table i can mis player2 or some time player 4. how i can count the number of players which will count player1 , 2 , 3, 4.

when i count it shows 3, but how i can count the other it should show 6

Player1	Player2	Player3	Player4
ABc	Alex
Alix		Robert
Zak		Jack

Thanks

DataGrid shows no data fom URLmultiple request strings (data is there)

2013-06-15T19:33:38.027-04:00

This is the URL. Appreciate any suggestions.

http://www.xxx.com.au/wizardreport.aspx?search=true&State=All&Location=All&Hazard=All&Priority=All&Status=All&Risk=All

Here is the Code

ICollection CreateDataSource()

{

SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["DSN"]);

SqlDataAdapter myAdapter = new SqlDataAdapter();

SqlParameter prm;

SqlCommand myCmd = new SqlCommand();

string SQL = "SELECT * FROM [Inspection] INNER JOIN location ON Inspection.LocationID = location.LocationID WHERE ([location].[LocationID] = ISNULL(@Location,[location].[LocationID]) AND [Location].[LASurvey1] = ISNULL(@State,[Location].[LASurvey1])AND [inspection].[RSurvey5] = ISNULL(@Hazard,[inspection].[RSurvey5]) AND [inspection].[RSurvey15] = ISNULL(@Priority,[inspection].[RSurvey15]) AND [inspection].[RSurvey8] = ISNULL(@Status,[inspection].[RSurvey8])AND [inspection].[RSurvey13] = ISNULL(@Risk,[inspection].[RSurvey13])) ";

// Location

prm =

new SqlParameter("@Location", SqlDbType.VarChar, 100);

prm.Direction =

ParameterDirection.Input;

if (Request.QueryString["Location"] == "All")

{

prm.Value =

DBNull.Value;

}

else

{

prm.Value = Request.QueryString[

"Location"];

}

myCmd.Parameters.Add(prm);

// Priority

prm =

new SqlParameter("@Priority", SqlDbType.VarChar, 100);

prm.Direction =

ParameterDirection.Input;

if (Request.QueryString["Priority"] == "All")

{

prm.Value =

DBNull.Value;

}

else

{

prm.Value = Request.QueryString[

"Priority"];

}

myCmd.Parameters.Add(prm);

// State

prm =

new SqlParameter("@State", SqlDbType.VarChar, 100);

prm.Direction =

ParameterDirection.Input;

if (Request.QueryString["State"] == "All")

{

prm.Value =

DBNull.Value;

}

else

{

prm.Value = Request.QueryString[

"State"];

}

myCmd.Parameters.Add(prm);

//Hazard

prm =

new SqlParameter("@Hazard", SqlDbType.VarChar, 100);

prm.Direction =

ParameterDirection.Input;

if (Request.QueryString["Hazard"] == "All")

{

prm.Value =

DBNull.Value;

}

else

{

prm.Value = Request.QueryString[

"Hazard"];

}

myCmd.Parameters.Add(prm);

//Status

prm =

new SqlParameter("@Status", SqlDbType.VarChar, 100);

prm.Direction =

ParameterDirection.Input;

if (Request.QueryString["Status"] == "All")

{

prm.Value =

DBNull.Value;

}

else

{

prm.Value = Request.QueryString[

"Status"];

}

myCmd.Parameters.Add(prm);

//Risk

prm =

new SqlParameter("@Risk", SqlDbType.VarChar, 100);

prm.Direction =

ParameterDirection.Input;

if (Request.QueryString["Risk"] == "All")

{

prm.Value =

DBNull.Value;

}

else

{

prm.Value = Request.QueryString[

"Risk"];

}

myCmd.Parameters.Add(prm);

myCmd.CommandText = SQL;

myCmd.Connection = myConnection;

myAdapter.SelectCommand = myCmd;

DataTable dt = new DataTable();

myAdapter.Fill(dt);

Session[

"Source"] = dt;

DataView dv = new DataView(dt);

return dv;

}

Access datasource

2013-06-17T02:40:17.003-04:00

Can some one please help me connecting to an access datasource or is this feature available, I am using visual studio 2012 express for web. I am creating a website from asp.empty website, I have trouble starting the website because their is no feature for access datasource in the data tab... If any one can help me with this, please do it would be appreciated!

No feature for selecting access datasource for configuring to database within datatab in toolbox ...(No feature found in Visual Studio 2012 Express for web).

Need advise. Problem with connection pool. Function returning SqlDataReader.

2007-09-06T08:49:10.213-04:00

Halo all

I have a problem with "timeout expired. Thei timeout periode elapsed prior to obtaining a connection from the pool. This may have occured because all pooled connections were use and max pool size was reached"

Then i explore and found out that i did not close my SqlDataReader, SqlDataAdapter, SqlCommand or my connection.

But i have a function that return a SqlDataReader.

Is this function will cause a connection problem?

Thanks in advance

Public Function GetDataReader(ByVal strSQL As String, ByVal DBCon As DB.DBConnection) As SqlDataReader
Dim MyCommand As SqlCommand = New SqlCommand(strSQL, DBCon.GetConnection())

            If DBCon.GetConnection().State = ConnectionState.Closed Then
                DBCon.GetConnection().Open()
            End If

Dim dr As SqlDataReader = MyCommand.ExecuteReader()

Return dr

dr.Close()

End Function

break in a coloumn of gridview

2013-06-14T04:49:54.193-04:00

i have a grid view like this

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="SqlDataSource1" Height="154px" Width="389px">
            <Columns>
                <asp:BoundField DataField="A1" HeaderText="A1" SortExpression="A1" />
                <asp:BoundField DataField="A2" HeaderText="A2" SortExpression="A2" />
                <asp:BoundField DataField="A3" HeaderText="A3" SortExpression="A3" />
                <asp:BoundField DataField="A4" HeaderText="A4" SortExpression="A4" />
                <asp:BoundField DataField="B1" HeaderText="B1" SortExpression="B1" />
                <asp:BoundField DataField="B2" HeaderText="B2" SortExpression="B2" />
                <asp:BoundField DataField="B3" HeaderText="B3" SortExpression="B3" />
                <asp:BoundField DataField="B4" HeaderText="B4" SortExpression="B4" />
                <asp:BoundField DataField="C1" HeaderText="C1" SortExpression="C1" />
                <asp:BoundField DataField="C2" HeaderText="C2" SortExpression="C2" />
                <asp:BoundField DataField="C3" HeaderText="C3" SortExpression="C3" />
                <asp:BoundField DataField="C4" HeaderText="C4" SortExpression="C4" />
                <asp:BoundField DataField="D1" HeaderText="D1" SortExpression="D1" />
                <asp:BoundField DataField="D2" HeaderText="D2" SortExpression="D2" />
                <asp:BoundField DataField="D3" HeaderText="D3" SortExpression="D3" />
                <asp:BoundField DataField="D4" HeaderText="D4" SortExpression="D4" />
                <asp:BoundField DataField="E1" HeaderText="E1" SortExpression="E1" />
                <asp:BoundField DataField="E2" HeaderText="E2" SortExpression="E2" />
                <asp:BoundField DataField="E3" HeaderText="E3" SortExpression="E3" />
                <asp:BoundField DataField="E4" HeaderText="E4" SortExpression="E4" />
                <asp:BoundField DataField="F1" HeaderText="F1" SortExpression="F1" />
                <asp:BoundField DataField="F2" HeaderText="F2" SortExpression="F2" />
                <asp:BoundField DataField="F3" HeaderText="F3" SortExpression="F3" />
                <asp:BoundField DataField="F4" HeaderText="F4" SortExpression="F4" />
                <asp:BoundField DataField="G1" HeaderText="G1" SortExpression="G1" />
                <asp:BoundField DataField="G2" HeaderText="G2" SortExpression="G2" />
                <asp:BoundField DataField="G3" HeaderText="G3" SortExpression="G3" />
                <asp:BoundField DataField="G4" HeaderText="G4" SortExpression="G4" />
                <asp:BoundField DataField="H1" HeaderText="H1" SortExpression="H1" />
                <asp:BoundField DataField="H2" HeaderText="H2" SortExpression="H2" />
                <asp:BoundField DataField="H4" HeaderText="H4" SortExpression="H4" />
                <asp:BoundField DataField="I1" HeaderText="I1" SortExpression="I1" />
                <asp:BoundField DataField="I2" HeaderText="I2" SortExpression="I2" />
                <asp:BoundField DataField="I3" HeaderText="I3" SortExpression="I3" />
                <asp:BoundField DataField="I4" HeaderText="I4" SortExpression="I4" />
            </Columns>
        </asp:GridView>

how can i put break after 4 coloumn... <br/> doesnt work here

What is the usage of RowGUID under SQL Server 2005?

2008-04-16T07:42:26.367-04:00

Hi All

What is the usage of Row Guid under SQL Server 2005? It seems not much information state the main purpose of it?

Regards

Alex

Report Viewer and Entity Framework

2013-06-11T16:30:50.383-04:00

Hello,

I saw a great example online on how to populate/utilize the ReportViewer via some wizard controls, which took advantage of the Entity Framework. Here is the link to the example I am referring to http://weblogs.asp.net/rajbk/archive/2010/05/09/creating-an-asp-net-report-using-visual-studio-2010-part-1.aspx

Once you have looked at this example, could some please tell me if there Is there a way to programmatically get "NorthWindEntities" from the "ProductRepository " class without setting up a edmx object? The reason I ask is because I have searched and searched and not found too much information lending itself to this method; probably couldn't find much since I am such a noob. I like how the Linq-To-SQL is being used, but I was wondering if there was a way to accomplish this programmatically versus a wizard/designer code.

Microsoft oledb data acces truncates the data length to 255 characters

2013-06-11T09:30:26.433-04:00

Hi all

When i use microsoft oledb driver for excel import, it truncates the data to 255 characters.

string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath + ";" + "Extended Properties='Excel 8.0;HDR=YES;MAXSCANROWS=0;IMEX=1'";

Please provide some solutions

GRIDVIEW HELP

2013-06-08T12:08:39.347-04:00

Hello there i have a gridview which gets populated from a sqldatasource.

This gridview serves as a session. Where i want to give members the ability to delete only their sessions.

The second colum of the gridview displays the Members name. I am trying to filter the gridview with user.identity.name on load but i cannot find a single way to success.

The result i need is to display only the sessions from the user.identity.name.

Please help.

Want my dropdownlist to populate only data from the selection to the GridView..

2013-06-06T01:19:28.84-04:00

Hello,

I've got a dropdownlist control and a GridView control. I think I'm close but I need a little help.

When I select an Item from the dropdownlist control, I would like for the GridView to select only data from the "Name" that is selected.

Instead, I get everything in the table.

Any ideas?

My code...

<asp:dropdownlist id="ddlClients" runat="server" appenddatabounditems="True" autopostback="True"
datasourceid="sdsClients" datatextfield="Name" datavaluefield="ID">
		<asp:listitem text="Select a Client" value="-1">
		</asp:listitem>
	</asp:dropdownlist>
	<asp:sqldatasource id="sdsClients" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" selectcommand="SELECT * FROM [Current]">
	</asp:sqldatasource>
	<asp:sqldatasource id="Sqldatasource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
selectcommand="SELECT * FROM [Current] WHERE ([ID] = CASE WHEN @ID = -1 THEN [ID] ELSE @ID END) ORDER BY [Name]">
		<selectparameters>
			<asp:controlparameter controlid="ddlClients" name="ID" propertyname="SelectedValue"
type="Int32" />
		</selectparameters>
	</asp:sqldatasource>
    <strong><p>Client Details</p>
	<asp:gridview id="gvClient_Details" runat="server" autogeneratecolumns="False" datakeynames="ID"
datasourceid="sdsClients" style="margin-top: 12px;" Width="783px">
		<columns>
			<asp:boundfield datafield="Name" headertext="Name" sortexpression="Name" />
			<asp:boundfield datafield="Location" headertext="Location" sortexpression="Location" />
<asp:boundfield datafield="Street" headertext="Street" sortexpression="Street" />
<asp:boundfield datafield="System" headertext="System" sortexpression="System" />
<asp:boundfield datafield="Payment" headertext="Payment" sortexpression="Payment" />
<asp:boundfield datafield="Server" headertext="Server" sortexpression="Server" />
<asp:boundfield datafield="Phone" headertext="Phone" sortexpression="Phone" />
<asp:boundfield datafield="Circuit_Provider" headertext="Circuit Provider" sortexpression="Circuit_Provider" />
<asp:boundfield datafield="Location" headertext="Location" sortexpression="Location" />
<asp:boundfield datafield="Circuit_ID" headertext="Circuit ID" sortexpression="Circuit_ID" />
<asp:boundfield datafield="Location" headertext="Location" sortexpression="Location" />
<asp:boundfield datafield="Server_Login" headertext="Server Login" sortexpression="Server_Login" />

		</columns>
	</asp:gridview>

How do I get current LINQ Datasource field value

2013-06-05T01:15:50.307-04:00

Hello,

I want to put into a text box the value from the current row of a linq datasource. If I have it hooked up to a grid, I can go to that cell and pull it out but rather than have it in a grid I want it straight to a text box.

How do I get at a column value for the current row? For example:

StartDate = CDate(gvCerts.SelectedRow.Cells(2).Text) <<< this sets startDate to the grid cell value that is connected to my linq datasource.

What would I do to hook a text box up directly, say something like (but I know this isn't it):

Textbox1.text = LinqDataSource1.whateverTheCurrentRowIs.Field("StartDate")

DataSource Controls - SqlDataSource, ObjectDataSource, etc

Data Overflow The Parameter Data is too large to fit into the host field

SqlDataAdapter fails to return any data, but Reader.read() returns data?

Error when Debug

Server Error in '/' Application.

Specified argument was out of the range of valid values. Parameter name: site

Need DataTable-like object for use with Stored Procedures

Local Report DataSource

DBNull Error exception

Convert DataGrid to Excel but include image when datagrid only has image URL

Default sort order in ObjectDataSource

ReportViewer and filtering

Multiple colum count

DataGrid shows no data fom URLmultiple request strings (data is there)

Access datasource

Need advise. Problem with connection pool. Function returning SqlDataReader.

break in a coloumn of gridview

What is the usage of RowGUID under SQL Server 2005?

Report Viewer and Entity Framework

Microsoft oledb data acces truncates the data length to 255 characters

GRIDVIEW HELP

Want my dropdownlist to populate only data from the selection to the GridView..

How do I get current LINQ Datasource field value

Specified argument was out of the range of valid values.
Parameter name: site