ADO.NET :: Bind Selected Values From Two Tables To Gridview Data Source
Mar 9, 2011
how to bind selected values from two tables to gridview data source, that two tables are from two databases. i created a view by using these two.But error is getting with this query,that is invalid object derivdtbl_1.Expr1. how to fix this?
SELECT dbo.Station_Channel.St_id, dbo.Station_Channel.lid, dbo.Station_Channel.Edit, dbo.Station_Channel.lChannelName, dbo.Station_Channel.lShort, dbo.Station_Channel.lPosition, dbo.Station_Channel.lTransformData, dbo.Station_Channel.lUnits, dbo.Station_Channel.lDecimalPts,
dbo.Station_Channel.parameter, dbo.Station_Channel.function_value, derivdtbl_1.Expr1
FROM dbo.Station_Channel CROSS JOIN
(SELECT MAX(Fecha) AS Expr1 FROM MeteoStation.dbo.Datos) AS derivdtbl_1
WHERE (dbo.Station_Channel.Edit = 1)
View 2 Replies
Similar Messages:
Jun 18, 2010
i want to bind gridview from different tables and as shown in following format only
Column1
Column2
Column3
Column4
Column5
Column6
Column7
Column8
View 3 Replies
Jul 8, 2010
I put a sql statement into the textbox,then the result will be bound to the gridview in the page. first time,sql statement is "selecte * from A(B)",and the gridview is ok. second time,sql statement is "selecte * from B(A)",then the gridview will throw a exception the exception is "A field or property with the name 'aa' was not found on the selected data source. i have two tables A and B."
View 5 Replies
Apr 30, 2010
I'm sure it was discussed hundred of times, but maybe this time will elucidate some new points )
The question is: do I need to limit number of selected rows in data source for GridView?
When I use paging in GridView does limiting selected rows make GridView work faster?
Now I use ObjectDataSource with Linq in functions.
[Code]....
Does this make sense or I can just use LinqDataSource without thinking of selected rows?
View 2 Replies
Aug 4, 2010
i have dataset with two data tables inside
dt1
dt2
i want to bind data from both data table t gridview
for this how can i make join between two data tables inside dataset and retreive data
View 3 Replies
Apr 9, 2010
[Code]....
[Code]....
[Code]....
View 3 Replies
May 7, 2015
With reference to : [URL] ....
No you cannot add a third parameter in the Dictionary. It contain Key Value pair data.But if you want to add third parameter then simply use DataTable and add these in the DataTable row.Name of Builder , Title Of Buidler , Builder ID
So how to acheive that task ? so far i did like this :
public void AddNewCMP(string PersonName , string PersonID , string PersonTitle) {
var dt = new DataTable();
if (ViewState["CMPDataTable"] != null) {
dt = (DataTable)ViewState["CMPDataTable"];
[Code] ....
Now on button click i want to add six drop down values to AddNewRow(value1,value2,value3) method .... how to do that ?
View 1 Replies
Aug 19, 2010
I know that you can use exclamation sign to bind array of simple types (like string) to GridView like this
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField HeaderText="Array Field" DataField="!" />
</Columns>
</asp:GridView>
But this doesn't seem to be the case with DataNavigateUrlFields
<asp:HyperLinkField DataNavigateUrlFields="!" DataNavigateUrlFormatString="RoleInformation.aspx?role={0}" Text="Manage users" />
and I get following error:A field or property with the name '!' was not found on the selected data source.
View 1 Replies
Apr 28, 2010
<p>i m aslo facing one problem which in gridview in edittemplete mode I have put dropdownlist. in itemtemplate there is one label in. i have to bind same value to dropdownlist which is in label at itemtemplate/. for this i have write below code. but it shows me error which is object refrence not to set an instance of object.
View 7 Replies
Dec 9, 2010
Girdview has dropdownlist TemplateField called ddlSate, how to bind state field value in sql table to selected value of ddlState dropdownlist control? For example the sql table has AL value for state field, (Note by default ddlState lists all states options with sqldatasource), how AL is selected in ddlState when binding to ddlState?
Secondly, when user selects different state like GA, how below update stored precedure works? that means how to find ddl selected value in update procedure as shown below question mark line:
Here is part code:
<asp:GridView ID="gvOrder" runat="server" DataSourceID="ods1" AutoGenerateColumns="False"
style="margin-top: 11px" CssClass="pnlOrdercss" ScrollBars="Both"
BorderColor="Black" BorderWidth="1px">
<Columns>
[Code]....
View 2 Replies
Aug 13, 2010
I have a gridview to which I am binding a database values. My requirement is to bind the values to the gridview by sorting 3 columns as a default sorting with ASC order in one column and descending order in other two.. Can I do it in my .Net code or should I do that in Stored Procedure? If it can be done in .net code Can you tel me how it can be done.
View 2 Replies
Jun 15, 2010
i have a formview1 in edit mode within a modal pop up extender and Update Panel
The update statement works but on the page is a gridview1 where I want
to display the new values.
I have added the below in page code but it still does not bind
the Gridview with new values when after I click UpdateButton in Formview - Only when I refresh the page.
protected void FormView2_ItemUpdated(object sender, FormViewUpdatedEventArgs e)
{
GridView3.DataBind();
ObjectDataSource50.DataBind();
}
View 2 Replies
Apr 20, 2010
here is my problem:
Admission no: 1212
Feetyep :College fee
Fee term : annual
above values should be appear in Grid view.
how to display the selected values in Grid view.
View 3 Replies
Sep 23, 2010
How Get particular selected cell value from gridview . my grid so many cell available..i'm created dynamic row and cell ...
View 2 Replies
Feb 1, 2011
I am using VS 2005.I have 5 tables depending on their values ,I need to draw a bar chart.
View 1 Replies
Aug 14, 2010
I would like bind grid view with 2 different tables that has no relation.
View 2 Replies
Aug 12, 2010
I have Grid view control in the page. Enable paging option is true.
Columns in the Grid view are ID, Name, Checked and Email
Whenever user selects the check box then I am showing txtEmail in the Email columns so that I can enter email id in the textbox.
Like this I am selecting checkboxes and entering values in the txtEmail when I go to next page and comes back. Then these entered values are cleared.
How to keep the textboxes values and checkboxes selected during paging?
I have been doing R&D for 1 day. Tried to implement.
View 17 Replies
Jan 8, 2011
I have a problem with keeping the selected values in DropDownLists in rows in GridView while paging. I have this code behind:
private void RememberOldValues()
{
ArrayList LinijaIDList = new ArrayList();
int index = -1;
foreach (GridViewRow row in GridView1.Rows)
{
index = (int)GridView1.DataKeys[row.RowIndex].Value;
if (Session["equal_ITEMS"] != null)
LinijaIDList = (ArrayList)Session["equal_ITEMS"];
if (row.Cells[0].Text == lineTextBox.Text)
{
if (!LinijaIDList.Contains(index))
LinijaIDList.Add(index);
}
else
LinijaIDList.Remove(index);
}
if (LinijaIDList != null && LinijaIDList.Count > 0)
Session["equal_ITEMS"] = LinijaIDList;
}
protected void Button1_Click(object sender, EventArgs e)
{
//Session["equal_ITEMS"] = null;
RememberOldValues();
GridView1.AllowPaging = false;
BindGrid();
//RePopulateValues();
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("LinijaID", typeof(int)));
dt.Columns.Add(new DataColumn("Ime", typeof(string)));
ArrayList LinijaIDList = (ArrayList)Session["equal_ITEMS"];
//if (LinijaIDList!=null)
//{
foreach (int LinijaID in LinijaIDList)
{
foreach (GridViewRow row in GridView1.Rows)
{
DropDownList Ime = GridView1.FooterRow.FindControl("ImeDropDownList") as DropDownList;
int rowID = (int)GridView1.DataKeys[row.RowIndex].Value;
//string Name = row.Cells[1].Text;
string Name = Ime.SelectedValue;
if (rowID == LinijaID)
{
DataRow dr = dt.NewRow();
dr["LinijaID"] = LinijaID;
dr["Ime"] = Name;
dt.Rows.Add(dr);
}
}
}
GridView1.AllowPaging = true;
Session["equal1"] = dt;
Response.Redirect("CheckedRowsPage1.aspx");
}
// else
//{
// GridView1.AllowPaging = true;
// Session["equal1"]=null;
// }
}
When I insert a value in the TextBox2 and want to select only the rows from the GridView from different pages which have value in the first column the same as the value in the TextBox2, after clicking on Button1 I get this error:
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
[Code]....
View 3 Replies
Mar 19, 2014
How to open the second page in a pop up window for the below attached link program
ASP.Net Pass or Send GridView Row Values to other Page with HyperLink
View 1 Replies
Nov 19, 2010
I have a gridview showing values from two tables accommodation and pic (left join on accommodation). If there is no pic uploaded I want to display the row without the pic. So in the gridview I first check to see if the picid is null, if it is i don't render any 'a href' code , if it's isn't i do.
The problem that i'm having is that instead of the image showing up in the gridview itemtemplate i get
','_blank','toolbar=no,menubar=no'))" >
Here is my .aspx code
SelectCommand="SELECT pic.picid, aspnet_Users.Username, accommodation.location, accommodation.type,accommodation.description, convert(varchar,accommodation.createdate,101) as createdate
View 2 Replies
Feb 2, 2010
I have a gridview and users would select some records and would click on the submit button and i will be saving those records into database using a stored proc.... now .... just below the gridview and above the submit button there are few checkboxes by default they wud be checked. How would i save the selected values and the checked boxes in database i wrote the stored proc for the gridview but how would i save the checked checkboxes into the same table.
For i As Integer = 0 To gvSelectScreen.Rows.Count - 1
Dim chkTemp As CheckBox = TryCast(gvSelectScreen.Rows(i).FindControl("cbStatus"), CheckBox)
If chkTemp.Checked Then
ContractNumber = gvSelectScreen.Rows(i).Cells(0).Text
ClientProgramNumber = gvSelectScreen.Rows(i).Cells(1).Text
ClientProgramName = gvSelectScreen.Rows(i).Cells(2).Text
StartDate = CType(gvSelectScreen.Rows(i).FindControl("txtStartDate"), TextBox).Text
EndDate = gvSelectScreen.Rows(i).Cells(5).Text
Dim connStr As String = ConfigurationManager.ConnectionStrings("MainConnectionString").ConnectionString
Dim myCon As New SqlConnection(connStr)
Dim cmd As New SqlCommand("usp_ParametersFromGrid")
Dim dt As New DataTable
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@ContractNumber", SqlDbType.VarChar, 22).Value = ContractNumber.ToString()
cmd.Parameters.Add("@ClientProgramNumber", SqlDbType.VarChar, 22).Value = ClientProgramNumber.ToString()
cmd.Parameters.Add("@ClientProgramName", SqlDbType.VarChar, 100).Value = ClientProgramName.ToString()
cmd.Parameters.Add("@StartDate", SqlDbType.VarChar, 20).Value = StartDate.ToString()
cmd.Parameters.Add("@EndDate", SqlDbType.VarChar, 20).Value = EndDate.ToString()
cmd.Parameters.Add("@RequestID", SqlDbType.VarChar, 50).Value = RequestID.ToString()
cmd.Connection = myCon
myCon.Open()
cmd.ExecuteNonQuery()
myCon.Close()
End If
Now above the submit button as i said, there are few checkboxes and they are checked by default...how would i save the selected item (in the gridview and the checked checkbox values in the same row in the database(sql server)
View 5 Replies
Jul 17, 2015
How do i change the name column text the current row when the selected index of drop down is changed? ex:first row is mudassar khan and belgium, when i change belgium i want mudassar to be replaced to a name which i fetch from database....
View 1 Replies
Feb 23, 2011
i will use advanced control like gridview or schedule , and the data that is supposed to be bound to this control is : data from set of tables in my database.not a single table.
what is the best form for this data?
what i thought about at first is:
stored procedure ,contains my logic (and i wanna to ask here about what is the best performance also)use temporary table or joins or ... etc.
what are the possible solutions and more performance rather than stored procedure( as this is a web application many users will use it).
View 2 Replies
Jan 9, 2014
There are 2 DropDown one is "Category" other is "sub_category"
I want to show data in "sub_category" DropDown according to "category" Dropdown selected value.
But when "Category=C1" data should bind in DropDown from Database Table1 and when "Category=C2" or "Category=C3" data should bind in DropDown from Database Table2.
How to achieve this.
View 1 Replies
May 29, 2010
I have a form with several DropDownlists and TextBoxes, Each dropdownlist depends on the selection of the previouse one.. and there is a submit button. Once the user clicks on it, information entered by the user is displayed in a GridView and saved as well in the database. The GridView holdes information from two tables I used joining) , but once I click on the Submit button I receive this error: Arithmetic overflow error converting varchar to data type numeric. The statement has been terminated. 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.Data.SqlClient.SqlException: Arithmetic overflow error converting varchar to data type numeric. The statement has been terminated. Source Error:
[Code]....
Imports System.Data.SqlClient
Imports System.Web.Configuration
Partial
Class Members_MembersCalculator
Inherits System.Web.UI.Page
Protected Sub CalculateButton_Click(ByVal sender
As Object,
ByVal e As System.EventArgs)
Handles CalculateButton.Click
Dim objConnection As SqlConnection
Dim objDataCommand As SqlCommand
Dim c_manu, c_model, c_date
As String
Dim sSQL As
String
Dim ConnectionString As
String
Dim c_factor As
Double
Dim c_result
As Double
Dim c_milage As
Double
Dim c_id As
Integer
Dim c_year As
Integer
c_manu = ManDropDownList.Text
c_year = YearDropDownList.Text
c_model = ModelDropDownList.Text
c_milage = MilageTextBox.Text
c_factor = FactorDropDownList.Text
c_id = CarIDDropDownList.Text
c_date = CarDateTextBox.Text
c_result = c_factor * c_milage
ConnectionString = WebConfigurationManager.ConnectionStrings("Carbon_free_ConnectionString").ConnectionString
objConnection = New SqlConnection(ConnectionString)
objConnection.Open()
sSQL = "Insert into car (Manufacture, year, Model, car_factor)" & _
"values('" & c_manu &
" ', ' " & c_year & " ',' " & c_model &
" ', ' " & c_factor &
" ')"
objDataCommand = New SqlCommand(sSQL, objConnection)
objDataCommand.ExecuteNonQuery()
objConnection.Close()
objConnection = New SqlConnection(ConnectionString)
objConnection.Open()
sSQL = "Insert into car_Result (car_id, car_Result_Date, Car_result)" & _
"values('" & c_id &
" ', ' " & c_date & " ',' " & c_result &
" ')"
objDataCommand = New SqlCommand(sSQL, objConnection)
objDataCommand.ExecuteNonQuery()
objConnection.Close()
msgLabel.Text = "Your records have been calculated successfuly, Thank you."
'CarDateTextBox.Text = ""
'MilageTextBox.Text = ""
CarGridSqlDataSource.DataBind()
CarGridView.DataBind()
End Sub
End
Class
View 3 Replies
