C# - How To Connect GridView DataSource Over Webpart Class
Mar 1, 2010
i try to make myGridView Companent via using WebPArt you know it :
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.WebControls;
using System.Web.UI;
namespace MyGridView
{
public class MyGridView : WebPart
{
GridView gv;
protected override void CreateChildControls()
{
gv = new GridView();
gv.CssClass = "tablestyle";
this.Controls.Add(gv);
}
}
}
i added this GridView on Toolbox. Every Thing is ok . İ want to add my own CSS design to my GridView. But if i drow this gridView from toolbox to aspx page. if i bind my datasource ; Datasource is not show himself.
Like that Main program:
protected void Page_Load(object sender, EventArgs e)
{
LoadData loaddata = new LoadData();
DataTable dt = loaddata.LoadSQL("conn", "sp_GetAllCategory");
MyGridView1.datas.... -----> i can not see DataSource why?
}
i want to see My GridView DataSource. if i write Binding datasource. MyGridView1.DataSource -----> i can not see DataSource why?
i have a hidden textbox in my aspx page. The aspx page also has a masterpage in the <% @Page> directive.
<input type="hidden" runat="server" name="txtType" id="txtType" /> actually in aspx.cs i am getting txtType.ClientID="ctl00_MainHeaderContent_txtType"
I have a webpart in a webpart zone in this aspx page. In the webpart CreateChildcontrols() I need to access this hiddenTextbox value. I am able to access it as
But instead of hardcoding I want to access as a control in the page or form. How can I do that I want to do as looping through the controls in the page but Page.Controls.Count gives 1 and that is MasterPage. How can I get the entire controls in the page and loop through and find the hidden textbox. I also tried as string TxtValue = this.Page.Request.Form["<%=txtType.ClientID%>"] in CreateChildControls() of the webp[art. But could not access hidden textbox like this.
I've created a SQL Server Express database to use with a program I'm working on in Visual Web Developer 2008. The connection works fine according to the Add connection-wizard in VWD. However there's a problem when I try to select data from the database and present the data in a gridview. The error message says that the gridview isn't connected to the database. The gridviews DataSource ID (source-mode) is the same as the name of the database. In design-mode, when I try try configure the datasource I get to a point where I have to configure the select statement, but I just want the connection to work in a way that let's me write the sql-statements in the aspx.cs-file.
I am new in sharepoint development. I have 2 webparts attached on a page. The first webpart (MyTestingWebpart1) basically it does only inserting of data and the other webpart (MyTestingWebpart[2]) displays the records from the database. Now my problem is when I try to click on the save button, somehow I don't know how to refresh the webpart that displays the newly inserted record. Is this possible?
I have added a query at the page load event of MyTestingWebPart[2]. Both of the webparts attached are web user controls.
I have created one sample application for WebParts. It is working fine when I run it from Visual Studio or local environment.
But when, I have publish file in IIS virtual directory (in my PC or same PC) at that time it is stop showing Verb tool bar (minimize, close buttons of WebPart).
am writing a series of WSS/MOSS webparts amongst which one will need to detect the current SQL Server database connection, prompt the user to setup a new connectionstring, and fire appropriate stored procedures to create a new database if needed. The user needs to be presented a textbox or label control with the current database connection. I've never had to detect current database connection, what methods do I call for this? If the desirable connection is not present, the web application needs to prompt the user to make a new database. The user really won't make the database, they simply need to click the command button which will fire the stored procedure to create the database.
I'm currently working on a highly configurable Database Viewer webpart for WSS 3.0 which we are going to need for several customized sharepoint sites. but i fear it's necessary to recap the whole issue. As background information and to describe my problem as good as possible, I'll start by telling you what the webpart shall do:
Basically the webpart contains an UpdatePanel, which contains a GridView and an SqlDataSource. The select-query the Datasource uses can be set via webbrowseable properties or received from a consumer method from another webpart. Now i wanted to add a filtering feature to the webpart, so i want a dropdownlist in the headerrow for each column that should be filterable. As the select-query is completely dynamic and i don't know at design time which columns shall be filterable, i decided to add a webbrowseable property to contain an xml-formed string with filter information.
So i added the following into OnRowCreated of the gridview:
GetColumnNode() checks in the filter property, if there is a node for the current column, which contains information about the Field the DropDownList should bind to, and the query for filling in the items.
In cbx_PreRender() i check ViewState and select an item in case of a postback. In cbx_DataBound() i just add tooltips to the list items as the dropdownlist has a fixed width.
Previously, I used AutoPostback and SelectedIndexChanged of the DDL to filter the grid, but to my disappointment it was not always fired. Now i check __EVENTTARGET and __EVENTARGUMENT in OnLoad and call a function when the postback event was due to a selection change in a DDL:
[Code]....
When i have two or more filters set which return zero rows, and i change back one filter to something that should return rows, the gridview remains empty (although the pager is rendered). I have to completly refresh the page to reset the filters. When debugging, i can see in the overridden CreateChildControls of the grid, that the base method indeed returns > 0, but anyway.the gridView.RowCount remains 0 after databinding. Anyone have an idea what's going wrong here?
I am trying to read the data from XMLDataSource into a gridview (in asp.net). It works when I perform below logic:
Dim ds As New DataSet() ds.ReadXml(Server.MapPath("LoadData.xml")) GridView1.DataSource = ds.Tables(0) GridView1.DataBind() and I hardcoded the resultant hyperlinks inside the GridView with some name using the following exp: (and it works).....
But when i embed the griview inside a webpart , configure the datasource, I am not able to read the data from the XMLDataSource. I get the following error: The DataSourceID of "GridView1" must be the ID of a control of type IDataSource. A control with ID "XMLDataSource1" could not be found.
I'm trying to find a way to Databind a usercontrol to a datasource (an ObjectDataSource in my case) like in the case below : <uc1:AutoComplete ID="autoComCities" runat="server" DataSourceID="objCitiesDS" DataValueField="Id" DataTextField="Name" />
oledbCon.ConnectionString = "Provider=MySqlProv; Data Source=localhost; Initial Catalog = AnymoreComputers; User id=WeakUser2;Password=1234";
my site is working and running wrote in c# and mssql 2005,
now i want to make it run with mysql.....i converted all my data base...and created the same users (same names)
anc copied all to my sql .
the question is how do i connect to mysql wit c# ......
my regular connection for mssql :
oledbCon.ConnectionString = "Provider = SQLOLEDB.1; DATA Source = (local); Initial Catalog = test1; Integrated Security = SSPI; User ID=WeakUser2;Password=1234"; the connection to mysql : oledbCon.ConnectionString = "Provider=MySqlProv; Data Source=localhost; Initial Catalog = test1; User id=WeakUser2;Password=1234";
this connection doesnt works ... where is my mistake ? what hsould i do ... ?
and this is the error ig get when i run my solution :"The ConnectionString property has not been initialized."
I'm new here and I'm in dire need of help. Been trying to solve a problem for hours now.Here's what I wanted to do: I added a table 'tblProductCat' in the webform and I intend to populate the table with VB codes as shown below
[Code]....
What am I doing wrong here? I really can't figure this out. There was a time when, instead of that exception handling message appearing, a yellow box that states something between the lines of 'offline' and 'check your root folder for *something*' or something like that.
I'm running SQL Express 2005 on an SBS 2003 Standard Server and I keep getting this error back.A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol)
I've uploaded my project to this same server, and I've so far checked that TCP/IP has been enabled for this instance, I've checked the IPs are relevant, I've checked that the connection string is correct, and I've even set a dynamic port number as I've noticed that SBS runs 2005 databases for Sharepoint and Monitoring.
Interestingly enough, I can connect to this instance via Visual Studio on my remote machine, and SSMSE and also via SSMSE on the server as well?The connection string i'm running with is:
Data Source=localhostVDSSQL;Initial Catalog=myDB;Persist Security Info=True;User ID=SA;Password=***
i have been trying to connect to SQLserver from ASP.net web developer in an n-tier architecture.But it shows this error in conncetion
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I have use vs.net 2008 and sql erver 2008.When I wanna connect to sqlExpress in Sql Server Managment Studio 2008 this error is shown:Cannot connect to SAEID-PCSQLEXPRESS.A network-related or instance-specificerror occurred while establishing a connectionto SQL Server. The server was not found or was notaccessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error LocatingServer/Instance Specified) (.Net SqlClient Data Provider) In SqlServer Configuration Manager when I want start SqlExpress service an error is shown to me that cann't start the service.
I want to connect Sql server which is on remote mechine by IP adress. at present i able to connect sql sever which is on local machine using followning code:
SqlConnection con = new SqlConnection("Data Source=HCL-LAPTOP;Initial Catalog=databasename;User id=sa;Integrated Security=True");
I'd like to connect to a database on a different domain. I've done some search and people say to add a connectin using an enterprise manager? Where can I find sql enterprise manager? On msn website, they only show things about sql enterprise manager for sql 2000. Is this a tool only included in sql 2000?
I had a database on a development server of which I am not the owner. The connection string was:
Dim MM_cnnTraining_STRING MM_cnnTraining_STRING = "Provider=SQLOLEDB.1;Password=xxx;Persist Security Info=True;User ID=xxx;Initial Catalog=Training;Data Source=xxx"
I copied this database to my local machine, In services MSSQL is set to logon with my computer username and password, I have no idea if this affects anything.Also the local database which I can view in MSSQL Server Management Studio, I can connect by Windows Authentication only. The database copied there seems to have maintained the same permissions.Im completely confused. I finally was able to copy to my local machine but now can not connect. I am using dreamweaver, but using the connection string above.