|
Could someone tell me what I am doing wrong? I am trying to add access into visual basic. I have changed the server for access (Microsoft Jet 4.0 OLE DB Provider). I have done the test connection - all is well. I have added the dataGrid to the web form- Named it MyDG1. I clicked on OldDbDataAdapter and added the connection where the access page is. I have done the Query builder, generate dataset (which I called MyDS). I selected the the dataset and Previewed it - all is well when I filled it in. I assigned a table to the DataView - Shopping Products (my access page). I assigned the DataSource property on the DataGrid as DataView1. In the page_load handler I added
OleDbDataAdaper1.Fill(MyDS1)
Page.DataBind()
I build it - all is good; however when I view in browser that is when I get my error. Here is my error.
Server Error in '/WebApplication1/WebApplication1/Unit5' Application.
--------------------------------------------------------------------------------
Unspecified error
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Unspecified error
Source Error:
Line 83: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Line 84: 'Put user code to initialize the page here
Line 85: OleDbDataAdapter1.Fill(MyDS1)
Line 86: Page.DataBind()
Line 87: End Sub
Source File: c:\inetpub\wwwroot\WebApplication1\WebApplication1\Unit5\WebForm1.aspx.vb Line: 85
Stack Trace:
[OleDbException (0x80004005): Unspecified error]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvider() +57
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
Unit5.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebApplication1\WebApplication1\Unit5\WebForm1.aspx.vb:85
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
Can anybody help me?
Thank you,
ibok23
|
|
|
|
|
You question would be better handled in the ASP.NET Forum.
But, off the top of my head, does your server's ASP.NET account have the rights to the folder and database file that your access database resides in?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
yes, i coded it so it would allow the database. I will approach asp.net now. Thanks,
Thank you,
ibok23
|
|
|
|
|
Helo, I am building an VB.NET application that should be able to send a short message service to mobile phone. How should i build it? What resources should I need to build such application?
Thanks
Learning .NET
|
|
|
|
|
Sending SMS messages takes some in depth knowledge of SMS.
You can start by checking out http://www.schmidks.de/vbsms.aspx[^], http://www.textforce.com/sms_api/vb_example.htm[^]. Also, there are a bunch of articles here on CP. Just type "SMS" into the Search box just below the Code Project logo at the top of any page.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Share your story,
How did you learn VB?
|
|
|
|
|
I take a beginner course. While I was taking, I have used the internet resources such as forums as our media to learn VB.Net. I have also leant by myself from the text book.
That's all I learn it.
Thanks.
Learning .NET
|
|
|
|
|
Can you please be more specific (course company, website-Text book name & publisher). I really want to learn but don't know where to start.
|
|
|
|
|
I didn't
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!
|
|
|
|
|
How can I get a value from the row that I check using the datagrid below.
Something like e.item.cells(1).text, but I can't get that to apply to the row that I click the checkbox in.
<asp:datagrid id="dgBIA" runat="server" Width="259px" Height="145px" Font-Size="10pt" Visible="False" BackColor="White" BorderWidth="1px" BorderStyle="None" CellPadding="4" BorderColor="#3366CC">
<SelectedItemStyle Font-Bold="True" ForeColor="#CCFF99" BackColor="#009999"></SelectedItemStyle>
<ItemStyle ForeColor="#003399" BackColor="White"></ItemStyle>
<HeaderStyle Font-Size="Smaller" Font-Bold="True" ForeColor="Navy" BackColor="InactiveCaptionText"></HeaderStyle>
<FooterStyle ForeColor="#003399" BackColor="#99CCCC"></FooterStyle>
<Columns>
<asp:TemplateColumn>
<ItemTemplate>
<asp:CheckBox id="chk" runat="server" Checked='<%# Databinder.eval(container.dataitem, "There") %>' Visible=true AutoPostBack=True OnCheckedChanged="RA_CheckedChanged">
</asp:CheckBox>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
<PagerStyle BorderWidth="1px" BorderColor="White" HorizontalAlign="Left" ForeColor="#003399" BackColor="#99CCCC" Mode="NumericPages"></PagerStyle>
</asp:datagrid>
|
|
|
|
|
Does anyone know how to create a data dictionary for an advantage database server? Or any help to get me started?
Thanks in advance
Beginner is ASP and VB.Net
|
|
|
|
|
Britnt7 wrote:
advantage database server
Never heard of it...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Dave Kreskowiak wrote:
Never heard of it...
You shouldn't post a reply if you don't have the answer or a question about the topic. 
Do you know anything about creating a data dictionary at all?
Beginner in ASP.Net and VB.Net
|
|
|
|
|
How can I code a button column in the datagrid?
This is what I'm trying to code:
entity_id FirstName LastName Address
button text text text
Does everyone knows how to code the first column to button in datagrid? PLS HELP!!
thanks
Lisana
|
|
|
|
|
there are a few ways to do it.
the most straightforward, oo way of doing it would be to subclass the DataGridColumnStyle object and override the paint event to draw the button(s) according to your requirements.
i.e. does every column have a button all of the time, or only the row that is currently selected.
i don't have any code samples for this, but if you google for "button in datagrid" you should definitely come up with some.
hope this helps.
-jim
|
|
|
|
|
I have been searching of this for a week, but I don't have any luck get some code of it..most of them are for asp.net, C++, but I need VB.NET code for that..
I have done one way to create the button dataReader, but I have too many data to read, it's so slow when it load the data..so I need to find the only way faster to do it is datagrid..
|
|
|
|
|
the downloadable sample from the syncfucion winforms faq page should get you started.
http://www.syncfusion.com/faq/winforms/search/888.asp
-jim
|
|
|
|
|
I have a problem of this one..I tried to use this example, but I never get it to work..and I don't know how to do the pint and buttowdraw..there is problem of the button column..
it runs fine in the example code, but when I do my own code, there is error in the mouseup and mousedown, and I don't know what's wrong of my code.
|
|
|
|
|
can you post your mouseup and mousedown code? i'll have a look to see if i can determine what the problem is.
-jim
|
|
|
|
|
I have the error at here at the code below: isClickInCell = e.X > rect.Right - Me._buttonFace.Width
Public Sub HandleMouseDown(ByVal sender As Object, ByVal e As MouseEventArgs)
Dim dg As DataGrid = Me.DataGridTableStyle.DataGrid
Dim hti As DataGrid.HitTestInfo = dg.HitTest(New Point(e.X, e.Y))
Dim isClickInCell As Boolean = (hti.Column = Me._columnNum And hti.Row > -1)
Dim rect As New Rectangle(0, 0, 0, 0)
If isClickInCell Then
rect = dg.GetCellBounds(hti.Row, hti.Column)
isClickInCell = e.X > rect.Right - Me._buttonFace.Width
End If
If isClickInCell Then
Dim g As Graphics = Graphics.FromHwnd(dg.Handle)
DrawButton(g, Me._buttonFacePressed, rect, hti.Row)
g.Dispose()
_pressedRow = hti.Row
End If
End Sub
could you see what's wrong of that?
|
|
|
|
|
it can output the data, but the button column not show in button, when I click the button column, then give me these errors:
System.NullReferenceException: Object reference not set to an instance of an object.
at ResultOutput.DataGridButtonColumn.HandleMouseDown(Object sender, MouseEventArgs e) in C:\vb.net\ResultOutput\DataGridButtonColumn.vb:line 86
at System.Windows.Forms.Control.OnMouseDown(MouseEventArgs e)
at System.Windows.Forms.DataGrid.OnMouseDown(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
|
|
|
|
|
the line 86 is this:isClickInCell = e.X > rect.Right - Me._buttonFace.Width
the same as last msg
|
|
|
|
|
hi lisa, this is happening when you run the test app? it runs fine on my machine. are you sure you haven't modified the code at all in the test project. the line of code you reference above is erroring at line 86, but that line of code is at 94 (or so, I don't have the project open right now) in the project that I downloaded yesterday.
as for the error though i would step through the code to ensure that the rect and _buttonface objects are being created properly.
_buttonface is being created in the objects constructor while rect is being created just before the line that's erroring out.
those are the only two objects that could possibly be a null reference in that line as far as i can tell.
-jim
|
|
|
|
|
Thanks Jim..
I can run the example I downloaded in that site. But there is a problem that's I don't understand the DataGridButtonColumn.vb file, I don't know any about the DrawButton, DrawImage, MouseDown, MouseUp...and if I copy their codes to my application, then it can't work..
by the way, do you know where this colNum naem called from?
public sub new(byval colNum as integer)
_columnNum = colNum
_pressedRow = -1
-Lisa
|
|
|
|
|
I have some problem with serilaization can anybody help me. I wanted to serialize a Treenode and desiralize the same but desiralization not worked.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
