hi every body.. i want to know how to fetch a particular data from a text file.. not the entire file and place those datas into some control like datagrid or dataview using C#.Net... pls help me out how to do this..Pls help me out.. i have doubt in C#?
u fill use System.IO namespace for that
i know vb.net,in vb.net i can do it.but i can read the first line
fileiovar.readline()
but i dont know how its in c#
if u want a part in a text file u can look for searching-techniques.but im sure its all about System.IOPls help me out.. i have doubt in C#?
Read data connections using text drive r..this may help you out..
Have a nice day
StreamReader class can be used for retrieving data from the text file. The programming logic varies depended on the type of data file.
IF You have no idea the actual data, but the data type is xml or html. You need to know its open tag and close tag, and the data is being placed between them. Following is the example in C#.NET in handling xml file.
--------------------------------------鈥?br>
int iopentag;
' this is for recording the position of opening tag
int iclosetagpos;
' this is for recording the position of closing tag
string stropentag = ';%26lt;name%26gt;';;
string strclosetag = ';%26lt;/name%26gt;';;
string strxmlcontent; (the file is in binary format, you need to encode it to text, otherwise it will not work. I can't remember how to do it at moment.)
string stractualvalue;
int inumberofcharacterstostrip;
'This value is to determine how many characters to strip
iopentag = strxmlcontent.indexof(stropentag);
if iopentag %26gt; -1 {
if iclosetag %26gt; -1 {
inumberofcharacterstostrip = iclosetag - iopentag - stropentag.size;
stractualvalue = strxmlcontent.substring(iopentag + stropentag.length, inumberofcharacterstostrip);
}else{
Message.show(';This file is invalid!!!';);
}
}
///////
This is an example of retrieving one data from the text file. In the realworld situation, the pesuedo-code is as follow:
--------------------------------------鈥?br>
Get the current postion of opentag
Do while current position is greater than zero
If the end tag position is greater than zero then
get the actual number of characters to strip by opentagpos less closetagpos less length of starttagstring
get the start position to strip by start tag pos. plus length of start tag string (might be less 1, please try!)
Using substring property (start position to strip, actual number of characters to strip)
Change the open tag pos by (strxmlcontent.indexof(stropentag, iendtagpos))
Else
set opentag pos is -1
End if
End While
if closetag is -1 then
Prompt the message ';the file is invalid';.
end if
I have provided the logic tailerd to your case, hope my message will solve your programming problems. Are you uni student?
Friday, August 20, 2010
How to avoid entering duplicate in Database? I have already put an Index to the field so that the data will?
not be duplicated..My only problem is that error. The error always appear when i put the same data in the databse, and after that those duplicates were deleted from the database...how can I trap the error? the error is like this:
Run-time error '-2147467259 (80004005)
i try to trap it but it doesn't work that error always appear...
is their any alternative way to avoid entering duplicates in the database? or What is the right way to trap the error? Please help me i really need this to my thesis...Im now online this is my I.d ericgri20002000.
By the way im using ADO control and Datagrid ...PLease help meHow to avoid entering duplicate in Database? I have already put an Index to the field so that the data will?
You use create a constraint and create a unique key across the fields you don't want duplication. Most DB Engines allow you to specify to ignore duplicate records in a unique key field range. An Identity field doesn't necessarily remove duplicate values in supplement fields- only the ID field.
runtime error 80004005 refers to unrecognized database format.. what is the version of your access database? use Jet Ver 4.0 for access 2000/2003.. Jet 3.5.1 for access 97.. take careHow to avoid entering duplicate in Database? I have already put an Index to the field so that the data will?
Create a method to verify that the data that you鈥檙e entering does not already exist prior to updating your table in the database. The method should execute a stored proc that will simply query the table for the specified value and then return the record ID if it exists. If it鈥檚 already there, then just don鈥檛 attempt to perform the insert.
If you wanted to get more complicated you could use Ajax to check the database for the value as the user is actually typing it on the page and instantly notify the user that the value already exists preventing them from inserting the duplicate value on the client side. You would need to develop a Web service for this and learn how to use Ajax.NET or write your own JavaScript SOAP call methods to interact with the Web service.
Run-time error '-2147467259 (80004005)
i try to trap it but it doesn't work that error always appear...
is their any alternative way to avoid entering duplicates in the database? or What is the right way to trap the error? Please help me i really need this to my thesis...Im now online this is my I.d ericgri20002000.
By the way im using ADO control and Datagrid ...PLease help meHow to avoid entering duplicate in Database? I have already put an Index to the field so that the data will?
You use create a constraint and create a unique key across the fields you don't want duplication. Most DB Engines allow you to specify to ignore duplicate records in a unique key field range. An Identity field doesn't necessarily remove duplicate values in supplement fields- only the ID field.
runtime error 80004005 refers to unrecognized database format.. what is the version of your access database? use Jet Ver 4.0 for access 2000/2003.. Jet 3.5.1 for access 97.. take careHow to avoid entering duplicate in Database? I have already put an Index to the field so that the data will?
Create a method to verify that the data that you鈥檙e entering does not already exist prior to updating your table in the database. The method should execute a stored proc that will simply query the table for the specified value and then return the record ID if it exists. If it鈥檚 already there, then just don鈥檛 attempt to perform the insert.
If you wanted to get more complicated you could use Ajax to check the database for the value as the user is actually typing it on the page and instantly notify the user that the value already exists preventing them from inserting the duplicate value on the client side. You would need to develop a Web service for this and learn how to use Ajax.NET or write your own JavaScript SOAP call methods to interact with the Web service.
My GUI problem?
hi,
I've a problem figuring out how to design my website's interface.
I have a menu control that's horizontal..it takes the whole width of the screen and right under it I have datagrid that also takes the whole width of the screen, so my problem is that new items are added in the menu regularly so that means the menu will be too wide for the screen..so I was thinking of converting it to a vertical menu but my problem is that the grid also takes the whole screen so I don't know where exactly to put it so this means it's gonna take part of the width that the grid takes?
So I can't imagine where to put it exactly...any suggestions..maybe some links to websites as examples..
thanksMy GUI problem?
First of all you should use css for the page layout. if you don't wana use them try specifying the width of each td tag in percentages in which you want to keep the display items of your webpage. once you have a stremlined table structure, adding or removing more items from page won't be any problem. using this approach you can have your extra item in either vertical or horizontal part. also you can restrict the datagrid to couple of TD/colums by specifying the the colspan attribute. or you can include the datagrid within the div tag and make the size of div tag smaller than the size of datagrid, so you can have scrollbars around the datagrid to view data and also increasing the space for you.love myspace myspace girl
I've a problem figuring out how to design my website's interface.
I have a menu control that's horizontal..it takes the whole width of the screen and right under it I have datagrid that also takes the whole width of the screen, so my problem is that new items are added in the menu regularly so that means the menu will be too wide for the screen..so I was thinking of converting it to a vertical menu but my problem is that the grid also takes the whole screen so I don't know where exactly to put it so this means it's gonna take part of the width that the grid takes?
So I can't imagine where to put it exactly...any suggestions..maybe some links to websites as examples..
thanksMy GUI problem?
First of all you should use css for the page layout. if you don't wana use them try specifying the width of each td tag in percentages in which you want to keep the display items of your webpage. once you have a stremlined table structure, adding or removing more items from page won't be any problem. using this approach you can have your extra item in either vertical or horizontal part. also you can restrict the datagrid to couple of TD/colums by specifying the the colspan attribute. or you can include the datagrid within the div tag and make the size of div tag smaller than the size of datagrid, so you can have scrollbars around the datagrid to view data and also increasing the space for you.
How to get value from datagrid to textbox outside grid in asp.net?
how to get value from datagrid to textbox outside grid in asp.netHow to get value from datagrid to textbox outside grid in asp.net?
in Asp Net data grid is associated with DataSet. Whenever there is change in data dispalyed in datagrid, dataset is updated accordingly. You need to read dataset for getting that value.
in Asp Net data grid is associated with DataSet. Whenever there is change in data dispalyed in datagrid, dataset is updated accordingly. You need to read dataset for getting that value.
I am a newbie in visual basic and i am having a hardtime controling my database using vb as my interface?
would you please help me on how i would code my vb program so that it would accept inputs via textboxes, confirm the inputs using a command button and save it in a database (access via adodc) that would then be displayed in a datagrid.
i already used adodc1.recordset.addnew and adodc1.recordset.update but what i need is a code because im going to use sql statements for queries with certain conditions.
one example is in my login form. I need to query my database using adodc to verify if the logging user is registered to the database. how could i solve this? please help me...I am a newbie in visual basic and i am having a hardtime controling my database using vb as my interface?
Been a while for VB and ADODC but as I recall, click on properties for the ADODC control and a wizard opens. You can select that you're using a SQL query, which kind of database you're connecting to (Access, SQLServer, etc) write the query in a box in the wizard and test the connection.
Hope that helps
i already used adodc1.recordset.addnew and adodc1.recordset.update but what i need is a code because im going to use sql statements for queries with certain conditions.
one example is in my login form. I need to query my database using adodc to verify if the logging user is registered to the database. how could i solve this? please help me...I am a newbie in visual basic and i am having a hardtime controling my database using vb as my interface?
Been a while for VB and ADODC but as I recall, click on properties for the ADODC control and a wizard opens. You can select that you're using a SQL query, which kind of database you're connecting to (Access, SQLServer, etc) write the query in a box in the wizard and test the connection.
Hope that helps
How can I use Function keys to display data in VB6.0?
Dear Friend
Can anybody answer about my below requirement?
I want to use function keys in my “Inventory Control System” software. I’m using VB6.0 and for database Access 2002.
For example, I want to see the availability of Computer based on ref_no (ref_no does exist in a TextBox which is placed on my MDI form). Then if I press F2 or F3 or F4 …., that particular item i.e. Computer related with ref_no will be displayed on a DataGrid.
Please help me about the use of function keys.
Appreciate, if you would come back at your earliest.
Regards
PervezHow can I use Function keys to display data in VB6.0?
You will need to place a keyup handler on your form and process the keys that come in
Private Sub Form_KeyUp(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyF1 Then myFunction()
End Sub
Can anybody answer about my below requirement?
I want to use function keys in my “Inventory Control System” software. I’m using VB6.0 and for database Access 2002.
For example, I want to see the availability of Computer based on ref_no (ref_no does exist in a TextBox which is placed on my MDI form). Then if I press F2 or F3 or F4 …., that particular item i.e. Computer related with ref_no will be displayed on a DataGrid.
Please help me about the use of function keys.
Appreciate, if you would come back at your earliest.
Regards
PervezHow can I use Function keys to display data in VB6.0?
You will need to place a keyup handler on your form and process the keys that come in
Private Sub Form_KeyUp(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyF1 Then myFunction()
End Sub
MS Access search form -> open report?
scenario:
FormName:frmSearch
objects: (all unbound)
txtBeginDate
txtEndDate
cboNameList (contains Names from tblNameList onLoad event)
cboCategoryList (contains Category from tblCategoryList onLoad event
() Show Detailed report (option bution to open dtlMonthlyReport)
() Show Summarized report (option bution to open smrMonthlyReport)
() Search Reciept (option button to open rcptReport)
() Search Voucher (option button to open vcrReport)
btnSearch
[ I want to display search result here within the form ... but dont konw how?]
================= end of frmSearch ==============
notes:
all the reports are link to its own form and the date field formated to accept input from within the form
the purpose of this form (frmSearch) is to show the search result based on user defined criteria and then from the search result user can double click to open the designated report with the parameters from the sellected search result.
question:
1) how do I display the search result(s) within the form itself (in VB its dataGrid) for the option 3 %26amp; 4 only.
2) I have tried using the ';SELECT '; method in sqlCriteria string using
doCmd.OpenReport .......,sqlCriteria
but an error msg appears saying ';....there are more than 1 record based on ..... consider using EXISTS reserved word ......';
So how do I open the designated report based on the search criteria?
I have heard of this PARAMETERS in querydef but not sure how to use it.
can you guys help me? Im stuck. whenever I want to display the reciept of a certain transaction I have to manually browse to the records (in frmTransaction) then click the button to generate the report. The same goes to the monthly detailed report, where I have to execute the form , enter the date range and click the button. For the summarized report its more troublesome for me to generate the report because it goes through many process. That is why i want to have this ';short cut';MS Access search form -%26gt; open report?
dont look for a shortcut please.
FormName:frmSearch
objects: (all unbound)
txtBeginDate
txtEndDate
cboNameList (contains Names from tblNameList onLoad event)
cboCategoryList (contains Category from tblCategoryList onLoad event
() Show Detailed report (option bution to open dtlMonthlyReport)
() Show Summarized report (option bution to open smrMonthlyReport)
() Search Reciept (option button to open rcptReport)
() Search Voucher (option button to open vcrReport)
btnSearch
[ I want to display search result here within the form ... but dont konw how?]
================= end of frmSearch ==============
notes:
all the reports are link to its own form and the date field formated to accept input from within the form
the purpose of this form (frmSearch) is to show the search result based on user defined criteria and then from the search result user can double click to open the designated report with the parameters from the sellected search result.
question:
1) how do I display the search result(s) within the form itself (in VB its dataGrid) for the option 3 %26amp; 4 only.
2) I have tried using the ';SELECT '; method in sqlCriteria string using
doCmd.OpenReport .......,sqlCriteria
but an error msg appears saying ';....there are more than 1 record based on ..... consider using EXISTS reserved word ......';
So how do I open the designated report based on the search criteria?
I have heard of this PARAMETERS in querydef but not sure how to use it.
can you guys help me? Im stuck. whenever I want to display the reciept of a certain transaction I have to manually browse to the records (in frmTransaction) then click the button to generate the report. The same goes to the monthly detailed report, where I have to execute the form , enter the date range and click the button. For the summarized report its more troublesome for me to generate the report because it goes through many process. That is why i want to have this ';short cut';MS Access search form -%26gt; open report?
dont look for a shortcut please.
I have some problem about DATA GRID in vb6 connected to MS access, i need to remove/delete all records?HELP!!?
i have problem about DATA GRID in vb6 connected to MS access, i need to remove/delete all records in just one click in a command button. My code is: rsProducts.delete, because i made my records as a recordset. but it doesnt remove all records in DATAGRID. i've already done deleting a single record by selecting 1 record, but my problem now is that, i need to delete the entire recodrs on my datagrid. How can i do that, can you please help me do this one. THANKS!!! PLEASE! any help will be greatly appreciated.I have some problem about DATA GRID in vb6 connected to MS access, i need to remove/delete all records?HELP!!?
project helps
http://hobbyprojects.info/
project helps
http://hobbyprojects.info/
Gridview paging in asp.net?
i m working on this page with gridview which i flood from my vb code, same adap.fill, gridview.databind(). now i want to page this gridview. while this code http://dotnetjunkies.com/Tutorial/AAF84EAD-C412-4304-A88A-AF26F8C883E6.dcik
works for a datagrid. i want similar functionality for a gridview. can anyone help??? please its urgent.. my deadline is tom n i've wasted enough time. as in what is the code that goes in pageindexchanged... also if you could type a tiny code showing how rowcommand would work if i were to access the property of an object in my gridview... eg. activate button text to deactivate on clicking....Gridview paging in asp.net?
The GridView is NOT a DataGrid. If you are using a GridView, then achieving paging is even easier than in a DataGrid. Below I give the code for a page that uses Paging in a GridView.
I write the whole code inline (in aspx file) to simplify stuff.
%26lt;%@ Page Language=';C#'; AutoEventWireup=';true'; %%26gt;
%26lt;%@ Import namespace=';System.Data';%%26gt;
%26lt;%@ Import namespace=';System.Data.SqlClient';%%26gt;
%26lt;html %26gt;
%26lt;head runat=';server';%26gt;
%26lt;title%26gt;Untitled Page%26lt;/title%26gt;
%26lt;script runat=';server';%26gt;
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindGrid();
}
}
private void BindGrid()
{
SqlConnection MyConnection;
SqlCommand MyCommand;
MyConnection = new SqlConnection(';server=.;DataBase=Northwi鈥?br>
MyCommand = new SqlCommand(';SELECT * FROM CUSTOMERS ';, MyConnection);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(MyCommand);
MyCommand.Connection.Open();
da.Fill(dt);
MyCommand.Dispose();
MyConnection.Dispose();
gvwTest.DataSource = dt;
gvwTest.DataBind();
}
protected void gvwTest_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
BindGrid();
gvwTest.PageIndex = e.NewPageIndex;
gvwTest.DataBind();
}
%26lt;/script%26gt;
%26lt;/head%26gt;
%26lt;body%26gt;
%26lt;form id=';form1'; runat=';server';%26gt;
%26lt;asp:GridView ID=';gvwTest'; runat=';server'; AutoGenerateColumns=';true'; AllowPaging=';true'; PageSize=';10';
OnPageIndexChanging=';gvwTest_PageIndex鈥? /%26gt;
%26lt;/form%26gt;
%26lt;/body%26gt;
%26lt;/html%26gt;
Remember.. look for gridView code snippets not DataGrid!!
Hope the above helps.love myspace myspace girl
works for a datagrid. i want similar functionality for a gridview. can anyone help??? please its urgent.. my deadline is tom n i've wasted enough time. as in what is the code that goes in pageindexchanged... also if you could type a tiny code showing how rowcommand would work if i were to access the property of an object in my gridview... eg. activate button text to deactivate on clicking....Gridview paging in asp.net?
The GridView is NOT a DataGrid. If you are using a GridView, then achieving paging is even easier than in a DataGrid. Below I give the code for a page that uses Paging in a GridView.
I write the whole code inline (in aspx file) to simplify stuff.
%26lt;%@ Page Language=';C#'; AutoEventWireup=';true'; %%26gt;
%26lt;%@ Import namespace=';System.Data';%%26gt;
%26lt;%@ Import namespace=';System.Data.SqlClient';%%26gt;
%26lt;html %26gt;
%26lt;head runat=';server';%26gt;
%26lt;title%26gt;Untitled Page%26lt;/title%26gt;
%26lt;script runat=';server';%26gt;
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindGrid();
}
}
private void BindGrid()
{
SqlConnection MyConnection;
SqlCommand MyCommand;
MyConnection = new SqlConnection(';server=.;DataBase=Northwi鈥?br>
MyCommand = new SqlCommand(';SELECT * FROM CUSTOMERS ';, MyConnection);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(MyCommand);
MyCommand.Connection.Open();
da.Fill(dt);
MyCommand.Dispose();
MyConnection.Dispose();
gvwTest.DataSource = dt;
gvwTest.DataBind();
}
protected void gvwTest_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
BindGrid();
gvwTest.PageIndex = e.NewPageIndex;
gvwTest.DataBind();
}
%26lt;/script%26gt;
%26lt;/head%26gt;
%26lt;body%26gt;
%26lt;form id=';form1'; runat=';server';%26gt;
%26lt;asp:GridView ID=';gvwTest'; runat=';server'; AutoGenerateColumns=';true'; AllowPaging=';true'; PageSize=';10';
OnPageIndexChanging=';gvwTest_PageIndex鈥? /%26gt;
%26lt;/form%26gt;
%26lt;/body%26gt;
%26lt;/html%26gt;
Remember.. look for gridView code snippets not DataGrid!!
Hope the above helps.
Visual Basic 6.0 Questions?
1. how to filter ms access database records when u have a textbox searchbox,
then the record u will filter or search has apostrophe (')?
pls give me sample code ...
2. also how can u bind the DATAGRID control (not flexgrid) using adodb (coding)?
3. how can u create a backup of ur database when ur frontend is visual basic?
4. how can u export from access database to ms excel file with vb as the front end?
hope to hear from u. take care. thanks in advance.
=)Visual Basic 6.0 Questions?
Too much questions :).
Visit the websites you may can get codes
http://www.ecodebank.com
http://www.freevbcode.com
http://www.vbdiamond.com
http://www.planetsourcecode.com
then the record u will filter or search has apostrophe (')?
pls give me sample code ...
2. also how can u bind the DATAGRID control (not flexgrid) using adodb (coding)?
3. how can u create a backup of ur database when ur frontend is visual basic?
4. how can u export from access database to ms excel file with vb as the front end?
hope to hear from u. take care. thanks in advance.
=)Visual Basic 6.0 Questions?
Too much questions :).
Visit the websites you may can get codes
http://www.ecodebank.com
http://www.freevbcode.com
http://www.vbdiamond.com
http://www.planetsourcecode.com
ASP.Net C# Trim Method?
For example, I have 24.00 on my Table.
If I use a session variable and put it on a textbox, I only want the 24 to appear. But I don't want to change its format on the DataGrid. So I'm thinking of trimming the .00 at the end. How do I put it in code?
I think it's something like this:
TextBox1.Text.Trim()???
But I don't know how to use it.ASP.Net C# Trim Method?
text.trim only trims the spaces off the front and back. What you might want to do is used a 'masked text box' and set the mask only to non decimal places.
outside of that you will have to search the string for a period and take the substring from the start of the string to the period, but not including the period.
If I use a session variable and put it on a textbox, I only want the 24 to appear. But I don't want to change its format on the DataGrid. So I'm thinking of trimming the .00 at the end. How do I put it in code?
I think it's something like this:
TextBox1.Text.Trim()???
But I don't know how to use it.ASP.Net C# Trim Method?
text.trim only trims the spaces off the front and back. What you might want to do is used a 'masked text box' and set the mask only to non decimal places.
outside of that you will have to search the string for a period and take the substring from the start of the string to the period, but not including the period.
Simple RSS in Flex help?
I am trying to do an oh so very simple RSS reader in flex but I keep seeing so many ways to do it and none of them are working for me, from what I understand it should be as simple as:
%26lt;mx:HTTPService id=';EngadgetFeed'; url=';http://www.engadget.com/rss.xml'; /%26gt;
but then how do I bind the data to my data grid?
%26lt;mx:DataGrid id=';Feed'; x=';10'; y=';86'; height=';307';%26gt;
%26lt;mx:columns%26gt;
%26lt;mx:DataGridColumn headerText=';Title'; dataField=';col1';/%26gt;
%26lt;mx:DataGridColumn headerText=';Date'; dataField=';col2';/%26gt;
%26lt;/mx:columns%26gt;
%26lt;/mx:DataGrid%26gt;
ive tried adding : dataProvider = ';{EngadgetFeed}'; but I know im still missing something.
Can someone show me how to do it in the most simplest way? I dont need it to be amazing looking I just want it to function so I can learn how to do it.Simple RSS in Flex help?
Maybe these free online RSS Feed Makers will help...
http://jade.mcli.dist.maricopa.edu/feed/鈥?/a>
http://www.feedburner.com/fb/a/home
http://www.rssfeedsgenerator.com/
http://www.site-reference.com/rss-parser鈥?/a>
http://www.make-rss-feeds.com/rss-tags.h鈥?/a>
http://www.site-reference.com/syndicate.鈥?/a>
http://www.wotzwot.com/rssxl.php
Ron
%26lt;mx:HTTPService id=';EngadgetFeed'; url=';http://www.engadget.com/rss.xml'; /%26gt;
but then how do I bind the data to my data grid?
%26lt;mx:DataGrid id=';Feed'; x=';10'; y=';86'; height=';307';%26gt;
%26lt;mx:columns%26gt;
%26lt;mx:DataGridColumn headerText=';Title'; dataField=';col1';/%26gt;
%26lt;mx:DataGridColumn headerText=';Date'; dataField=';col2';/%26gt;
%26lt;/mx:columns%26gt;
%26lt;/mx:DataGrid%26gt;
ive tried adding : dataProvider = ';{EngadgetFeed}'; but I know im still missing something.
Can someone show me how to do it in the most simplest way? I dont need it to be amazing looking I just want it to function so I can learn how to do it.Simple RSS in Flex help?
Maybe these free online RSS Feed Makers will help...
http://jade.mcli.dist.maricopa.edu/feed/鈥?/a>
http://www.feedburner.com/fb/a/home
http://www.rssfeedsgenerator.com/
http://www.site-reference.com/rss-parser鈥?/a>
http://www.make-rss-feeds.com/rss-tags.h鈥?/a>
http://www.site-reference.com/syndicate.鈥?/a>
http://www.wotzwot.com/rssxl.php
Ron
I want to build a GUI in visual C++ that will show the contents of a MySQL database. How can I do that?
I want to build a GUI in visual C++ that will show the contents of a MySQL database and then I'll have to add stuff like only showing specific columns when i klik, but I don't know how to add the data to a datagrid (if there is a better option than using a datagrid, I'm willing to try that). I need as detailed info as possible, or link to any tutorials/help or whatever to make it as close to step by step guide, because I'm kind of an amateur in Visual C++. Any tips and ideas are very appreciatedI want to build a GUI in visual C++ that will show the contents of a MySQL database. How can I do that?
Maybe if you are flexible on language you might want to go Java for a first up on GUI design (it transports across languages and Swing is quite nice to use, though Java itself is akin to my semen freezing when I see Chris Hansen). If you were to do this, I would recommend NetBeans and you will also need the ConnectorJ library. Or maybe since you're on Windows take a geez at C#
However, C++ is a fickle language, and it is likely you will need a new library to link into your app to connect to the DB with it (don't worry, MySQL likely have it on their website). If I'm correct in my guess (I'm a Linux guy, so when I write in C I use GTK+), it's likely that each GUI component will have a member function like set_content() or the like with which you can set what ever you need
Maybe if you are flexible on language you might want to go Java for a first up on GUI design (it transports across languages and Swing is quite nice to use, though Java itself is akin to my semen freezing when I see Chris Hansen). If you were to do this, I would recommend NetBeans and you will also need the ConnectorJ library. Or maybe since you're on Windows take a geez at C#
However, C++ is a fickle language, and it is likely you will need a new library to link into your app to connect to the DB with it (don't worry, MySQL likely have it on their website). If I'm correct in my guess (I'm a Linux guy, so when I write in C I use GTK+), it's likely that each GUI component will have a member function like set_content() or the like with which you can set what ever you need
Adobe flex + .NET web services?
hi, im new in adobe flex so i have this problem that maybe easy for some of u flexperts =).
what i know is the %26lt;mx:datagrid%26gt; can accept array collections or xml files. but in my case, im not allowed to use the xml as datasource.
The webservice (.NET) returns an array (or watever collection it is with muyltiple columns).. so how can the flex datagrid accept this as an array collection?
to summarize all those bunch o' craps i mentioned earlier, i just need to populate my flex datagrid with 3 columns (the method will come from the .net webservice)...
thanksAdobe flex + .NET web services?
Within Flex, you have to convert the XML to an array. If your web service returns the data in some sort of table/row/column format, then this is pretty straightforward. Take a look at the tutorial below and let me know if that is what you are looking for.
what i know is the %26lt;mx:datagrid%26gt; can accept array collections or xml files. but in my case, im not allowed to use the xml as datasource.
The webservice (.NET) returns an array (or watever collection it is with muyltiple columns).. so how can the flex datagrid accept this as an array collection?
to summarize all those bunch o' craps i mentioned earlier, i just need to populate my flex datagrid with 3 columns (the method will come from the .net webservice)...
thanksAdobe flex + .NET web services?
Within Flex, you have to convert the XML to an array. If your web service returns the data in some sort of table/row/column format, then this is pretty straightforward. Take a look at the tutorial below and let me know if that is what you are looking for.
Visual Basic 2008 Data Update?
Ok im making a program for a local grocery. my problem is the following - ive created a database using Access. basically what i intend to do is make two Forms in vb2008. one of them will have the main databse in a datagrid and a window saying ADD/Delete/Edit and when pressed the 2nd form will show up with textboxes where i will be able to input for example a new product and when i hit save it goes back to the 1st form and the product is already added to the database there. ive already done the datagrid in the 1st form and ive put the textboxes in the 2nd form (by going to the datasource tab and just drag the text boxes in there) but i dont know how to, when i hit save and save what ive added to the textboxes so it can appear on the datagrid on the first form. anyone?Visual Basic 2008 Data Update?
This is much to complicated to do in this forum.
If you want to pay me $5,000 I will have it done in a few days. The choice is yours!love myspace myspace girl
This is much to complicated to do in this forum.
If you want to pay me $5,000 I will have it done in a few days. The choice is yours!
Vb .net help database?
Dim historyconnection As OleDbConnection = New OleDb.OleDbConnection(';Provider=Microsof鈥?Source=D:\@skul\fifth\tralala.mdb';)
Dim historyadapter As OleDbDataAdapter = New OleDb.OleDbDataAdapter(';SELECT [historyd].[accession number], books.title,[history date].[date borrowed],[history date].[date returned] FROM historyd, books where [history date].[accession number] = [books].[accession number]';, historyconnection)
Dim historydataset As DataSet = New DataSet
HOW DO I MAKE THIS QUERY APPEAR IN THE DATAGRID?
are there any programmers there who would like to help a beginner?! IM me pls.Vb .net help database?
The below given link may help you
http://vb-helper.com/howto_net_datagrid.鈥?/a>Vb .net help database?
check out http://www.pscode.com - great site for source code. I do VB-6 programming, and use that site all the time.
Dim historyadapter As OleDbDataAdapter = New OleDb.OleDbDataAdapter(';SELECT [historyd].[accession number], books.title,[history date].[date borrowed],[history date].[date returned] FROM historyd, books where [history date].[accession number] = [books].[accession number]';, historyconnection)
Dim historydataset As DataSet = New DataSet
HOW DO I MAKE THIS QUERY APPEAR IN THE DATAGRID?
are there any programmers there who would like to help a beginner?! IM me pls.Vb .net help database?
The below given link may help you
http://vb-helper.com/howto_net_datagrid.鈥?/a>Vb .net help database?
check out http://www.pscode.com - great site for source code. I do VB-6 programming, and use that site all the time.
How to solve this search problem??using datagrids and vb.net?
If cboSearch.Text = ';Books'; Then
Dim ProductId As String
txtProductID.Text = ProductId
ProductId = ';SELECT ID, ISBN, Title,Format, Quantity FROM BooksInfo WHERE ISBN =''; %26amp; ProductId %26amp; ';'';
Dim dt As New DataTable
OleDbDataAdapter1.Fill(dt)
DataGrid1.DataSource = dt
End If
There's 1 combobox(with the category choices) and 1 textbox...user have to choose the category from the cbobox and type the productid in the txtbox...when i run this code only the info for B0001 is supposed to show on the datagrid, but when i run it..the whole list comes out...how do i solve this??How to solve this search problem??using datagrids and vb.net?
with this new information try this:
dim cn as new adodb.connection
dim rs as new adodb.recordset
set cn = new adodb.connection
set rs = new adodb.reocrdset
cn.Open ';Provider=Microsoft.Jet.OLEDB.4.0;'; %26amp; _
';Persist Security Info=False;'; %26amp; _
';Data Source=C:\database.mdb';
If cboSearch.Text = ';Books'; Then
Dim ProductId As String
txtProductID.Text = ProductId
ProductId = ';SELECT ID, ISBN, Title,Format, Quantity FROM BooksInfo WHERE ISBN =''; %26amp; ProductId %26amp; ';'';
'Dim dt As New DataTable
rs.Open ProductId , cn, adOpenDynamic, adLockOptimistic
'OleDbDataAdapter1.Fill(dt)
DataGrid1.DataSource = rs
End If
rs.close
cn.close
set rs = nothing
set cn = nothing
hope I didn't miss anything
Dim ProductId As String
txtProductID.Text = ProductId
ProductId = ';SELECT ID, ISBN, Title,Format, Quantity FROM BooksInfo WHERE ISBN =''; %26amp; ProductId %26amp; ';'';
Dim dt As New DataTable
OleDbDataAdapter1.Fill(dt)
DataGrid1.DataSource = dt
End If
There's 1 combobox(with the category choices) and 1 textbox...user have to choose the category from the cbobox and type the productid in the txtbox...when i run this code only the info for B0001 is supposed to show on the datagrid, but when i run it..the whole list comes out...how do i solve this??How to solve this search problem??using datagrids and vb.net?
with this new information try this:
dim cn as new adodb.connection
dim rs as new adodb.recordset
set cn = new adodb.connection
set rs = new adodb.reocrdset
cn.Open ';Provider=Microsoft.Jet.OLEDB.4.0;'; %26amp; _
';Persist Security Info=False;'; %26amp; _
';Data Source=C:\database.mdb';
If cboSearch.Text = ';Books'; Then
Dim ProductId As String
txtProductID.Text = ProductId
ProductId = ';SELECT ID, ISBN, Title,Format, Quantity FROM BooksInfo WHERE ISBN =''; %26amp; ProductId %26amp; ';'';
'Dim dt As New DataTable
rs.Open ProductId , cn, adOpenDynamic, adLockOptimistic
'OleDbDataAdapter1.Fill(dt)
DataGrid1.DataSource = rs
End If
rs.close
cn.close
set rs = nothing
set cn = nothing
hope I didn't miss anything
Vb.net Conection with 2 tables of an Access Bd?
i have 2 table student and inscription, and i need that those tables, all in one form like a view but with all the features like , update,erase and saved, because i try and nothing happen , The form i try is like with textbox and i don't need datagrid , some one know how to do this ???Vb.net Conection with 2 tables of an Access Bd?
make querry
make querry
ListView or any other Component in ASP.net?
We want to add Records in Tabular form from collection of text boxes..Data Grid can be used for this purpose but DataGrid uses the DataBase as a data source but our Data Sourc is Collection of Text Boxes and we want a component like list view or Data Grid...Plz tell me from where we can get it Free or Tell me how can we solve this Problem..plz tell me as soon as possible..ListView or any other Component in ASP.net?
You want to bind your grid to a datatable, which you will use to store results.
I will provide code for this shortly in my Yahoo! 360 blog and will update this answer when the solution is complete.
UPDATE: Here is the link:
http://blog.360.yahoo.com/blog-NVb99sQ4R鈥?/a>
You want to bind your grid to a datatable, which you will use to store results.
I will provide code for this shortly in my Yahoo! 360 blog and will update this answer when the solution is complete.
UPDATE: Here is the link:
http://blog.360.yahoo.com/blog-NVb99sQ4R鈥?/a>
Hello there?
I would like to know how to upload images into MS ACCESS database? using ASP.NET and then view them using Datagrid.
Please provide me with the screen shots and the codes if possible
Thank you for all your help/Hello there?
I will put together a demo and update this answer when it is done, in about 12 hours.
UPDATE, 3/21/06: I have finally posted the answer to my blog and my demo site:
http://blog.360.yahoo.com/blog-NVb99sQ4R鈥?/a>Hello there?
What the heck r u on about?
Please provide me with the screen shots and the codes if possible
Thank you for all your help/Hello there?
I will put together a demo and update this answer when it is done, in about 12 hours.
UPDATE, 3/21/06: I have finally posted the answer to my blog and my demo site:
http://blog.360.yahoo.com/blog-NVb99sQ4R鈥?/a>Hello there?
What the heck r u on about?
Would u pls answer these questions?
1.What is disco file?
2.What are the events fired when web service called?
3.How will do transaction in Web Services?
4.In what order do the events of an ASPX page execute. As a developer is it important to undertsand these events?
5.How would you get ASP.NET running in Apache web servers - why would you even do this?
6.What tags do you need to add within the asp:datagrid tags to bind columns manually?
7.What are the page level transaction and class level transaction?
8.What are different transaction options?
9.What is the namespace for encryption?
10.What is the difference between application and cache variables?
11.What is the difference between control and component?
12.You ve defined one page_load event in aspx page and same page_load event in code behind how will prog run?
13.What r the diff types of inheritance in C#?give examples or syntax?
14.What is delegates in C#?
these r some interview questions.pls give answer.........Would u pls answer these questions?
Do your own homework.
www.asp.net
www.codeproject.com
www.msdn.com
www.gotdotnet.comWould u pls answer these questions?
Check it on the MSDN of .NET you will get all the Answer
Sounds like someone's trying to cheat her way through an exam / homework.
If we give you the answers, you'll never remember them. Search, learn, remember.
Google it if you must...love myspace myspace girl
2.What are the events fired when web service called?
3.How will do transaction in Web Services?
4.In what order do the events of an ASPX page execute. As a developer is it important to undertsand these events?
5.How would you get ASP.NET running in Apache web servers - why would you even do this?
6.What tags do you need to add within the asp:datagrid tags to bind columns manually?
7.What are the page level transaction and class level transaction?
8.What are different transaction options?
9.What is the namespace for encryption?
10.What is the difference between application and cache variables?
11.What is the difference between control and component?
12.You ve defined one page_load event in aspx page and same page_load event in code behind how will prog run?
13.What r the diff types of inheritance in C#?give examples or syntax?
14.What is delegates in C#?
these r some interview questions.pls give answer.........Would u pls answer these questions?
Do your own homework.
www.asp.net
www.codeproject.com
www.msdn.com
www.gotdotnet.comWould u pls answer these questions?
Check it on the MSDN of .NET you will get all the Answer
Sounds like someone's trying to cheat her way through an exam / homework.
If we give you the answers, you'll never remember them. Search, learn, remember.
Google it if you must...
Vb .net datagridview oledb?
how do i get a single row like in listbox i can use ';listbox1.selectedindex = 0'; how do i do it in datagrid.
if there is a programmer out there who would like to teach a complete idiot. please contact me.Vb .net datagridview oledb?
Here it is your code -assume you have named your DataGridView ';DataGrid';! (I haven't work with DataGridViews before but I've done a lot of other things - so I found it easily!):
'First, deselect every selected cell/row/column!
DataGrid.ClearSelection()
'Then select your row - replace 0 with the index of the row!
DataGrid.Rows(0).Selected = True
if there is a programmer out there who would like to teach a complete idiot. please contact me.Vb .net datagridview oledb?
Here it is your code -assume you have named your DataGridView ';DataGrid';! (I haven't work with DataGridViews before but I've done a lot of other things - so I found it easily!):
'First, deselect every selected cell/row/column!
DataGrid.ClearSelection()
'Then select your row - replace 0 with the index of the row!
DataGrid.Rows(0).Selected = True
I am using asp.net 1.0. i want to know paging concept.?
i am retreiving data from my databse to my datagrid. but i want to display 5 rows first and if i click on next the next 5 rows will display. i dont know how to do this. complete rows from my database is comming. thanks in advance.I am using asp.net 1.0. i want to know paging concept.?
http://aspnet.4guysfromrolla.com/article鈥?/a>
http://aspnet.4guysfromrolla.com/article鈥?/a>
Vb.net question?
how to print the contents of a datagrid?Vb.net question?
datagrid has its function to print. you can evoke that from a command button.
they have removed this page but see it quick before the cache from google goes off http://64.233.167.104/search?q=cache:_Rw鈥?/a>
datagrid has its function to print. you can evoke that from a command button.
they have removed this page but see it quick before the cache from google goes off http://64.233.167.104/search?q=cache:_Rw鈥?/a>
I need a VB.Net and ASP tutor!!!!!!?
i have to do this project and i've come to the point where i am going to GIVE UP which is a really bad thing coz this project is very important!! SOME KIND SOUL, PLEASE HELP ME!! i need someone who could teach me how to code using visual studio .net 2003!!this is xtremely URGENT!!
Details of the project: online sales and inventory for a bookshop
inventory is using vb.net in vs .net 2003 and the sales is using asp...
I am using MS Access for the database
Main problems:
1) i don't know how to connect the database to the code
2) i have tried so many variations in the coding for logging in and i can't seem to get even THAT right!!
3) I also need to be able to show selected details using the datagrid as well as how to edit and update it
Please help me!!!I need a VB.Net and ASP tutor!!!!!!?
i can help u in asp if u wanna it pls send ur project details to my mail
amit_shri05@yahoo.co.in
Details of the project: online sales and inventory for a bookshop
inventory is using vb.net in vs .net 2003 and the sales is using asp...
I am using MS Access for the database
Main problems:
1) i don't know how to connect the database to the code
2) i have tried so many variations in the coding for logging in and i can't seem to get even THAT right!!
3) I also need to be able to show selected details using the datagrid as well as how to edit and update it
Please help me!!!I need a VB.Net and ASP tutor!!!!!!?
i can help u in asp if u wanna it pls send ur project details to my mail
amit_shri05@yahoo.co.in
I have a asp.net page for Search............. pls read the details?
I have a asp.net page for search records from db. and i show that records in a Datagrid, from the Grid when i click the particular record's id, i redirect the page to new page, in that page i show the record in details. after i have seen that record, if i cancel from the page. it should be come to the search page again. in that search page the keywords for search previously, what i hve given, should be maintain, when i come back to the search page from the NewPage(Record view in detail. ) Anyone can tell pls how to do that?I have a asp.net page for Search............. pls read the details?
Probably you are using hyperlink to transfer user to see the record details.
Instaed do like this:
* When clicked on ID, Pass the ID to a javascript code function. *That function will create a popup window dynamically and calls the new page by passing the ID as query string.
*In the new window, when you close, it just returns to old window.
*That page is not refreshed.
Probably you are using hyperlink to transfer user to see the record details.
Instaed do like this:
* When clicked on ID, Pass the ID to a javascript code function. *That function will create a popup window dynamically and calls the new page by passing the ID as query string.
*In the new window, when you close, it just returns to old window.
*That page is not refreshed.
Visual Basic Help Please-Urgent?
How to show a record set generated from a sql statement in DataGrid Control..say adoRecordSet how to get this record set in to datagrid?Visual Basic Help Please-Urgent?
In COMPONENTS check mark the following and place them on your form:
Microsoft ADO Data Control 6.0 (SP4) (OLEDB)
Microsoft DataGrid Control 6.0 (SP5) (OLEDB)
Private Sub Form_Load()
Adodc1.ConnectionString = ';Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\test.mdb';
Adodc1.RecordSource = ';SELECT * FROM Table1';
Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1
End SubVisual Basic Help Please-Urgent?
Hai Poojitha,
Place an adodc control on the form and provide the connection string in it and in that control there will be option to give sql query, give it. Specify the data source of datagrid control to Adodc and data field to member retrieved from query.
Bye Alex
set the Datasource property of that grid
set grid.datasource = recordsetlove myspace myspace girl
In COMPONENTS check mark the following and place them on your form:
Microsoft ADO Data Control 6.0 (SP4) (OLEDB)
Microsoft DataGrid Control 6.0 (SP5) (OLEDB)
Private Sub Form_Load()
Adodc1.ConnectionString = ';Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\test.mdb';
Adodc1.RecordSource = ';SELECT * FROM Table1';
Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1
End SubVisual Basic Help Please-Urgent?
Hai Poojitha,
Place an adodc control on the form and provide the connection string in it and in that control there will be option to give sql query, give it. Specify the data source of datagrid control to Adodc and data field to member retrieved from query.
Bye Alex
set the Datasource property of that grid
set grid.datasource = recordset
Give me the complete code pls.in VB.Net?
What I have is a datagrid on my form populated with various pieces of
information. What I would like is to be able to start typing and have
the datagrid move to the thing I'm typing if it exists.
For example given the list:
Ant
Cat
Dog
Dolphin
Puppy
Snake
Snail
Zebra
If I started typing ';Do'; then the list would move to Dog..and then if I
typed a ';Dol'; the list would move to Dolphin. It's the same way all
the file searching works in windows.
Any ideas how I would do this guys?Give me the complete code pls.in VB.Net?
refer this field to a data source...
listen, check the MSDN, u can find everything thereGive me the complete code pls.in VB.Net?
Hello, i'm sure there many ways to skin a cat when it comes to programming.. one way of doing it.. would be.. first create a dataset because it supports Select statement then add datatable to it with all your names. after that set datasource to the table.. and monitor keypress in text box.. long story short.
Public Class Form1
Private DTS As New DataSet
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim DT As New DataTable(';tblData';)
DT.Columns.Add(';Name';)
DT.Columns.Add(';Index';)
With DT.Rows
.Add(';Ant';, ';0';)
.Add(';Cat';, ';1';)
.Add(';Dog';, ';2';)
.Add(';Dolphin';, ';3';)
.Add(';Puppy';, ';4';)
.Add(';Snake';, ';5';)
.Add(';Snail';, ';6';)
.Add(';Zebra';, ';7';)
End With
DataGridView1.DataSource = DT
DataGridView1.ClearSelection()
DTS.Tables.Add(DT)
End Sub
Private Sub TextBox1_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyUp
Dim DR() As DataRow
Dim Index As Integer
DR = DTS.Tables(';tblData';).Select(';[Name] LIKE ''; %26amp; TextBox1.Text %26amp; ';*'';)
If DR.Length %26gt; 0 And TextBox1.Text.Length %26gt; 0 Then
DataGridView1.ClearSelection()
Index = DR(0)(';Index';)
DataGridView1.Rows(Index).Selected = True
Else
DataGridView1.ClearSelection()
End If
End Sub
End Class
in this case, i assigned an index to each name, it will select only the first match, you can modify it to select all matches.
another one, simply add that to your textbox keyup event
Private Sub TextBox1_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyUp
Dim iFound As Integer = -1
Dim myRow As DataGridViewRow
DataGridView1.AllowUserToAddRows = False
DataGridView1.ClearSelection()
For Each myRow In DataGridView1.Rows
iFound = myRow.Cells(';Name';).Value.ToString.Index鈥?br>
If iFound %26gt;= 0 And TextBox1.Text.Length %26gt; 0 Then
myRow.Selected = True
Exit Sub
End If
Next
DataGridView1.ClearSelection()
DataGridView1.AllowUserToAddRows = False
End Sub
you can modify it so it's not case sensative.
information. What I would like is to be able to start typing and have
the datagrid move to the thing I'm typing if it exists.
For example given the list:
Ant
Cat
Dog
Dolphin
Puppy
Snake
Snail
Zebra
If I started typing ';Do'; then the list would move to Dog..and then if I
typed a ';Dol'; the list would move to Dolphin. It's the same way all
the file searching works in windows.
Any ideas how I would do this guys?Give me the complete code pls.in VB.Net?
refer this field to a data source...
listen, check the MSDN, u can find everything thereGive me the complete code pls.in VB.Net?
Hello, i'm sure there many ways to skin a cat when it comes to programming.. one way of doing it.. would be.. first create a dataset because it supports Select statement then add datatable to it with all your names. after that set datasource to the table.. and monitor keypress in text box.. long story short.
Public Class Form1
Private DTS As New DataSet
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim DT As New DataTable(';tblData';)
DT.Columns.Add(';Name';)
DT.Columns.Add(';Index';)
With DT.Rows
.Add(';Ant';, ';0';)
.Add(';Cat';, ';1';)
.Add(';Dog';, ';2';)
.Add(';Dolphin';, ';3';)
.Add(';Puppy';, ';4';)
.Add(';Snake';, ';5';)
.Add(';Snail';, ';6';)
.Add(';Zebra';, ';7';)
End With
DataGridView1.DataSource = DT
DataGridView1.ClearSelection()
DTS.Tables.Add(DT)
End Sub
Private Sub TextBox1_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyUp
Dim DR() As DataRow
Dim Index As Integer
DR = DTS.Tables(';tblData';).Select(';[Name] LIKE ''; %26amp; TextBox1.Text %26amp; ';*'';)
If DR.Length %26gt; 0 And TextBox1.Text.Length %26gt; 0 Then
DataGridView1.ClearSelection()
Index = DR(0)(';Index';)
DataGridView1.Rows(Index).Selected = True
Else
DataGridView1.ClearSelection()
End If
End Sub
End Class
in this case, i assigned an index to each name, it will select only the first match, you can modify it to select all matches.
another one, simply add that to your textbox keyup event
Private Sub TextBox1_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyUp
Dim iFound As Integer = -1
Dim myRow As DataGridViewRow
DataGridView1.AllowUserToAddRows = False
DataGridView1.ClearSelection()
For Each myRow In DataGridView1.Rows
iFound = myRow.Cells(';Name';).Value.ToString.Index鈥?br>
If iFound %26gt;= 0 And TextBox1.Text.Length %26gt; 0 Then
myRow.Selected = True
Exit Sub
End If
Next
DataGridView1.ClearSelection()
DataGridView1.AllowUserToAddRows = False
End Sub
you can modify it so it's not case sensative.
What is ADODC in VB ?
how to place an Ado control in VB form and connect it to Datagrid ....I want the drag and drop method, not the written method...please help me soon....What is ADODC in VB ?
You need drag the ADODC control onto your form. Then set the controls data source properties to the specific database, making sure that the connection string is correct. Then set up your SQL statement inside the control's properties. Drag a datagrid onto the form and set its row source property equal to the ADODC control.
You need drag the ADODC control onto your form. Then set the controls data source properties to the specific database, making sure that the connection string is correct. Then set up your SQL statement inside the control's properties. Drag a datagrid onto the form and set its row source property equal to the ADODC control.
I'm trying to learn Visual Studio 2005 and I'm having a difficulty with databases.?
I'm trying to learn Visual Studio 2005 and I'm having a difficulty with databases.
I am new at VS 2005 (C#) and I'm now trying to learn how to connect my excel spreadsheet with it. and its giving me an error ';ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ';
I'm trying to connect it to a datagrid. Am I forgeting something? I tested the connection and it was Ok.I'm trying to learn Visual Studio 2005 and I'm having a difficulty with databases.?
I am very sure you can get some help from the sample programs. Try this site
http://www.planetsourcecode.comI'm trying to learn Visual Studio 2005 and I'm having a difficulty with databases.?
Hii.......
i think u are using VB.60 of visual stuio.
From ur error message, it shows tat u r trying to connect to a SQL database, not to an excel's.
So jus take care in selecting the options
in the '; connect '; property of ur data, jus select the correct version of excel, that u r using, also be careful in selecting ur recordset.
hope it works
u may rite 2 me
I am new at VS 2005 (C#) and I'm now trying to learn how to connect my excel spreadsheet with it. and its giving me an error ';ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ';
I'm trying to connect it to a datagrid. Am I forgeting something? I tested the connection and it was Ok.I'm trying to learn Visual Studio 2005 and I'm having a difficulty with databases.?
I am very sure you can get some help from the sample programs. Try this site
http://www.planetsourcecode.comI'm trying to learn Visual Studio 2005 and I'm having a difficulty with databases.?
Hii.......
i think u are using VB.60 of visual stuio.
From ur error message, it shows tat u r trying to connect to a SQL database, not to an excel's.
So jus take care in selecting the options
in the '; connect '; property of ur data, jus select the correct version of excel, that u r using, also be careful in selecting ur recordset.
hope it works
u may rite 2 me
How to highlight a pericular cells in a data grid with different backcolor in ASP.net. Not a row, but a cell?
Highlight a cell and not a row of a datagrid in ASP.NET and not ASPHow to highlight a pericular cells in a data grid with different backcolor in ASP.net. Not a row, but a cell?
Create an handler for the OnItemDataBound() event. From there, you can manually draw the cells and change the color on a cell by cell basis.How to highlight a pericular cells in a data grid with different backcolor in ASP.net. Not a row, but a cell?
Are pericular cells the ones colored periwinkle?
TFTP
Create an handler for the OnItemDataBound() event. From there, you can manually draw the cells and change the color on a cell by cell basis.How to highlight a pericular cells in a data grid with different backcolor in ASP.net. Not a row, but a cell?
Are pericular cells the ones colored periwinkle?
TFTP
Displaying a Dataset in a Data View Grid Contol VB.net 2005?
I have a grid view control on my form and I have another class with a method that returns a Dataset.
How do I get the grid to display the Dataset?
I keep reading about a SetDataBinding method, is this still available in VB 2005 cause I get an error that its not part of the DataGrid Control and it doesnt show up on the drop down list.Displaying a Dataset in a Data View Grid Contol VB.net 2005?
in WinForms use dgMyGrid.DataSource = myDataset.Tables(0) But in ASP.NET you MUST add Page.DATABIND() which is a method that tells page to bind data to grid.
How do I get the grid to display the Dataset?
I keep reading about a SetDataBinding method, is this still available in VB 2005 cause I get an error that its not part of the DataGrid Control and it doesnt show up on the drop down list.Displaying a Dataset in a Data View Grid Contol VB.net 2005?
in WinForms use dgMyGrid.DataSource = myDataset.Tables(0) But in ASP.NET you MUST add Page.DATABIND() which is a method that tells page to bind data to grid.
How to change a coulms data in a data set in c#?
i have a data set i have returned by a class, i want to go to the price column for each row and add vat to the price, before i populate the datagridHow to change a coulms data in a data set in c#?
if it was C# .NET you need to click on your datagrid and assign a data source to it as you have done.. But that datasource should be some sort of query... So that query which is a price column should be adding a vat to the price...
Else you have to make your own controllove myspace myspace girl
if it was C# .NET you need to click on your datagrid and assign a data source to it as you have done.. But that datasource should be some sort of query... So that query which is a price column should be adding a vat to the price...
Else you have to make your own control
Fill datagridview in vb.net?
I have creadte relationship between two tables . %26amp; I want to display data from both tables using dataset in one datagrid view . How can I do this .
table stud_info has fields like sno,sname (sno has primary key ,has relationship with stud_marks )
table stud_marks has fields sno, mark1,mark2Fill datagridview in vb.net?
http://www.google.co.in/search?hl=en%26amp;cli鈥?/a>
http://www.vbforums.com/archive/index.ph鈥?/a>
table stud_info has fields like sno,sname (sno has primary key ,has relationship with stud_marks )
table stud_marks has fields sno, mark1,mark2Fill datagridview in vb.net?
http://www.google.co.in/search?hl=en%26amp;cli鈥?/a>
http://www.vbforums.com/archive/index.ph鈥?/a>
Wednesday, August 18, 2010
How to access huge data from Access?
From VB 6, using Access, I want to display, search, etc data from access by using datagrid or listview objects in Visual Basic 6. But it takes more than 60 sec. for 1 lack rows. So I need some trick to overcome this problem.How to access huge data from Access?
Don't use listview for large datasets, its too slow.
Datagrid should work better if you use it in conjunction with ADODC and let it do the pagination for you (meaning loading page by page of data for display).
Minimize number of columns on datagrid (avoid ';Select *';) and avoid complex formatting. Do not use callbacks (any event function) for formatting of data.
So, a ';clean'; recordset display on the ADODC+datagrid with not too many columns and no formatting should work quite fast. If it does not (I doubt), then its a lot of programming.How to access huge data from Access?
Don't bring back all of the data to the client at one time. Bring back just the minimum amount necessary to display in a list at one time. As the user scrolls through the list, fetch more rows from the db. I know that's a pain, but it's the only way to get acceptable performance.
The other thing you can do is to fetch some of the data and when that comes back start fetching the rest on a background thread so that it does not interfere with the user working in the foreground.
Don't use listview for large datasets, its too slow.
Datagrid should work better if you use it in conjunction with ADODC and let it do the pagination for you (meaning loading page by page of data for display).
Minimize number of columns on datagrid (avoid ';Select *';) and avoid complex formatting. Do not use callbacks (any event function) for formatting of data.
So, a ';clean'; recordset display on the ADODC+datagrid with not too many columns and no formatting should work quite fast. If it does not (I doubt), then its a lot of programming.How to access huge data from Access?
Don't bring back all of the data to the client at one time. Bring back just the minimum amount necessary to display in a list at one time. As the user scrolls through the list, fetch more rows from the db. I know that's a pain, but it's the only way to get acceptable performance.
The other thing you can do is to fetch some of the data and when that comes back start fetching the rest on a background thread so that it does not interfere with the user working in the foreground.
Visual Basic 2005 Grid Control?
I want to use a grid or table control for displaying some program output in a grid style. This is not data from a database. How do I use the DataGrid without binding to a datasource, or what else can I use?Visual Basic 2005 Grid Control?
The DataGrid can DataBind to classes as well as database sources, you do all this in a similar way to how you would bind to a DataTable. MSDN has plenty of examples so I don't see a need to provide one here, but I often use the DataGrid without using data bases for grid / matrix based object editing.Visual Basic 2005 Grid Control?
If the information that you plan to display is lengthy, you are better off putting them in an xml file and use it as the datasource.
Otherwise, insert each row to the grid control programmatically. Code would look like this:
Dim nr as DataRow = Table.NewRow()
'Add stuff to row
Table.rows.add( nr )
The DataGrid can DataBind to classes as well as database sources, you do all this in a similar way to how you would bind to a DataTable. MSDN has plenty of examples so I don't see a need to provide one here, but I often use the DataGrid without using data bases for grid / matrix based object editing.Visual Basic 2005 Grid Control?
If the information that you plan to display is lengthy, you are better off putting them in an xml file and use it as the datasource.
Otherwise, insert each row to the grid control programmatically. Code would look like this:
Dim nr as DataRow = Table.NewRow()
'Add stuff to row
Table.rows.add( nr )
C# programming question - please help?
I must write a program that can insert, update and delete entries from a Microsoft Access database. When viewing entries from the database, they must be shown in a DataGrid control. And I must use a three tier approach: database layer, business layer, presentation layer. Please show me how to do this? ThanksC# programming question - please help?
why should we do your homework?C# programming question - please help?
First off, I have to say I agree with Answerman. Alot of your queries could simply be resolved with a Google search...
I agree with the other posters. However to get you started on your adventure you need to be researching the topic of data binding.
Good luck!
connecting to the access database isn't difficult... check here
http://www.webwizguide.com/kb/asp_tutori鈥?/a>
Using a datagrid isn't hard either. Drag one from the toolbox to the form and set the datasource property of the datagrid to the datatable you retrieved from the access database.
some pseudocode
dim myDataTable as Datatable
(put code to connect to the database here. have the query results returned as type datatable)
myDataTable = query results
dim myDGrid as datagrid
myDGrid.datasource = myDatatable
why should we do your homework?C# programming question - please help?
First off, I have to say I agree with Answerman. Alot of your queries could simply be resolved with a Google search...
I agree with the other posters. However to get you started on your adventure you need to be researching the topic of data binding.
Good luck!
connecting to the access database isn't difficult... check here
http://www.webwizguide.com/kb/asp_tutori鈥?/a>
Using a datagrid isn't hard either. Drag one from the toolbox to the form and set the datasource property of the datagrid to the datatable you retrieved from the access database.
some pseudocode
dim myDataTable as Datatable
(put code to connect to the database here. have the query results returned as type datatable)
myDataTable = query results
dim myDGrid as datagrid
myDGrid.datasource = myDatatable
How to refresh Database in C# ?
I have DataSet, BindingSource, TableAdapter.
When I delete row from DataSet it deleted from DataGrid, but not deleted
from Database.
When I delete row from TableAtapter or by SqlCommande it deleted from
DataBase but not deleted from DataGridHow to refresh Database in C# ?
U need to call a datagrid.Update after it is deleted out of hte Grid. Or you need to re-fill the grid after u run the sqlcommand.
I presonaly would create the application/webapp using the ADO.NET disconnected feature. I would create an dataset, datatable and fill the datagrid using a SqlDataAdapter. Then all you need to do is call ';SqlDataAdapter.Fill'; to update the Grid and to delete all you have to do is delete a row (via GUI and programaticly) and call ';SqlDataAdapter.Update'; to delete out of the database.
Enjoy -How to refresh Database in C# ?
this.myTableTableAdapter.Fill(… that code created in your Form1_load
So you should copy and past in your button
example:
private void delete_Click(object sender, EventArgs e)
{
this.myTableTableAdapter.Fil…
}
When I delete row from DataSet it deleted from DataGrid, but not deleted
from Database.
When I delete row from TableAtapter or by SqlCommande it deleted from
DataBase but not deleted from DataGridHow to refresh Database in C# ?
U need to call a datagrid.Update after it is deleted out of hte Grid. Or you need to re-fill the grid after u run the sqlcommand.
I presonaly would create the application/webapp using the ADO.NET disconnected feature. I would create an dataset, datatable and fill the datagrid using a SqlDataAdapter. Then all you need to do is call ';SqlDataAdapter.Fill'; to update the Grid and to delete all you have to do is delete a row (via GUI and programaticly) and call ';SqlDataAdapter.Update'; to delete out of the database.
Enjoy -How to refresh Database in C# ?
this.myTableTableAdapter.Fill(… that code created in your Form1_load
So you should copy and past in your button
example:
private void delete_Click(object sender, EventArgs e)
{
this.myTableTableAdapter.Fil…
}
Report Abuse
Connecting Visual Basic and Databases?
How can I connect my visual basic program to a web phpmyadmin database/table and have a datagrid thingy display the contents of a table?Connecting Visual Basic and Databases?
if u get the answer from any one just inform me
i too had similar query
gemini_kishore@hotmail.comlove myspace myspace girl
if u get the answer from any one just inform me
i too had similar query
gemini_kishore@hotmail.com
How to pass the arraylist value to the next form using session..?
my code looks something like..
Dim selectedRows As ArrayList
selectedRows = New ArrayList
For Each dgitem In DataGrid1.Items
chk = dgitem.FindControl(';Checkbox1';)
If chk.Checked = True Then
'selectedRows.Add(CType(dgitem.FindContr鈥?CheckBox).Text)
End If
Next
session(';field';)=selectedRows
....
in this i had place a check box inside the datagrid..
what i did was.. i filled the array with checked value from the datagrid..
what i want to do is i have to pass these arraylist value to the next form using session..
it's not workin for me..... help me out to overcome this problem..it's urgent,...
thank u..How to pass the arraylist value to the next form using session..?
If it is a INPROC session, you can store the ArrayList in Session right?
For other state modes, you may need to serialize and store.
Dim selectedRows As ArrayList
selectedRows = New ArrayList
For Each dgitem In DataGrid1.Items
chk = dgitem.FindControl(';Checkbox1';)
If chk.Checked = True Then
'selectedRows.Add(CType(dgitem.FindContr鈥?CheckBox).Text)
End If
Next
session(';field';)=selectedRows
....
in this i had place a check box inside the datagrid..
what i did was.. i filled the array with checked value from the datagrid..
what i want to do is i have to pass these arraylist value to the next form using session..
it's not workin for me..... help me out to overcome this problem..it's urgent,...
thank u..How to pass the arraylist value to the next form using session..?
If it is a INPROC session, you can store the ArrayList in Session right?
For other state modes, you may need to serialize and store.
How to avoid event calling when refresh from browser?
i have asp.net form with some data on datagrid, i have written
ondeletecommnad event of datagrid to remove single row data
it works fine
but the problem is whenever i delete record from last row of datagird on ondeletecommnad event , it fires, then i refresh browser either by f5 or button, then event does not fires again
But whenever i delete record from any row except than last row of datagird on ondeletecommnad event , it fires, then i refresh browser either by f5 or button, then event again fires
I checked it by Debugging the applicationHow to avoid event calling when refresh from browser?
In the first line of your page load, try this:
If NOT Postback then
with the END IF at the end of the page load.
It should only run the event the first time you hit the page in a Session. If you hit it again or 'post back' to the same page the IF statement skips that event.
ondeletecommnad event of datagrid to remove single row data
it works fine
but the problem is whenever i delete record from last row of datagird on ondeletecommnad event , it fires, then i refresh browser either by f5 or button, then event does not fires again
But whenever i delete record from any row except than last row of datagird on ondeletecommnad event , it fires, then i refresh browser either by f5 or button, then event again fires
I checked it by Debugging the applicationHow to avoid event calling when refresh from browser?
In the first line of your page load, try this:
If NOT Postback then
with the END IF at the end of the page load.
It should only run the event the first time you hit the page in a Session. If you hit it again or 'post back' to the same page the IF statement skips that event.
How to Edit Data in GridView using ASP.NET and VB.NEt?
_______________
I have pulled data from SQL Server into a datagrid control.
I have Edit buttons. But, when I clicked on one, and then try to edit data in that row, the data is still in read-only mode.
What must I do to solve this problem?
_______________How to Edit Data in GridView using ASP.NET and VB.NEt?
Here's how its done:
http://quickstarts.asp.net/QuickStartv20鈥?/a>
Check the last example.
Hope this helps.How to Edit Data in GridView using ASP.NET and VB.NEt?
The data retrieved for the gridview MUST have a single-field primary key ,or no go.
The CommandName for the button or link MUST be ';Edit';.
Good luck.
I have pulled data from SQL Server into a datagrid control.
I have Edit buttons. But, when I clicked on one, and then try to edit data in that row, the data is still in read-only mode.
What must I do to solve this problem?
_______________How to Edit Data in GridView using ASP.NET and VB.NEt?
Here's how its done:
http://quickstarts.asp.net/QuickStartv20鈥?/a>
Check the last example.
Hope this helps.How to Edit Data in GridView using ASP.NET and VB.NEt?
The data retrieved for the gridview MUST have a single-field primary key ,or no go.
The CommandName for the button or link MUST be ';Edit';.
Good luck.
How to re-size a drop down width in HTML?
In ASP.NET, I have used datagrid, in datagrid one label and one dropdown list, when i have added the data into dropdown list, some extra spaces are there
http://dedicated.ecompro.com/ProductDeta鈥?/a>
use this link
tell me what is the problemHow to re-size a drop down width in HTML?
set the width with style sheets
%26lt;select style=';width:300px;';%26gt;
鈼?The best HTML/XHTML Reference
鈻?http://www.w3schools.com/tags.asp
鈼?The best Cascading Style Sheet Reference
鈻?http://www.w3schools.com/css/css_referen鈥?/a> html
鈼?Links to HTML/HTML related sites
鈻?http://www.websitetips.com/html/
鈼?Links to Cascading Style Sheet related sites
鈻?http://www.websitetips.com/css/
鈼?The best Cascading Style Sheet discussion email list
鈼?http://www.css-discuss.org/
鈼?Links to thousands of Cascding Style Sheet examples sites
鈻?http://css-discuss.incutio.com/
鈼?Css Filters
鈻?http://www.centricle.com/ref/css/filters鈥?/a>
http://dedicated.ecompro.com/ProductDeta鈥?/a>
use this link
tell me what is the problemHow to re-size a drop down width in HTML?
set the width with style sheets
%26lt;select style=';width:300px;';%26gt;
鈼?The best HTML/XHTML Reference
鈻?http://www.w3schools.com/tags.asp
鈼?The best Cascading Style Sheet Reference
鈻?http://www.w3schools.com/css/css_referen鈥?/a> html
鈼?Links to HTML/HTML related sites
鈻?http://www.websitetips.com/html/
鈼?Links to Cascading Style Sheet related sites
鈻?http://www.websitetips.com/css/
鈼?The best Cascading Style Sheet discussion email list
鈼?http://www.css-discuss.org/
鈼?Links to thousands of Cascding Style Sheet examples sites
鈻?http://css-discuss.incutio.com/
鈼?Css Filters
鈻?http://www.centricle.com/ref/css/filters鈥?/a>
Code for Select and deselect all check boxes in javascript.?
I have to select and deselect a check box column in a datagrid. When i click the header check box all the checkboxes in the column should be checked and vice-versa for uncheck also. But if we uncheck a single check box after checking all checkboxes , the header check box should also be unchecked. Sorry for confusing like this. Because my English is Somewhat bad. Anybody pls send me sample code for this and how to call the javascript function in HTML.Code for Select and deselect all check boxes in javascript.?
Here's part of it. This function checks all the checkboxes for recruits in the list.
function chkAll_Click() {
var checked = document.getElementById ('chkAll').checked;
for (i = 0; i %26lt; document.forms[0]. recruits.length; i++) {
document.forms[0]. recruits[i].checked = checked;
}
}
The javascript function in my case is actually set up as the 'on_click' event in the header template:
%26lt;input type=';checkbox'; id=';chkAll'; name=';chkAll'; onclick=';chkAll_Click();'; /%26gt;
Watch out for extra spaces I put in to make the code fit here.
hope that helps you out
Here's part of it. This function checks all the checkboxes for recruits in the list.
function chkAll_Click() {
var checked = document.getElementById ('chkAll').checked;
for (i = 0; i %26lt; document.forms[0]. recruits.length; i++) {
document.forms[0]. recruits[i].checked = checked;
}
}
The javascript function in my case is actually set up as the 'on_click' event in the header template:
%26lt;input type=';checkbox'; id=';chkAll'; name=';chkAll'; onclick=';chkAll_Click();'; /%26gt;
Watch out for extra spaces I put in to make the code fit here.
hope that helps you out
How to bind a table by reading text file using data grid in asp.net 1.1 using c# ? Thanks.?
As I know, I usually bind a table from the database. But now I wanna bind a table by reading the content from a textfile. It is using datagrid. Can someone help me? Thank u.How to bind a table by reading text file using data grid in asp.net 1.1 using c# ? Thanks.?
You can do it relatively easy if your file is an XML.
In your version of C# it would look something like this:
System.Xml.XmlReader myXMLreader =
new System.Xml.XmlTextReader(
new System.IO.StreamReader(%26lt;filename%26gt;)
);
DataSet myDataSet = new DataSet();
myDataSet.ReadXml(myXMLreader);
myGrid.DataSource = myDataSet.Tables[0];
myGrid.DataBind();love myspace myspace girl
You can do it relatively easy if your file is an XML.
In your version of C# it would look something like this:
System.Xml.XmlReader myXMLreader =
new System.Xml.XmlTextReader(
new System.IO.StreamReader(%26lt;filename%26gt;)
);
DataSet myDataSet = new DataSet();
myDataSet.ReadXml(myXMLreader);
myGrid.DataSource = myDataSet.Tables[0];
myGrid.DataBind();
In C# how to i query from an access database using a Windows Application?
ok I have a Windows app thats hooked up to an access database and i want the user to type in a football players name in a textbox, push a button and have it select the players info from the database (first name, last name, number, etc) right now i can see the whole table with all the info filled in on the datagrid when i run the app. I can get everything else to work except the select statement.In C# how to i query from an access database using a Windows Application?
What happens when you execute the query? Do you get an error, or what?
Edit:
Within that SQL query you should not need to have a semicolon. What is the c# code in which you are calling that query, and what is the error?
What happens when you execute the query? Do you get an error, or what?
Edit:
Within that SQL query you should not need to have a semicolon. What is the c# code in which you are calling that query, and what is the error?
How to page a gridview in vb.net?
I know how to page threw a datagrid i use the folowing code
Protected Sub grid_PageIndexChanged(ByVal sender As System.Object, ByVal e As DataGridPageChangedEventArgs) Handles grid.PageIndexChanged
mygrid.CurrentPageIndex = e.NewPageIndex
mygrid.DataSource = mydataset
mygrid.DataBind()
End Sub
but how do i page a gridview. The event that handles paging does not like
mygrid.mypageindex
how do i change the code for the datagird to work for a dataview?How to page a gridview in vb.net?
check out http://www.pscode.com for great examples.How to page a gridview in vb.net?
The GridView makes paging even easier with its AllowPaging attribute. This attribute can be set either by adding the attribute to the GridView control in HTML mode or by checking the Enable Paging checkbox in the GridView’s smart tag. Enabling paging in the GridView control defaults to a page size of 10records and adds the Pager to the bottom of the grid.
%26lt;asp:GridView ID=”GridView1” Runat=”server” DataSourceID=”SqlDataSource1”
DataKeyNames=”CustomerID” AutoGenerateColumns=”False”
AllowSorting=”True” AllowPaging=”True”%26gt;
Thank You.
Protected Sub grid_PageIndexChanged(ByVal sender As System.Object, ByVal e As DataGridPageChangedEventArgs) Handles grid.PageIndexChanged
mygrid.CurrentPageIndex = e.NewPageIndex
mygrid.DataSource = mydataset
mygrid.DataBind()
End Sub
but how do i page a gridview. The event that handles paging does not like
mygrid.mypageindex
how do i change the code for the datagird to work for a dataview?How to page a gridview in vb.net?
check out http://www.pscode.com for great examples.How to page a gridview in vb.net?
The GridView makes paging even easier with its AllowPaging attribute. This attribute can be set either by adding the attribute to the GridView control in HTML mode or by checking the Enable Paging checkbox in the GridView’s smart tag. Enabling paging in the GridView control defaults to a page size of 10records and adds the Pager to the bottom of the grid.
%26lt;asp:GridView ID=”GridView1” Runat=”server” DataSourceID=”SqlDataSource1”
DataKeyNames=”CustomerID” AutoGenerateColumns=”False”
AllowSorting=”True” AllowPaging=”True”%26gt;
Thank You.
How to place or pass the selected value from a datgrid to the select statement?
For instance...
in datagrid we are having check box.. bound to it....
i am goin to display the column name in it...
user can select or check as many columns he want
suppose if user selects three column means ... these three column should get placed in the select query..
for instance...
if user select order id,order name from order table means..
what should i get is
str=';select orderid,ordername from order';
the column name must be append to str only during run time...
these process are goin to take place in run time... hence table name ,column name will change based on the selection from the user
help me out to overcome the problem...
any tutorial link or code 'll help me lot...
urgent .. make it fast..
i'll be thank ful for you..
thanks in advance........How to place or pass the selected value from a datgrid to the select statement?
I suppose as follows :
Datagrid1
Column1 Column2 Column3 and so on
now user selects Column1 and column3
first store column checked value as follows:
Dim varC1 as String
if not isnull(Me.datagrid1.Column(0) or _
Me.datagrid1.Column(0) %26lt;%26gt; ';'; Then
varC1=Trim(varC1) %26amp; Me.datagrid1.Column(0).Value %26amp; ';,';
Endif
if not isnull(Me.datagrid1.Column(1) or _
Me.datagrid1.Column(1) %26lt;%26gt; ';'; Then
varC1=Trim(varC1) %26amp; Me.datagrid1.Column(1).Value %26amp; ';,';
Endif
if not isnull(Me.datagrid1.Column(2) or _
Me.datagrid1.Column(2) %26lt;%26gt; ';'; Then
varC1=Trim(varC1) %26amp; e.datagrid1.Column(2).Value
Endif
str=';SELECT '; %26amp; varC1 From urTableName
before executing SQL place Stop beneath str and check if it shows correct value.
in datagrid we are having check box.. bound to it....
i am goin to display the column name in it...
user can select or check as many columns he want
suppose if user selects three column means ... these three column should get placed in the select query..
for instance...
if user select order id,order name from order table means..
what should i get is
str=';select orderid,ordername from order';
the column name must be append to str only during run time...
these process are goin to take place in run time... hence table name ,column name will change based on the selection from the user
help me out to overcome the problem...
any tutorial link or code 'll help me lot...
urgent .. make it fast..
i'll be thank ful for you..
thanks in advance........How to place or pass the selected value from a datgrid to the select statement?
I suppose as follows :
Datagrid1
Column1 Column2 Column3 and so on
now user selects Column1 and column3
first store column checked value as follows:
Dim varC1 as String
if not isnull(Me.datagrid1.Column(0) or _
Me.datagrid1.Column(0) %26lt;%26gt; ';'; Then
varC1=Trim(varC1) %26amp; Me.datagrid1.Column(0).Value %26amp; ';,';
Endif
if not isnull(Me.datagrid1.Column(1) or _
Me.datagrid1.Column(1) %26lt;%26gt; ';'; Then
varC1=Trim(varC1) %26amp; Me.datagrid1.Column(1).Value %26amp; ';,';
Endif
if not isnull(Me.datagrid1.Column(2) or _
Me.datagrid1.Column(2) %26lt;%26gt; ';'; Then
varC1=Trim(varC1) %26amp; e.datagrid1.Column(2).Value
Endif
str=';SELECT '; %26amp; varC1 From urTableName
before executing SQL place Stop beneath str and check if it shows correct value.
In visual basic 6, how can you search a record containing special characters?
i have a textbox and a datagrid control connected to ms access database table using the ADODC control. i want to search a record (i.e. by title) which ill type in the textbox. how can i search if the title has special characters like apostrophe (')? pls tell me the code/s . thanksIn visual basic 6, how can you search a record containing special characters?
this routine treats anything that is not an alpha-numeric character as ';special,'; including spaces, tabs, carriage returns, line feeds, etc. modify the code to explicitly reference anything you consider ';sepcial.';
Option Explicit
Dim msTitle As String
Private Sub Command1_Click()
Dim lsChar As String
Dim liChar As Integer
Dim li As Integer
Dim mBlnSpecial As Boolean
msTitle = Text1.Text
For li = 0 To Len(msTitle) - 1
lsChar = Mid(msTitle, li + 1, 1)
liChar = Asc(lsChar)
Select Case liChar
'--numbers
Case 48 To 57
'--lower case
Case 65 To 90
'--upper case
Case 97 To 122
Case Else
mBlnSpecial = True
Debug.Print (Asc(lsChar))
End Select
Next li
If mBlnSpecial = True Then
li = MsgBox(';There is at least one sepcial character.';, vbOKOnly, ';TEST';)
End If
End SubIn visual basic 6, how can you search a record containing special characters?
it's long cos i didn't clean up for extra returns. hadn't considered instr() at first - prolly wrote this when i was sleepy. glad it helped. i really don't understand what you're looking for - how is ';searching a record with apostrophe'; different from ';searching the occurrence of apostrophe?';
You can ';escape'; the characters by putting a ' (a apostrophy) before like ('')
this routine treats anything that is not an alpha-numeric character as ';special,'; including spaces, tabs, carriage returns, line feeds, etc. modify the code to explicitly reference anything you consider ';sepcial.';
Option Explicit
Dim msTitle As String
Private Sub Command1_Click()
Dim lsChar As String
Dim liChar As Integer
Dim li As Integer
Dim mBlnSpecial As Boolean
msTitle = Text1.Text
For li = 0 To Len(msTitle) - 1
lsChar = Mid(msTitle, li + 1, 1)
liChar = Asc(lsChar)
Select Case liChar
'--numbers
Case 48 To 57
'--lower case
Case 65 To 90
'--upper case
Case 97 To 122
Case Else
mBlnSpecial = True
Debug.Print (Asc(lsChar))
End Select
Next li
If mBlnSpecial = True Then
li = MsgBox(';There is at least one sepcial character.';, vbOKOnly, ';TEST';)
End If
End SubIn visual basic 6, how can you search a record containing special characters?
it's long cos i didn't clean up for extra returns. hadn't considered instr() at first - prolly wrote this when i was sleepy. glad it helped. i really don't understand what you're looking for - how is ';searching a record with apostrophe'; different from ';searching the occurrence of apostrophe?';
Report Abuse
You can ';escape'; the characters by putting a ' (a apostrophy) before like ('')
Code for Select and deselect all check boxes in javascript.?
I have to select and deselect a check box column in a datagrid. When i click the header check box all the checkboxes in the column should be checked and vice-versa for uncheck also. But if we uncheck a single check box after checking all checkboxes , the header check box should also be unchecked. Sorry for confusing like this. Because my English is Somewhat bad. Anybody pls send me sample code for this and how to call the javascript function in HTML.Code for Select and deselect all check boxes in javascript.?
you can try to write a javascript function like this:(only a sketch)
Supose that your form name is my form
function checkall(r) {
for (i = 1; i %26lt; myform.elements.length; i++) {
if (document.myform.elements[i]) {
if(document.myform.elements[i].type %26amp;%26amp; document.files.elements[i].type!='checkb鈥?continue;
document.myform.elements[i].checked = 1;
}
}
}
if you want to download a ready-made script for doing this you can go there::)
http://www.shawnolson.net/a/639/select-a鈥?/a>
you can try to write a javascript function like this:(only a sketch)
Supose that your form name is my form
function checkall(r) {
for (i = 1; i %26lt; myform.elements.length; i++) {
if (document.myform.elements[i]) {
if(document.myform.elements[i].type %26amp;%26amp; document.files.elements[i].type!='checkb鈥?continue;
document.myform.elements[i].checked = 1;
}
}
}
if you want to download a ready-made script for doing this you can go there::)
http://www.shawnolson.net/a/639/select-a鈥?/a>
How to dynamically generate a dataset?
I have 4 columns in a database and i want to generate a dataset dynamically with fifth column which is an ouput based on calculations done on the values of the rest of the columns. I want to generate a datagrid based on this dataset.How to dynamically generate a dataset?
Let a, b , c ,d be the database fields then you can write a db query like this
select a,b,c,d,((a+b+c)/d) from tablename
You can use any arithmetic operations like the above along with the Query and fill the data set using this sort of queryHow to dynamically generate a dataset?
you need to run a query - these performs actions on the data - running the query will generate the data for the extra column -love myspace myspace girl
Let a, b , c ,d be the database fields then you can write a db query like this
select a,b,c,d,((a+b+c)/d) from tablename
You can use any arithmetic operations like the above along with the Query and fill the data set using this sort of queryHow to dynamically generate a dataset?
you need to run a query - these performs actions on the data - running the query will generate the data for the extra column -
How to get the table connected in my webform in ASP.NET?
i'm not using datagrid.. i created 1 table wid follwg steps:
IN server Control i added 1 table
in my webform i took one connection object.
now i want that terxtbox entries in my form should be inserted in that table.. what should i do then?How to get the table connected in my webform in ASP.NET?
This is just a sample code. you do not need to understand everything but you see the general idea. You create the connection object, bind the parameters with your textbox entries and then open the connection and execute.
Dim conn As SqlConnection = New SqlConnection(strSqlConnection)
Dim strInsertSql As String
strInsertSql = ';insert into pharmex_Institutions '; _
%26amp; ';(InstitutionName, Address, City, Area, Phone, PostCode, Devices) '; _
%26amp; ';values '; _
%26amp; ';(@InstitutionName, @Address, @City, @Area, @Phone, @PostCode, @Devices)';
Dim cmdInsertSql As SqlCommand = New SqlCommand(strInsertSql, conn)
' catch all checkboxlist selections
Dim deviceid As ListItem
Dim strDevicesList As String = ';';
For Each deviceid In lstDevices.Items
If deviceid.Selected Then
strDevicesList = strDevicesList %26amp; ';,'; %26amp; deviceid.Value
End If
Next
cmdInsertSql.Parameters.AddWithValue(';@D鈥?strDevicesList)
cmdInsertSql.Parameters.AddWithValue(';@I鈥?txtInstitutionName.Text)
cmdInsertSql.Parameters.AddWithValue(';@A鈥?txtAddress.Text)
cmdInsertSql.Parameters.AddWithValue(';@C鈥?txtCity.Text)
cmdInsertSql.Parameters.AddWithValue(';@A鈥?txtArea.Text)
cmdInsertSql.Parameters.AddWithValue(';@P鈥?txtPhone.Text)
cmdInsertSql.Parameters.AddWithValue(';@P鈥?txtPostCode.Text)
conn.Open()
cmdInsertSql.ExecuteNonQuery()
conn.Close()
IN server Control i added 1 table
in my webform i took one connection object.
now i want that terxtbox entries in my form should be inserted in that table.. what should i do then?How to get the table connected in my webform in ASP.NET?
This is just a sample code. you do not need to understand everything but you see the general idea. You create the connection object, bind the parameters with your textbox entries and then open the connection and execute.
Dim conn As SqlConnection = New SqlConnection(strSqlConnection)
Dim strInsertSql As String
strInsertSql = ';insert into pharmex_Institutions '; _
%26amp; ';(InstitutionName, Address, City, Area, Phone, PostCode, Devices) '; _
%26amp; ';values '; _
%26amp; ';(@InstitutionName, @Address, @City, @Area, @Phone, @PostCode, @Devices)';
Dim cmdInsertSql As SqlCommand = New SqlCommand(strInsertSql, conn)
' catch all checkboxlist selections
Dim deviceid As ListItem
Dim strDevicesList As String = ';';
For Each deviceid In lstDevices.Items
If deviceid.Selected Then
strDevicesList = strDevicesList %26amp; ';,'; %26amp; deviceid.Value
End If
Next
cmdInsertSql.Parameters.AddWithValue(';@D鈥?strDevicesList)
cmdInsertSql.Parameters.AddWithValue(';@I鈥?txtInstitutionName.Text)
cmdInsertSql.Parameters.AddWithValue(';@A鈥?txtAddress.Text)
cmdInsertSql.Parameters.AddWithValue(';@C鈥?txtCity.Text)
cmdInsertSql.Parameters.AddWithValue(';@A鈥?txtArea.Text)
cmdInsertSql.Parameters.AddWithValue(';@P鈥?txtPhone.Text)
cmdInsertSql.Parameters.AddWithValue(';@P鈥?txtPostCode.Text)
conn.Open()
cmdInsertSql.ExecuteNonQuery()
conn.Close()
How do you write to calculate the number transactions , total gross pay, total withholding, and?
Total net pay when selecting current employee in a ListBox from Data Table which has a DataGrid and labels to display the results?How do you write to calculate the number transactions , total gross pay, total withholding, and?
In what ???????????????? VB, VC++, JavaScript ????????? And anyway its a tall order.How do you write to calculate the number transactions , total gross pay, total withholding, and?
I would love to help you but I haven't a clue what program you are working with.
microsoft office exel
In what ???????????????? VB, VC++, JavaScript ????????? And anyway its a tall order.How do you write to calculate the number transactions , total gross pay, total withholding, and?
I would love to help you but I haven't a clue what program you are working with.
microsoft office exel
How to make footer of grid view as hyperlink in sort.?
I set allowsorting of grid view to true. It works fine for header but for footer there no hyper link. It used to work in datagrid but don't know why not working for grid view.How to make footer of grid view as hyperlink in sort.?
Try this
http://msdn2.microsoft.com/en-us/library鈥?/a>
Try this
http://msdn2.microsoft.com/en-us/library鈥?/a>
How to create a table in visual basic 2005?
Is there a way to make a table without binding to the outside source like SQL, MS Access..?
Just in Visual Basic Program itself, possibly using a txt file.
if there's a way to add and remove a row in datagrid,
I can do the other things...
so..
is there a way??How to create a table in visual basic 2005?
You can make a disconnected dataset - use ADO. You can connect a datagrid to the dataset. You can add and delete rows with SQL.
But remember, it goes away when the program is closed. And you don't want to save an ADO dataset to a .txt file - even if it's a text file, call it something that won't open on anyone's computer. Opening it in Notepad, then saving it, will destroy your dataset.How to create a table in visual basic 2005?
simplest, just 'insert table'.
Just in Visual Basic Program itself, possibly using a txt file.
if there's a way to add and remove a row in datagrid,
I can do the other things...
so..
is there a way??How to create a table in visual basic 2005?
You can make a disconnected dataset - use ADO. You can connect a datagrid to the dataset. You can add and delete rows with SQL.
But remember, it goes away when the program is closed. And you don't want to save an ADO dataset to a .txt file - even if it's a text file, call it something that won't open on anyone's computer. Opening it in Notepad, then saving it, will destroy your dataset.How to create a table in visual basic 2005?
simplest, just 'insert table'.
DatagridView how to show the fonts icon with VB05?
Hi
I create a datagridview with VB05.
I want's know that......
when i load the form how can i show the fonts file icon in my datagridview??
I mean the true type , open type, type one all that icon.
How to view in datagrid view ? Can any body help me?DatagridView how to show the fonts icon with VB05?
hello, hello.
A DataGridView has a column that can be set as an Image column. You can then load the desired icon into this column. If you want the icon and text to be in the same cell then it will get messy from there; I beleive you will have to capture the paint event and customize it. There are some sites out there that can help you.DatagridView how to show the fonts icon with VB05?
you can do so by showing the fonts file icon in your datagridview when you load the form
I create a datagridview with VB05.
I want's know that......
when i load the form how can i show the fonts file icon in my datagridview??
I mean the true type , open type, type one all that icon.
How to view in datagrid view ? Can any body help me?DatagridView how to show the fonts icon with VB05?
hello, hello.
A DataGridView has a column that can be set as an Image column. You can then load the desired icon into this column. If you want the icon and text to be in the same cell then it will get messy from there; I beleive you will have to capture the paint event and customize it. There are some sites out there that can help you.DatagridView how to show the fonts icon with VB05?
you can do so by showing the fonts file icon in your datagridview when you load the form
Where can I find a good .NET database app tutorial online?
I am a beginner in .NET. I'm trying to create a simple POS apps, but I don't know how to do it using C#. I'm not familiar w/ .NET's objects. The main topic i'm looking for is the DataGrid objects. How to save the data which is edited in through the datagrid? How to create the app server for this kind of app? I'm planning to create a multiuser apps.Where can I find a good .NET database app tutorial online?
You will need a Relational Database Management System like Microsoft SQL Server 2005.
Thank You.Where can I find a good .NET database app tutorial online?
oh man, if you're going to use a datagrid for Adding Editing and Deleting, definitely go for .net 2.0. The Datagrid sux at that on 1.0. of course you could always consider a 3rd party datagrid.
check out www.ebookshare.net
Cheers
You are the only opeson on this whole gd place with a sence of humor
This might help u:
http://www.tutorialized.com/tutorials/AS鈥?/a>
I hope so.love myspace myspace girl
You will need a Relational Database Management System like Microsoft SQL Server 2005.
Thank You.Where can I find a good .NET database app tutorial online?
oh man, if you're going to use a datagrid for Adding Editing and Deleting, definitely go for .net 2.0. The Datagrid sux at that on 1.0. of course you could always consider a 3rd party datagrid.
check out www.ebookshare.net
Cheers
You are the only opeson on this whole gd place with a sence of humor
This might help u:
http://www.tutorialized.com/tutorials/AS鈥?/a>
I hope so.
How can i do paging in HTML table?
i m creating asp.net web page.
i draw a table with HTML tags,
now my problem is i want to do paging on that
table,how can i?
how can do paging in my asp.net page,i used html tags to create a
table(not datagrid)
plz help me.How can i do paging in HTML table?
paging can be done with the help of ASP.. there are no paging tags in HTML.
i draw a table with HTML tags,
now my problem is i want to do paging on that
table,how can i?
how can do paging in my asp.net page,i used html tags to create a
table(not datagrid)
plz help me.How can i do paging in HTML table?
paging can be done with the help of ASP.. there are no paging tags in HTML.
How to edit values in a database by using gridview?
hi...i m using datagrid and sqldatasource to display data in the gridview..i m trying to edit data in database by using datagrid...i also specified the update and delete command in sqldatasource but its still not workin plzzz.....of anyone has been in sucessfull in doing this then plzz reply in detailHow to edit values in a database by using gridview?
First of all, is your DataGridView bounded to the datasource. If not, you should bind it.(I assume you know how). But if it is still not working, there is a simple way I always use:
I think you have a dataset already(If not, create it). Show the dataset in Visual Studio.(right click%26gt;edit with designer) It shows the tables and relations. Right click on the table you want to add SQL command to it and select add%26gt;query. Then instead of SQL command, select ';create stored procedure';.
Now you can save any query you want as a stored procedure and give it a name. Then, whenever you want to use that query, just call the stored procedure and give its arguments. Voila! it will work.
Good luck.
If you still have problems, feel free to contact me to give you more details.
First of all, is your DataGridView bounded to the datasource. If not, you should bind it.(I assume you know how). But if it is still not working, there is a simple way I always use:
I think you have a dataset already(If not, create it). Show the dataset in Visual Studio.(right click%26gt;edit with designer) It shows the tables and relations. Right click on the table you want to add SQL command to it and select add%26gt;query. Then instead of SQL command, select ';create stored procedure';.
Now you can save any query you want as a stored procedure and give it a name. Then, whenever you want to use that query, just call the stored procedure and give its arguments. Voila! it will work.
Good luck.
If you still have problems, feel free to contact me to give you more details.
How to putr validation controls in a data grid?
I have a data grid in which i am editing the value in datagrid.
how to put validation control.
I am using ASP.NETHow to putr validation controls in a data grid?
there is no specific data validation for the same. when the cell is clicked you will have to use the text box and in it u will have to implement the validation control for the same. or else while entering the value u will know which columns have to be numeric or alphabetic. depending on it you will call the specific function for the same.
how to put validation control.
I am using ASP.NETHow to putr validation controls in a data grid?
there is no specific data validation for the same. when the cell is clicked you will have to use the text box and in it u will have to implement the validation control for the same. or else while entering the value u will know which columns have to be numeric or alphabetic. depending on it you will call the specific function for the same.
How to create a grid using jsp ?
I am developing an application using jsp which retreives data from oracle database and show in a table all records at a time.
but i am interested to show the contents in a datagrid 10 per page.ie,10 recors per page how to do it.is there any IDE like .net in java which allow us to create grid.
thanks in advance.
How to create a grid using jsp ?
well Java IDEs you can use is NetBeans or Eclipse. they are both free and are the best 2 you can chose fromHow to create a grid using jsp ?
I don't think Java has the support for datagrids. However, there are a number of third party vendors whose packages support datagrids or you can implement one your own. Please check the documentation again. I could be wrong.
but i am interested to show the contents in a datagrid 10 per page.ie,10 recors per page how to do it.is there any IDE like .net in java which allow us to create grid.
thanks in advance.
How to create a grid using jsp ?
well Java IDEs you can use is NetBeans or Eclipse. they are both free and are the best 2 you can chose fromHow to create a grid using jsp ?
I don't think Java has the support for datagrids. However, there are a number of third party vendors whose packages support datagrids or you can implement one your own. Please check the documentation again. I could be wrong.
How to add a record in visual basic?
i m designing an application using VB and the back-end is MySQL ....i hve never learnt vb so plz provide me with d source code to add,delete,update and to extract the data from database in datagrid and how to connect VB and MySQL.
Advance thanks.How to add a record in visual basic?
You're going to have to learn ADO to handle the database, and SQL to talk to it. It's not something someone can give you a few lines of code for - you're just going to have to learn it - and it's not something you can learn in a few days, either. (You can fake some if it in VB.net, but only some of it.)
Advance thanks.How to add a record in visual basic?
You're going to have to learn ADO to handle the database, and SQL to talk to it. It's not something someone can give you a few lines of code for - you're just going to have to learn it - and it's not something you can learn in a few days, either. (You can fake some if it in VB.net, but only some of it.)
How can i filter records using control arrays?
I want to filter my records on msaccess using control arrays of command buttons on vb6.
There are 26 buttons labeled A-Z.
How should i type my sql?
I have mine, but this one doesn't work, hope you guyz could find what's my mistake.
Tnxs...
ADOSTUDENTS.RecordSource = ';SELECT * FROM TBLSTUDENTS WHERE STUDNAME LIKE 'CMDFILTER(Index).Caption%'; ';
ADOSTUDENTS.Refresh
Everytime I clicked on the cmdfilter, I just got a blank record. I also had a datagrid to view all records, and whenever I tried to exit the program after i click the cmdfilter, some error appear.
Microsoft Datagrid control
';Empty row cannot be inserted. Row must have at least one column value set.';
what does it mean?How can i filter records using control arrays?
Try this
1. LIKE ''; %26amp; CMDFILTER(Index).Caption %26amp; ';%'';
OR
2. LIKE ''; %26amp; CMDFILTER(Index).Caption %26amp; ';*'';love myspace myspace girl
There are 26 buttons labeled A-Z.
How should i type my sql?
I have mine, but this one doesn't work, hope you guyz could find what's my mistake.
Tnxs...
ADOSTUDENTS.RecordSource = ';SELECT * FROM TBLSTUDENTS WHERE STUDNAME LIKE 'CMDFILTER(Index).Caption%'; ';
ADOSTUDENTS.Refresh
Everytime I clicked on the cmdfilter, I just got a blank record. I also had a datagrid to view all records, and whenever I tried to exit the program after i click the cmdfilter, some error appear.
Microsoft Datagrid control
';Empty row cannot be inserted. Row must have at least one column value set.';
what does it mean?How can i filter records using control arrays?
Try this
1. LIKE ''; %26amp; CMDFILTER(Index).Caption %26amp; ';%'';
OR
2. LIKE ''; %26amp; CMDFILTER(Index).Caption %26amp; ';*'';
C# .net experts I need your help with datagrid?
I am not sure how to populate a table with data after clicking entering some text and click a search button.. i know how to do this in .net but eve after looking at examples I'm not sure how to do this in C#
this is what I have in .net but i need to find a way to do it in C# since the whole project will be in C#.
(i'm trying to learn C# )
is there another way to use ';Dim'; ?
protected Sub seachMarks_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles searchMarks.Click
Dim systemmgr As New SchoolSystem.Controller
Dim myDS As DataSet
Try
myDS = systemmgr.GetMarkSubmissionList(courseid鈥?semester.Text)
If myDS.Tables(0).Rows.Count = 0 Then
FormMessage.Text = ';No students in this course/semester.';
Else
myDS.Tables(0).DefaultView.Sort = ';Name ASC';
MarkList.DataSource = myDS.Tables(0)
MarkList.DataBind()
End If
Catch ex As Exception
FormMessage.Text = ex.Message
End Try
End SubC# .net experts I need your help with datagrid?
use this site http://www.developerfusion.com/tools/con鈥?/a>
to convert vb.net code to C#.Net
this is what I have in .net but i need to find a way to do it in C# since the whole project will be in C#.
(i'm trying to learn C# )
is there another way to use ';Dim'; ?
protected Sub seachMarks_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles searchMarks.Click
Dim systemmgr As New SchoolSystem.Controller
Dim myDS As DataSet
Try
myDS = systemmgr.GetMarkSubmissionList(courseid鈥?semester.Text)
If myDS.Tables(0).Rows.Count = 0 Then
FormMessage.Text = ';No students in this course/semester.';
Else
myDS.Tables(0).DefaultView.Sort = ';Name ASC';
MarkList.DataSource = myDS.Tables(0)
MarkList.DataBind()
End If
Catch ex As Exception
FormMessage.Text = ex.Message
End Try
End SubC# .net experts I need your help with datagrid?
use this site http://www.developerfusion.com/tools/con鈥?/a>
to convert vb.net code to C#.Net
VB6: How can I fill a DataGrid from a rdoResultset?
I have this code:
Dim cadena_conexion
cadena_conexion = ';DRIVER={MySQL ODBC 5.1 Driver}; SERVER='; %26amp; Form1.servidor.Text %26amp; ';; DATABASE='; %26amp; Form1.base_de_datos.Text %26amp; ';;PWD='; %26amp; Form1.password.Text %26amp; ';; UID='; %26amp; Form1.usuario.Text %26amp; ';;OPTION=3';
Set db = New rdoConnection
db.Connect = cadena_conexion
db.CursorDriver = rdUseServer
db.EstablishConnection
Dim tabla As String
Dim consulta As New rdoQuery
Dim resultados As rdoResultset
Set consulta.ActiveConnection = db
consulta.SQL = ';SELECT * from planta;';
consulta.Execute
Set resultados = consulta.OpenResultset
How can I put the results from resultados to my datagrid1 ?VB6: How can I fill a DataGrid from a rdoResultset?
Been a while since I did VB, but IIRC, you edit the properties of the datagrid to make the data source your resultset object.
Dim cadena_conexion
cadena_conexion = ';DRIVER={MySQL ODBC 5.1 Driver}; SERVER='; %26amp; Form1.servidor.Text %26amp; ';; DATABASE='; %26amp; Form1.base_de_datos.Text %26amp; ';;PWD='; %26amp; Form1.password.Text %26amp; ';; UID='; %26amp; Form1.usuario.Text %26amp; ';;OPTION=3';
Set db = New rdoConnection
db.Connect = cadena_conexion
db.CursorDriver = rdUseServer
db.EstablishConnection
Dim tabla As String
Dim consulta As New rdoQuery
Dim resultados As rdoResultset
Set consulta.ActiveConnection = db
consulta.SQL = ';SELECT * from planta;';
consulta.Execute
Set resultados = consulta.OpenResultset
How can I put the results from resultados to my datagrid1 ?VB6: How can I fill a DataGrid from a rdoResultset?
Been a while since I did VB, but IIRC, you edit the properties of the datagrid to make the data source your resultset object.
How to sort data in DataGrid on perticular column?
datagrid where? , in java, .net..
if ur object don't have this as a built-in feature, then u can sort the data by ur sql statement by using (order by) before filling ur grid with data
if ur object don't have this as a built-in feature, then u can sort the data by ur sql statement by using (order by) before filling ur grid with data
I have 10 datagrid views in a form i want to write a loop for it in c#.net.How do i wirte the code.?
I have written in this way
for(i=0;i%26lt;10;i++)
{
(DataGridView+i).DataSource=Da...
(DataGridView+i).Datamember=Da...
}
But for this iam getting a error .
Pls tell me how to write the code for the following.I have 10 datagrid views in a form i want to write a loop for it in c#.net.How do i wirte the code.?
Sounds to me like you want a list of DataGridViews, so first you have to create the list.
Note you will need to declare System.Collections.Generic to have access to List.
using System.Collections.Generic;
dataGridViews = new List%26lt;DataGridView%26gt;();
Next you need to populate the list
dataGridVIews.Add( new DataGridView );
then to loop through it, simply do this:
foreach( DataGridView mGrid in dataGridViews )
{
mGrid.DataSource=blah;
mGrid.DataMember=blah;
}
This will loop through all of them in the list. I'm pretty sure you can also use your method and just use dataGridViews[i].DataSource=blah;
Hopefully that accomplishes what you needed.I have 10 datagrid views in a form i want to write a loop for it in c#.net.How do i wirte the code.?
for(i=0;i%26lt;10;i++)
{
(DataGridView+i+).DataSource=Da...
(DataGridView+i+).Datamember=Da...
}
The way it was before does not get that i is variable.
Hope this will work.
for(i=0;i%26lt;10;i++)
{
(DataGridView+i).DataSource=Da...
(DataGridView+i).Datamember=Da...
}
But for this iam getting a error .
Pls tell me how to write the code for the following.I have 10 datagrid views in a form i want to write a loop for it in c#.net.How do i wirte the code.?
Sounds to me like you want a list of DataGridViews, so first you have to create the list.
Note you will need to declare System.Collections.Generic to have access to List.
using System.Collections.Generic;
dataGridViews = new List%26lt;DataGridView%26gt;();
Next you need to populate the list
dataGridVIews.Add( new DataGridView );
then to loop through it, simply do this:
foreach( DataGridView mGrid in dataGridViews )
{
mGrid.DataSource=blah;
mGrid.DataMember=blah;
}
This will loop through all of them in the list. I'm pretty sure you can also use your method and just use dataGridViews[i].DataSource=blah;
Hopefully that accomplishes what you needed.I have 10 datagrid views in a form i want to write a loop for it in c#.net.How do i wirte the code.?
for(i=0;i%26lt;10;i++)
{
(DataGridView+i+).DataSource=Da...
(DataGridView+i+).Datamember=Da...
}
The way it was before does not get that i is variable.
Hope this will work.
Code for Updating Datagrid on c#?
hi,
i am new to .net. any one please give me code for updating a data grid using c#. or plz tell me how to get the updated cell value?
thanks.Code for Updating Datagrid on c#?
Well it depends on a couple of things. I will assume C# 2.0 and that you are using the DataGridView on a Windows app.
It also depends on how you are selecting the row which contains the data to update. Remember that a DataGridRow is an object, so you need to find that row first.
But here is how you would change the value in the First column of the First row:
myGrid.Rows[0].Cells[0].Value = ';Some Value';;
If you already have the row in hand, perhaps by using a for loop, you could just do:
myRow.Cells[0].Value = ';Some Value';;
Again, it all depends on the context.
i am new to .net. any one please give me code for updating a data grid using c#. or plz tell me how to get the updated cell value?
thanks.Code for Updating Datagrid on c#?
Well it depends on a couple of things. I will assume C# 2.0 and that you are using the DataGridView on a Windows app.
It also depends on how you are selecting the row which contains the data to update. Remember that a DataGridRow is an object, so you need to find that row first.
But here is how you would change the value in the First column of the First row:
myGrid.Rows[0].Cells[0].Value = ';Some Value';;
If you already have the row in hand, perhaps by using a for loop, you could just do:
myRow.Cells[0].Value = ';Some Value';;
Again, it all depends on the context.
.NET DataGrid Variables?
I am retrieving data from a table and posting to a data grid. I want to set a variable so that if a value = a specific value, I want to change it to a custom value. Here is how I'm loading my grid...
dAdapt.Fill(dSet, ';tb_employees';);
GridView1.DataSource = dSet;
GridView1.DataMember = ';tb_employees';;
GridView1.DataBind();.NET DataGrid Variables?
Not enough code. How are you filling the dataset? One easy way of doing it is using a template column in the data grid and then use a function to get the value you want.
%26lt;asp:GridView ID=';gvCountryTaxes'; runat=';server'; AllowSorting=';True'; AutoGenerateColumns=';False'; DataSourceID=';sdsCountryTaxes'; DataKeyNames=';CountryCode';%26gt;
%26lt;Columns%26gt;
%26lt;asp:BoundField DataField=';EmployeeID'; HeaderText=';ID'; SortExpression=';EmployeeID'; ReadOnly=';True'; /%26gt;
%26lt;asp:TemplateField HeaderText=';Regions';%26gt;
%26lt;ItemTemplate%26gt;
%26lt;%# GetMyValue(Container.DataItem(';EmployeeN鈥?br>
%26lt;/ItemTemplate%26gt;
%26lt;/asp:TemplateField%26gt;
%26lt;/Columns%26gt;
%26lt;/asp:GridView%26gt;
Then in the code behind
Function GetMyValue(ByVal sName As String) As String
If sName=String.Empty Then
Return ';N/a';
Else
Return sName
End If
End Function
you may also want to search the forums on http://www.asp.net.NET DataGrid Variables?
You can use following code segment
String name;
name=dSet.rows[0].coloum[';Name';];
now you can use it to check for specific value like
if(name==';John';)
{
}love myspace myspace girl
dAdapt.Fill(dSet, ';tb_employees';);
GridView1.DataSource = dSet;
GridView1.DataMember = ';tb_employees';;
GridView1.DataBind();.NET DataGrid Variables?
Not enough code. How are you filling the dataset? One easy way of doing it is using a template column in the data grid and then use a function to get the value you want.
%26lt;asp:GridView ID=';gvCountryTaxes'; runat=';server'; AllowSorting=';True'; AutoGenerateColumns=';False'; DataSourceID=';sdsCountryTaxes'; DataKeyNames=';CountryCode';%26gt;
%26lt;Columns%26gt;
%26lt;asp:BoundField DataField=';EmployeeID'; HeaderText=';ID'; SortExpression=';EmployeeID'; ReadOnly=';True'; /%26gt;
%26lt;asp:TemplateField HeaderText=';Regions';%26gt;
%26lt;ItemTemplate%26gt;
%26lt;%# GetMyValue(Container.DataItem(';EmployeeN鈥?br>
%26lt;/ItemTemplate%26gt;
%26lt;/asp:TemplateField%26gt;
%26lt;/Columns%26gt;
%26lt;/asp:GridView%26gt;
Then in the code behind
Function GetMyValue(ByVal sName As String) As String
If sName=String.Empty Then
Return ';N/a';
Else
Return sName
End If
End Function
you may also want to search the forums on http://www.asp.net.NET DataGrid Variables?
You can use following code segment
String name;
name=dSet.rows[0].coloum[';Name';];
now you can use it to check for specific value like
if(name==';John';)
{
}
Some doubts in DataGrid Control to Sort the Values ASP.NET?
Hai friends, I need to sort the datagrid control in asp.net page. when i click the column header it should be sorted and display. but one condition has to be applied. when i click the sort expression it should not go and sort from the database itself. this is must . how to do pa? anybody could help me to do?Some doubts in DataGrid Control to Sort the Values ASP.NET?
The following articles will certainly help you :
Optimized ASP.NET DataGrid Sorting %26gt;
http://www.codeproject.com/aspnet/Optimi鈥?/a>
Working with Data Grid:
http://samples.gotdotnet.com/quickstart/鈥?/a>Some doubts in DataGrid Control to Sort the Values ASP.NET?
thru oracle as back end u can made
select * from %26lt;tablename%26gt; orderby %26lt;as u wish%26gt;
The following articles will certainly help you :
Optimized ASP.NET DataGrid Sorting %26gt;
http://www.codeproject.com/aspnet/Optimi鈥?/a>
Working with Data Grid:
http://samples.gotdotnet.com/quickstart/鈥?/a>Some doubts in DataGrid Control to Sort the Values ASP.NET?
thru oracle as back end u can made
select * from %26lt;tablename%26gt; orderby %26lt;as u wish%26gt;
How to edit a in datagrid using c#?
MS.Net ,Dot net 2005How to edit a in datagrid using c#?
here is a link to the datagrid class definition on MSDN.
http://msdn.microsoft.com/library/defaul鈥?/a>How to edit a in datagrid using c#?
try
http://www.borland.com/us/products/cshar鈥?/a>
here is a link to the datagrid class definition on MSDN.
http://msdn.microsoft.com/library/defaul鈥?/a>How to edit a in datagrid using c#?
try
http://www.borland.com/us/products/cshar鈥?/a>
In visual basic 6, how can u bind a datagrid control to the ms access database usng manual coding adodb?
Private Sub Form_Activate()
Set GRID.DataSource = REC
End Sub
that is my code but it wont work. the error is : the rowset is not bookmarkable. pls send me the correct code. thanks a lot.In visual basic 6, how can u bind a datagrid control to the ms access database usng manual coding adodb?
This is an unbound method. It works for me. Hope this helps you too.
Dim Mycon As New ADODB.Connection
Dim M1 As New ADODB.Recordset
Dim S1 As String
S1 = ';Provider=Microsoft.Jet.OLEDB.4.0;'; %26amp; _
';Data Source='; %26amp; _
App.Path %26amp; ';A.mdb';
Mycon.Open S1
M1.Open ';select * from B';, Mycon, adOpenDynamic, adLockOptimistic
Dim c As Integer
Dim r As Integer
Dim col_wid() As Single
Dim field_wid As Single
' Use one fixed row and no fixed columns.
MSFlexGrid1.Rows = 2
MSFlexGrid1.FixedRows = 1
MSFlexGrid1.FixedCols = 0
' Display column headers.
MSFlexGrid1.Rows = 1
MSFlexGrid1.Cols = M1.Fields.Count
ReDim col_wid(0 To M1.Fields.Count - 1)
For c = 0 To M1.Fields.Count - 1
MSFlexGrid1.TextMatrix(0, c) = M1.Fields(c).Name
col_wid(c) = TextWidth(M1.Fields(c).Name)
Next c
' Display the values for each row.
r = 1
Do While Not M1.EOF
MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1
For c = 0 To M1.Fields.Count - 1
MSFlexGrid1.TextMatrix(r, c) = _
M1.Fields(c).Value
' See how big the value is.
field_wid = TextWidth(M1.Fields(c).Value)
If col_wid(c) %26lt; field_wid Then col_wid(c) = _
field_wid
Next c
M1.MoveNext
r = r + 1
Loop
' Set the column widths.
For c = 0 To MSFlexGrid1.Cols - 1
MSFlexGrid1.ColWidth(c) = col_wid(c) + 240
Next c
' Close the recordset and connection.
M1.Close
Mycon.CloseIn visual basic 6, how can u bind a datagrid control to the ms access database usng manual coding adodb?
hello!......he asked for a data grid control and not a flex grid control you DUH!
Set GRID.DataSource = REC
End Sub
that is my code but it wont work. the error is : the rowset is not bookmarkable. pls send me the correct code. thanks a lot.In visual basic 6, how can u bind a datagrid control to the ms access database usng manual coding adodb?
This is an unbound method. It works for me. Hope this helps you too.
Dim Mycon As New ADODB.Connection
Dim M1 As New ADODB.Recordset
Dim S1 As String
S1 = ';Provider=Microsoft.Jet.OLEDB.4.0;'; %26amp; _
';Data Source='; %26amp; _
App.Path %26amp; ';A.mdb';
Mycon.Open S1
M1.Open ';select * from B';, Mycon, adOpenDynamic, adLockOptimistic
Dim c As Integer
Dim r As Integer
Dim col_wid() As Single
Dim field_wid As Single
' Use one fixed row and no fixed columns.
MSFlexGrid1.Rows = 2
MSFlexGrid1.FixedRows = 1
MSFlexGrid1.FixedCols = 0
' Display column headers.
MSFlexGrid1.Rows = 1
MSFlexGrid1.Cols = M1.Fields.Count
ReDim col_wid(0 To M1.Fields.Count - 1)
For c = 0 To M1.Fields.Count - 1
MSFlexGrid1.TextMatrix(0, c) = M1.Fields(c).Name
col_wid(c) = TextWidth(M1.Fields(c).Name)
Next c
' Display the values for each row.
r = 1
Do While Not M1.EOF
MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1
For c = 0 To M1.Fields.Count - 1
MSFlexGrid1.TextMatrix(r, c) = _
M1.Fields(c).Value
' See how big the value is.
field_wid = TextWidth(M1.Fields(c).Value)
If col_wid(c) %26lt; field_wid Then col_wid(c) = _
field_wid
Next c
M1.MoveNext
r = r + 1
Loop
' Set the column widths.
For c = 0 To MSFlexGrid1.Cols - 1
MSFlexGrid1.ColWidth(c) = col_wid(c) + 240
Next c
' Close the recordset and connection.
M1.Close
Mycon.CloseIn visual basic 6, how can u bind a datagrid control to the ms access database usng manual coding adodb?
hello!......he asked for a data grid control and not a flex grid control you DUH!
Report Abuse
How to customize datagrid in vb.net?
select a datagrid and go to the propert viewer and change it
u can customize its width and height, and so on just go check it out ...How to customize datagrid in vb.net?
Go to www.codeproject.com
u can customize its width and height, and so on just go check it out ...How to customize datagrid in vb.net?
Go to www.codeproject.com
How to display data in datagrid after retrieve from database using VB.NET?
in C# but you can change it to VB.NET
DataGrid myGrid = new DataGrid;
myGrid.DataSource = myDataTbl;
myGrid.DataBind();How to display data in datagrid after retrieve from database using VB.NET?
set the datasource property to the database table you want it to populate.
DataGrid myGrid = new DataGrid;
myGrid.DataSource = myDataTbl;
myGrid.DataBind();How to display data in datagrid after retrieve from database using VB.NET?
set the datasource property to the database table you want it to populate.
Delete record from datagrid with ajax use checkboxes.?
I want to delete records that selected with checkboxes.(use ajax)
how can i do it?
please help me.
thanks.Delete record from datagrid with ajax use checkboxes.?
this is a regular html with a javascript function, you can implement it to AJAX later if you want to.
%26lt;!DOCTYPE html PUBLIC ';-//W3C//DTD HTML 4.01 Transitional//EN';%26gt;
%26lt;html%26gt;
%26lt;head%26gt;
%26lt;title%26gt;
SOCCER Field
%26lt;/title%26gt;
%26lt;script language=';Javascript'; type=';text/javascript';%26gt;
function deleteItem() {
var e = document.getElementsByName(';checkID';);
var message = 'delete all selection??';
var row_list = {length: 0};
for (var i = 0; i %26lt; e.length; i++) {
var c_box = e[i];
if (c_box.checked == true) {
row_list.length++;
row_list[i] = {};
row_list[i].row = c_box.parentNode.parentNode;
row_list[i].tb = row_list[i].row.parentNode;
}
}
if (row_list.length %26gt; 0 %26amp;%26amp; window.confirm(message)) {
for (i in row_list) {
if (i == 'length') {
continue;
}
var r = row_list[i];
r.tb.removeChild(r.row);
}
}
}
%26lt;/script%26gt;
%26lt;/head%26gt;
%26lt;body%26gt;
%26lt;form name=';myform'; id=';myform';%26gt;
%26lt;input onclick=';deleteItem()'; type=';button'; value=';Delete';%26gt;%26lt;br%26gt;
%26lt;table id=';myTable'; border=';1';%26gt;
%26lt;tbody%26gt;
%26lt;tr id=';d1';%26gt;
%26lt;td%26gt;
%26lt;input name=';checkID'; type=';checkbox';%26gt;01
%26lt;/td%26gt;
%26lt;td%26gt;
satu
%26lt;/td%26gt;
%26lt;/tr%26gt;
%26lt;tr id=';d2';%26gt;
%26lt;td%26gt;
%26lt;input name=';checkID'; type=';checkbox';%26gt;02
%26lt;/td%26gt;
%26lt;td%26gt;
dua
%26lt;/td%26gt;
%26lt;/tr%26gt;
%26lt;tr id=';d3';%26gt;
%26lt;td%26gt;
%26lt;input name=';checkID'; type=';checkbox';%26gt;03
%26lt;/td%26gt;
%26lt;td%26gt;
tiga
%26lt;/td%26gt;
%26lt;/tr%26gt;
%26lt;tr id=';d4';%26gt;
%26lt;td%26gt;
%26lt;input name=';checkID'; type=';checkbox';%26gt;04
%26lt;/td%26gt;
%26lt;td%26gt;
empat
%26lt;/td%26gt;
%26lt;/tr%26gt;
%26lt;/tbody%26gt;
%26lt;/table%26gt;
%26lt;/form%26gt;
%26lt;/body%26gt;
%26lt;/html%26gt;love myspace myspace girl
how can i do it?
please help me.
thanks.Delete record from datagrid with ajax use checkboxes.?
this is a regular html with a javascript function, you can implement it to AJAX later if you want to.
%26lt;!DOCTYPE html PUBLIC ';-//W3C//DTD HTML 4.01 Transitional//EN';%26gt;
%26lt;html%26gt;
%26lt;head%26gt;
%26lt;title%26gt;
SOCCER Field
%26lt;/title%26gt;
%26lt;script language=';Javascript'; type=';text/javascript';%26gt;
function deleteItem() {
var e = document.getElementsByName(';checkID';);
var message = 'delete all selection??';
var row_list = {length: 0};
for (var i = 0; i %26lt; e.length; i++) {
var c_box = e[i];
if (c_box.checked == true) {
row_list.length++;
row_list[i] = {};
row_list[i].row = c_box.parentNode.parentNode;
row_list[i].tb = row_list[i].row.parentNode;
}
}
if (row_list.length %26gt; 0 %26amp;%26amp; window.confirm(message)) {
for (i in row_list) {
if (i == 'length') {
continue;
}
var r = row_list[i];
r.tb.removeChild(r.row);
}
}
}
%26lt;/script%26gt;
%26lt;/head%26gt;
%26lt;body%26gt;
%26lt;form name=';myform'; id=';myform';%26gt;
%26lt;input onclick=';deleteItem()'; type=';button'; value=';Delete';%26gt;%26lt;br%26gt;
%26lt;table id=';myTable'; border=';1';%26gt;
%26lt;tbody%26gt;
%26lt;tr id=';d1';%26gt;
%26lt;td%26gt;
%26lt;input name=';checkID'; type=';checkbox';%26gt;01
%26lt;/td%26gt;
%26lt;td%26gt;
satu
%26lt;/td%26gt;
%26lt;/tr%26gt;
%26lt;tr id=';d2';%26gt;
%26lt;td%26gt;
%26lt;input name=';checkID'; type=';checkbox';%26gt;02
%26lt;/td%26gt;
%26lt;td%26gt;
dua
%26lt;/td%26gt;
%26lt;/tr%26gt;
%26lt;tr id=';d3';%26gt;
%26lt;td%26gt;
%26lt;input name=';checkID'; type=';checkbox';%26gt;03
%26lt;/td%26gt;
%26lt;td%26gt;
tiga
%26lt;/td%26gt;
%26lt;/tr%26gt;
%26lt;tr id=';d4';%26gt;
%26lt;td%26gt;
%26lt;input name=';checkID'; type=';checkbox';%26gt;04
%26lt;/td%26gt;
%26lt;td%26gt;
empat
%26lt;/td%26gt;
%26lt;/tr%26gt;
%26lt;/tbody%26gt;
%26lt;/table%26gt;
%26lt;/form%26gt;
%26lt;/body%26gt;
%26lt;/html%26gt;
How do i add a button column to a datagrid in a c# .net windows application?(NOT an asp.net application)?
the gatagrids source is a dataset and i need the column to allow the user to update the info in the tableHow do i add a button column to a datagrid in a c# .net windows application?(NOT an asp.net application)?
I've learned that reinventing the well is not really the best solution.
I've tried this solution and it works perfect for my need:
http://www.codeproject.com/cs/miscctrl/csharpgridcontrol.asp
I've learned that reinventing the well is not really the best solution.
I've tried this solution and it works perfect for my need:
http://www.codeproject.com/cs/miscctrl/csharpgridcontrol.asp
Please help me :how to check the data table value is null before binding into datagrid in asp.net?
Thanks in advancePlease help me :how to check the data table value is null before binding into datagrid in asp.net?
Actually, I can provide an overview bcoz I had forgot the exact eventhandler and attributes.
U have to code in DataGrid1_Bind(...) eventhandler
if(DataGrid1.Cell[i]==null)
DataGrid1.Cell[i]=/*ur value*/;Please help me :how to check the data table value is null before binding into datagrid in asp.net?
Use the IsDBNull method
if IsDBNull(value) = false then
'Add to datagrid
end if
Actually, I can provide an overview bcoz I had forgot the exact eventhandler and attributes.
U have to code in DataGrid1_Bind(...) eventhandler
if(DataGrid1.Cell[i]==null)
DataGrid1.Cell[i]=/*ur value*/;Please help me :how to check the data table value is null before binding into datagrid in asp.net?
Use the IsDBNull method
if IsDBNull(value) = false then
'Add to datagrid
end if
Asp.net datagrid template column and hyperlink column?
i m using sql server. the table has composite key. what should i do for editing and deleting the records? i have come to know that hyperlinkcolumn is to used for editing of a record with composite key. can anybody help????
how to handle radio bittons using template columns?Asp.net datagrid template column and hyperlink column?
Study the Article at the following link ,
this will certainly help :
http://samples.gotdotnet.com/quickstart/鈥?/a>
how to handle radio bittons using template columns?Asp.net datagrid template column and hyperlink column?
Study the Article at the following link ,
this will certainly help :
http://samples.gotdotnet.com/quickstart/鈥?/a>
Monday, August 16, 2010
Datagrid Design on Windows Form?
I am using VB 2005 and have a datagridview thats bound to a table in a database. I have some collumns that are combo boxes that displays data from differents tables. The problem that I am having is that it takes some time for the data to load in the combo boxes and doesnt display when the user clicks the drop down. How can I speed that up?Datagrid Design on Windows Form?
Interesting to read about the DataGridView control; looks like it has some nice features.
My guess is that you have two problems.
1) Check that you have set a value for the MaxDropDownItems property to a reasonable number, such as 8. I am wondering if the value is set to bad value so that the data doesn't display.
2) Your SQL query for populating the drop down may be inefficient. Try testing the query separately. If you have installed SQL Server Management Studio (Express), you can run the query and then check the Execution Plan to see where the time is being spent. A bad query could result in a Cartesian join which runs a long time, creates a large number of rows, and is rarely the result intended. Again SQL Server Management Studio would let you see this easily.
Actually, the large number of records problem could explain the dropdown issue as well.
Interesting to read about the DataGridView control; looks like it has some nice features.
My guess is that you have two problems.
1) Check that you have set a value for the MaxDropDownItems property to a reasonable number, such as 8. I am wondering if the value is set to bad value so that the data doesn't display.
2) Your SQL query for populating the drop down may be inefficient. Try testing the query separately. If you have installed SQL Server Management Studio (Express), you can run the query and then check the Execution Plan to see where the time is being spent. A bad query could result in a Cartesian join which runs a long time, creates a large number of rows, and is rarely the result intended. Again SQL Server Management Studio would let you see this easily.
Actually, the large number of records problem could explain the dropdown issue as well.
How to delete selected row data in datagrid using vb.net?
Without using Sql queries....How to delete selected row data in datagrid using vb.net?
For just basic deleting you can click on the row you wish to delete highlight the row and dress the delete key, or you can create a context menu on the datagrid and fire a delete selected row event. Hope this helps.
Cheers
For just basic deleting you can click on the row you wish to delete highlight the row and dress the delete key, or you can create a context menu on the datagrid and fire a delete selected row event. Hope this helps.
Cheers
How to disable copy from a datagrid in vb.net 05
people start copying critical information from datagrids and paste in excel.... this is not done..... please suggest a solution quickly....How to disable copy from a datagrid in vb.net 05
Have you tried setting the Enabled property to False? (after populating object)
This way you can not select text from the object, of course it may be harder to read but your info is safer.
Good luck!love myspace myspace girl
Have you tried setting the Enabled property to False? (after populating object)
This way you can not select text from the object, of course it may be harder to read but your info is safer.
Good luck!
Does anybody know how to include controls in the DataGrid..?
The process of adding control to datagrid in different in Desktop Application and web application. The following is how you add a control to datagrid in a DeskTop Application :-
Let see how to add combo box:
1. Make a new class [say combostyle] which inherits the dataColumnStyle Class
2. define an instance of combobox in the class i.e dim combo as new combobox
3. now override the edit, paint, new etc. procedures to display and modify the combo box [as per your requirements].
4. once you have made your combostyle class, add an instance of the class to the dataTableStyle.GridColumnStyle.
I learned it after going through lots of article on msdn, codeproject etc. I don't remember the specific links. You can search the above sites. They will give you an idea how to go about it. Since each person's requirement is different, you most probabily will have to modify the codes given in these articles.Does anybody know how to include controls in the DataGrid..?
hi
check out this example. I have included dropdown list control in datagrid using %26lt;asp:templatecolumn%26gt;.
%26lt;asp:TemplateColumn HeaderText=';Status';%26gt;
%26lt;HeaderStyle Width=';0px';%26gt;%26lt;/HeaderStyle%26gt;
%26lt;ItemStyle HorizontalAlign=';Left'; Width=';70px'; VerticalAlign=';Middle';%26gt;%26lt;/ItemStyle%26gt;
%26lt;ItemTemplate%26gt;
%26lt;asp:DropDownList ID=';ddlBestStatus'; Runat=';server'; CssClass=';textbox1'; OnSelectedIndexChanged=';ddlBestStatus_Se鈥?br>
AutoPostBack=';True';%26gt;%26lt;/asp:DropDownList鈥?br>
%26lt;/ItemTemplate%26gt;
%26lt;/asp:TemplateColumn%26gt;
--------
u can also do the same using property builder.
Let see how to add combo box:
1. Make a new class [say combostyle] which inherits the dataColumnStyle Class
2. define an instance of combobox in the class i.e dim combo as new combobox
3. now override the edit, paint, new etc. procedures to display and modify the combo box [as per your requirements].
4. once you have made your combostyle class, add an instance of the class to the dataTableStyle.GridColumnStyle.
I learned it after going through lots of article on msdn, codeproject etc. I don't remember the specific links. You can search the above sites. They will give you an idea how to go about it. Since each person's requirement is different, you most probabily will have to modify the codes given in these articles.Does anybody know how to include controls in the DataGrid..?
hi
check out this example. I have included dropdown list control in datagrid using %26lt;asp:templatecolumn%26gt;.
%26lt;asp:TemplateColumn HeaderText=';Status';%26gt;
%26lt;HeaderStyle Width=';0px';%26gt;%26lt;/HeaderStyle%26gt;
%26lt;ItemStyle HorizontalAlign=';Left'; Width=';70px'; VerticalAlign=';Middle';%26gt;%26lt;/ItemStyle%26gt;
%26lt;ItemTemplate%26gt;
%26lt;asp:DropDownList ID=';ddlBestStatus'; Runat=';server'; CssClass=';textbox1'; OnSelectedIndexChanged=';ddlBestStatus_Se鈥?br>
AutoPostBack=';True';%26gt;%26lt;/asp:DropDownList鈥?br>
%26lt;/ItemTemplate%26gt;
%26lt;/asp:TemplateColumn%26gt;
--------
u can also do the same using property builder.
How do i get flash to send data from one datagrid to another. I am using PHP and MySQL?
http://www.phpbuilder.com/columns/hill20011214.php3?page=4
you can pass vars to scripts through action script, most of these are used through either get or post vars in forms.. im not too experienced with flash but i am sure you could get it working properly by playing with the action script and producing vars from there to be passed to php scripts which then manipulate the databaseHow do i get flash to send data from one datagrid to another. I am using PHP and MySQL?
You can't send data from Flash to PHP/Mysql. Flash uses action script. It can manipulate data and interact with the user...but it can't send data. You could use a form or some means of transferring the data through the address bar (with variables) and have PHP interpret the vars.
you can pass vars to scripts through action script, most of these are used through either get or post vars in forms.. im not too experienced with flash but i am sure you could get it working properly by playing with the action script and producing vars from there to be passed to php scripts which then manipulate the databaseHow do i get flash to send data from one datagrid to another. I am using PHP and MySQL?
You can't send data from Flash to PHP/Mysql. Flash uses action script. It can manipulate data and interact with the user...but it can't send data. You could use a form or some means of transferring the data through the address bar (with variables) and have PHP interpret the vars.
Subscribe to:
Posts (Atom)