Visual Basic

FirstPrevNext

Re: Datagrid Dayekh17-Apr-07 3:59 Dayekh 17-Apr-07 3:59  lol .. sorry for the confusion. You are correct. Here are the steps that are involved with the creation of this datagrid: 1 - User Selects the column names from the webpage 2 - User clicks on "Run" 3 - The Application runs a SELECT query involing ONLY the selected Columns. 4 - User Enters a name into a Textbox and clicks on save. 5 - The application runs a "Create View" query to the database. This "Create View" query will have ONLY the columns selected. 6 - You return to the main report page. There is a dropdown list which is populated by data in a table which stores records about 'Saved' Reports(which the user has stored just now) 7 - The user then selects the report name which he just saved from the dropdown. 8 - The name from the dropdown refers to the view which was created. A - All the views are dynamically created. B - The same DataGrid is being used to display any of those views. C - There is ONE column that a User may or may not select. D - If he selects it, I want the contents of that column to be manipulated; Else forget about it. Normally for a static set of data being retrieved, I use "e.item.cells().Text = something" for manipulation, but that syntax refers to a column which is in a fixed position and which is always there no matter what. BUT I am looking for some syntax which will target that particular column which may or may not be returned depending on whether the user has selected it. I am very sorry for the confusion. If this does not make sense to you, don't worry about it any more. It may be too confusing to solve by communicating online. Thanks a lot for your replies. Re: Datagrid Dave Kreskowiak17-Apr-07 7:22 Dave Kreskowiak 17-Apr-07 7:22  I think I got it now. I think all you have to do is scan the column headers (For I = 0 to MaxColumns) for the name you're looking for, then just save the index of that column for use in your Cells reference. Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: Datagrid Dayekh17-Apr-07 11:12 Dayekh 17-Apr-07 11:12  Thanks a lot man. Will try to code it =D How to show video from DVR Card? somchoto16-Apr-07 4:05 somchoto 16-Apr-07 4:05  I have a DVR Card. And i want show video from CCTV camera by DVR Card in form vb.net. Re: How to show video from DVR Card? Dave Kreskowiak16-Apr-07 4:36 Dave Kreskowiak 16-Apr-07 4:36  There is no standard .NET classes that will do this for you. You have to see if your DVR card manufacturer supplies and SDK (Software Development Kit) you can use, or if there is any documentation on what you should be using. Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 vb dot net doubt shalinikannan16-Apr-07 2:12 shalinikannan 16-Apr-07 2:12  The SelectCommand property has not been initialized before calling 'Fill'. shs Re: vb dot net doubt kubben16-Apr-07 2:18 kubben 16-Apr-07 2:18  It appears you have not set the sql query or stored procedure in your command before you called your dataadapter.fill method. Do you have another question? Ben Re: vb dot net doubt Dave Kreskowiak16-Apr-07 3:31 Dave Kreskowiak 16-Apr-07 3:31  You're trying to execute a command without telling your OleDbCommand, or SqlCommand, or AdoDbCommand, object what command to execute. You have to give it the Sql command you want it to execute so it knows what to return to fill your dataset. Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Connection Error reykentj16-Apr-07 1:57 reykentj 16-Apr-07 1:57  Environment: Op Sys 2003 server; Sql Server 2005 with update; Visual Studio; Multiple VB functions and subroutines as stored procedures.This subroutine needs to use a connection string to enable MARS. It does not have the SQL Attributes. They seem to prohibit byref class instantiations being returned. Dim connectionString As String = _ "server=(local);" & _ "Trusted_Connection=yes;" & _ "database=Frontier_equipment;" & _ "MultipleActiveResultSets=true;" RecordTypeConnection = New SqlConnection() RecordTypeConnection.ConnectionString = connectionString RecordTypeConnection.Open() Error Numr 5 Error Desc An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) rkj Re: Connection Error kubben16-Apr-07 2:21 kubben 16-Apr-07 2:21  Are you sure your sql server name is correct? Are you sure the sql server allows trusted connection. Can you ping the sql server name from where you are trying to run this app? Is there an instance of a sql server you are trying to connect to? You have to put that into your server name. Sometimes you have to set a port number for sql server instances. Anyway, a few thoughts, I hope that helps. Ben Re: Connection Error reykentj16-Apr-07 3:26 reykentj 16-Apr-07 3:26  I had read that Stored procedures running within the SQL Server could use the local option for server name. Placing the combined servername\sqlservername as the servername worked.!! Thank you. rkj Re: Connection Error Dave Kreskowiak16-Apr-07 3:29 Dave Kreskowiak 16-Apr-07 3:29  Along with what kubben said, your connection string says that it expects the database server to be on the same machine as the one where your code is running. I hope this is true, otherwise you'll have to change your connection string. Does your SQL Server instance have Named Pipes enabled? Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: Connection Error reykentj16-Apr-07 4:13 reykentj 16-Apr-07 4:13  The stored procedures are on the same machine as the server. Replacing server(local) with servername\server made the whole thing work. rkj Re: Connection Error Dave Kreskowiak16-Apr-07 4:35 Dave Kreskowiak 16-Apr-07 4:35  If it's a stored procedure, you can try "context connection = true" for the connection string to use the connection that the SP is executing under. But, as you can read here[^], this is not always the best idea. Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: Connection Error reykentj16-Apr-07 7:30 reykentj 16-Apr-07 7:30  I was using that but I needed the MARS capability. rkj Import Excel Data suveenmohan16-Apr-07 0:45 suveenmohan 16-Apr-07 0:45  Hi All I want to import excel data into SQL Server2000 through VB6.0, but it gave error. Plz Help. Regards smk Re: Import Excel Data Dave Kreskowiak16-Apr-07 3:25 Dave Kreskowiak 16-Apr-07 3:25  suveenmohan wrote: but it gave error. And that error would be?? suveenmohan wrote: Plz Help. Not without knowing what the error message was and what the code looks like that generated it. Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Datagrid as Entry form nitin_ion16-Apr-07 0:33 nitin_ion 16-Apr-07 0:33  i have a window application in which i am using datagridview. i want to use datagridview as dataentry. Is there any sample i can use Re: Datagrid as Entry form Dave Kreskowiak16-Apr-07 3:21 Dave Kreskowiak 16-Apr-07 3:21  Thats pretty much what the DataGridView was designed for. Just about every one of the thousands of DataGridView examples out on the web does this very thing. The examples pretty much show you how to do all kinds of customizations so you can tailor the DGV to do data entry. Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 .read a html gimme_nolede15-Apr-07 23:48 gimme_nolede 15-Apr-07 23:48  somebody helps me. can vb.net read a html?how? Re: .read a html Tamimi - Code15-Apr-07 23:55 Tamimi - Code 15-Apr-07 23:55  check HTTP Request http://www.asp101.com/samples/http_aspx.asp[^] When you get mad...THINK twice that the only advice Tamimi - Code Re: .read a html Dave Kreskowiak16-Apr-07 3:16 Dave Kreskowiak 16-Apr-07 3:16  HTML is nothing but a text file. Where are you trying to read this HTML from? What are you trying to do with it? Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: .read a html gimme_nolede16-Apr-07 7:59 gimme_nolede 16-Apr-07 7:59  actually i want to categorize documents.i have html documents. first, i must convert them to doc type. from a html document i just need words in tittle tag and body tag.. Re: .read a html Dave Kreskowiak16-Apr-07 12:20 Dave Kreskowiak 16-Apr-07 12:20  OK. This still doesn't clarify the question at all. Converting them to doc types?? What does that mean? Are you trying to convert an HTML file to a Word document? Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: .read a html gimme_nolede16-Apr-07 16:20 gimme_nolede 16-Apr-07 16:20  i just want to get the text in tittle and body, and remove other tags. and then save it as word document. just text, without table, without image.

Last Visit: 31-Dec-99 18:00     Last Update: 26-Sep-24 2:53 Refresh ᐊ Prev1...2622262326242625262626272628262926302631 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.