You can probably, expose AllowEdit through a public property and set it from your code
love2code
You can probably, expose AllowEdit through a public property and set it from your code
love2code
delete the first row, and insert second row just changing the primary key love2code
Please , can any one confirm that a table type or collection type parameter can be passed to stored procedure in oracle using ADO.NET ? I , browsed several forum and site but without success Thanks love2code
Cofirm your machine has a true IP Address, and You will have it only when you have an adapter. Try to ascertain using a ping command CMD > ping <IP Address> love2code
Not all xml file can be shown on the grid, It has to be in proper schema, or manually you have to file in a DataTable of a DataSet. Whenever a DataSet is writen into a xml file, it format the xml file in a recognized format, and preferable with its schema. The same xml file can be read into a DataSet. And at last , DataSource property of DataGrid can be set to that DataSet to show the xml file. Refer : DataSet.Load(), DataSet.WriteXml() for further information. love2code
Did you check up datatype ?? I mean comatibility of nvarchar ??? love2code
Hi, ajith, Best practice to put your database on the web is using ASP(Active Server Pages) which runs on the VBScript. Since , I do not know any way to connect VB forms on the web, I can assure, ASP will do all the job for you. There is no different connection string.. You need a IIS server, SQL Server. I advice you to install IIS and then type "http://localhost/" in the URL ( Address bar in Internet explorer). You will get ASP help. You need to read manual for ADO also, refer MSDN. Best way to connect using a ODBC connection, So set up a ODBC connection for your SQL Server - Database(Ex: DSN=testSQL) Create Coonection as follows <% Conn = Server.CreateObject("ADODB.Connection") Conn.Open "DSN=testSQL",, Rs = Server.CreateObject("ADODB.Resultset") Rs.Open SQL,Conn,3,3,1 '''''''''''''''''' Do your work Rs.Close Conn.Close Happy programming love2code
where from [dt:type="string"] is coming into the picture, did you specify the namespace ??? love2code
then what is your problem ?? do u need to write non empty element only ?? love2code
Hi, since it is a simple requirement, I have placed a simple solution Try this.. ////////////////////////////////////////// using System; using System.Xml; namespace ConsoleApplication1 { /* c:\pk.xml Washington George Lincoln Abraham */ class XmlTest { XmlDocument doc;// public XmlTest() { doc = new XmlDocument(); doc.Load("c:\\pk.xml"); // put your file path } public void Run() { while(true) { Console.Write("\nEnter a Name: "); string input = Console.ReadLine(); if(input == "" || input==null) break; Console.WriteLine("Your FName is " + GetFName(input)); } } public string GetFName(string lname) { string ret = "Unknown" ; XmlNodeList lnode = doc.GetElementsByTagName("Lname"); for(int i=0; i< lnode.Count; i++) { if(lnode.Item(i).InnerText.Trim() == lname.Trim()) { ret = lnode.Item(i).ParentNode.LastChild.InnerText; break; } } return ret; } public static void Main() { XmlTest xmlDoc = new XmlTest(); xmlDoc.Run(); } } } love2code
Create one DataView from Data Source or Manually replace those table name with your logic... I have created a fake table, in real situation , query from database /// Create DataSource :: select tablename,tablealias from all_tables /*Code::*/ ICollection CreateDataSource() { DataTable dt = new DataTable(); DataRow dr; dt.Columns.Add(new DataColumn("TableName", typeof(string))); dt.Columns.Add(new DataColumn("TableAlias", typeof(string))); for (int i = 0; i < 9; i++) { dr = dt.NewRow(); dr[0] = i.ToString() + " No Table"; dr[1] = i.ToString() + " No Alias"; dt.Rows.Add(dr); } DataView dv = new DataView(dt); return dv; } // Fill the list with above mentioned datasource private void FillList() { ListBox1.DataSource = CreateDataSource(); ListBox1..DataTextField="TableName"; ListBox1.DataValueField="TableAlias"; } happy programming.. Pijush Biswas, Jaisalmer softestpk@yahoo.com love2code
Hi, I am finding difficulties to hold all 13000 rows in DataSet , and DataReader is not reading beyond 65535 rows , my application wants to process all rows at a single shot. I am using OLEDB Jet 4.0 Driver provided by Microsoft. Please do help !!!! PK Biswas love2code
No body liked this questions.. How fool am I .. Shall I quit the programming ??? love2code
Try '\r\n' in place of '\n', May it solve your problem love2code
Hi, I am writing an application, which takes a access table < OLEDB 4.0 > provided by ADO.NET connection. I have used both OleDbDataReader as well as OleDbDataAdapter to fetch records from that table, but is providing me only 65536 rows where that table contatains 13000 rows. Neither I can export to it in a text file , nor I can show it to a DataGrid. Since I have to keep those records in some other Repository, please , some one , provide me such a solution to access all the rows.. [ if code placed , please Code it in C# ] Thank you. love2code
How do I filter all question submitted by me or replied by me irrespective of subject ??? Since it is speard over several pages , I could find my query appearing on board as quickly I needed. love2code
How do I simulate a ping command ?? And My need is to know IP "156.72.1.30" is reachable or not , if yes, port 3962 opened or not. I do not know which service is running on that port. love2code
Thanks, Luis My parameters problem has been solved. But think those situation where my client machine has .net installted and oracle net client installed. When i run my program from that machine, it continues searching Oracle Server. My program does not know the Orcale [alias] or [data source] configured at that machine. Please provide me such Microsoft Solution. Thanks again. PK Biswas, India. love2code
Yes , you can. User Interop Service . In visual studio you can add reference to mshtml.dll to import all COM / Interfaces, some of them will be converted into Good c# classes. Just "using mshtml" you can code all that web.. Happy programming.. love2code
Please tell me how can I stop my axWebBrowser to stop download all non-text files(media,wav,image...) embeded in HTML page. I want to download only html text. Please provide me mshtml COM programming solution only in C# code. love2code