Creating A SqlConnection From A Function?
Aug 13, 2010
I'm having a problem with my global connection function. It used to be a readonly property but I changed it to a function because the code anaylsis engine was complaining about my property raising exceptions. The function is designed to take account of our offsite database mirroring system, so if it can't create a connection to the principal server it switches the connection string to the mirror server. This works fine in another project we have:
Public Shared Function Connection() As SqlConnection
If String.IsNullOrEmpty(ActiveConnectionString) = True Then
Throw New PropertyNotSetException("Cannot call Connection() before
[Code].....
View 2 Replies
ADVERTISEMENT
Apr 11, 2011
I have the following function so far and I dont know how to continue
Public Function getdetails(ByVal id as Integer) as Data.DataTable
Dim query as string
Dim mydatatable as Data.DataTable = new Data.DataTable()
[code]....
basically I am using to C# and just learning vn.net..What I want to do is save the information t,id and t.color in a datatable in vb.net..How do i do that.
View 2 Replies
Mar 1, 2010
I've found some difficulty in creating a graph through the function given.For example:
Function : y = x^2 + 2
y value ranging from -10 to 10
x value ranging from -20 to 20
the graph also gridlines anf title on each axes.
View 5 Replies
Jun 20, 2012
i simple want to adapt . if connection is open we need to return true .else i need to return false .i have already adapt in c#. but we need to do the following way in vb.net .
public bool ConnectionTest(){
string server = Properties.Settings.Default.ServerName;
string catalog = Properties.Settings.Default.Catalog;
[code]....
View 9 Replies
Jun 28, 2011
I'm having a problem creating a function for calculating an average. I need to divide the sum of a column of integers by the number of rows in that column. These integers are generated by a datediff command and their values are assigned to textboxes in a report. The results can only be whole numbers, no decimal points.
I'm pretty new to this so if this is an obvious question please excuse my ignorance. If you need any more information to address my question please let me know.
View 4 Replies
Aug 9, 2011
How can I create a separate class that has the function that adds dynamic text box, so that I will just call that function to my main form. I have the code below that does add dynamic text box but it is already inside the button of my main
[Code]...
View 10 Replies
May 27, 2011
I tried to search forum topics to find a tutorial that will guide me on how to achieve this however seem like most of the tutorials i were finding were confusing me more.With that being said here is what i have,Here is what I am trying to do [URL]that tutorial is exactly what I am trying to achieve however I do not understand what the supplierstableadpater, northwindtableadapters are. I can only assume that I am not doing exactly the same thing as that tutorial.
What I have is a simple sql storedprocedure that selects all employeedetails.And also another sql stored procedure that selects just a few columns from the employees table. On my frist page I am going to list all the employee names in a gridview and when they click the employee name it should take them to another page and show that employee's details. Seems like you have to use an object datasource to achieve this but is there an easier way to achieve creating a class that calls the 2 stored procedures that I have that i would be able to then link them with an objectdatsource?
View 1 Replies
Mar 10, 2011
I have a function class in which I have created a function that connects to an Access database and runs a query and returns a dataset.
View 3 Replies
Jun 11, 2011
I want to Create a Publick Function But Geting problems with last Line
"MyBase.OnKeyUp(e)"
Private Sub _KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs)
Dim dg As DataGridView
Dim txt As TextBox
[code]....
View 3 Replies
Dec 8, 2010
i am going creating a simple function calculator, but I had to first do a design documentation proposal. I now have to update the project proposal with a storyboard or list of menu and screen items to delineate my proposed user screen and menus.aside from the calculator itself there will not be any menus.I also have to list any user data inputs and outputs my application will require and produce, which i assume i can put any numbers that the user inputs into the calculator and their results.
View 5 Replies
Jan 11, 2011
I am trying to create a Public Sub / Function that will allow me to pass certain variables into it and this will affect the output. e.g.
DIV ID = InfoDiv
CSS Class = "Warning"
LBInfoMsg.Text = "An Error has occured"
DIV Visibility = True or False
I would like to type something similar in the code behind page:
InfoMsg(InfoDiv, "warning", "An Error has Occurred", True)
Public Sub InfMsg(ByRef MyDIV As System.Web.UI.HtmlControls.HtmlGenericControl, ByRef CSS As System.Web.UI.WebControls.Style, ByVal strMessage As String)
strMessage = strMessage.Replace("'", "''")
MyDIV.Attributes.Add("Style", "warning")
MyDIV.Visible = "True"
End Sub
View 1 Replies
May 5, 2010
Alright so basically I have created a function so it can get the data and do the following things, etc
Public Function stats(ByVal texti As String, ByVal imageURL As String) As String
Label1.Text = weapontexti
MyImage.Image = imageURL
End Function
I basically want to do something like that ^ and then be able to enter things (instead of writing lots and lots of code):This is what I want the function to do when I click a button:Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
weaponstats("Example Text", "images/etcimage.png")End Sub
Is there anyway (even if it requires something else rather than functions) to this without an error?
View 7 Replies
Apr 21, 2011
Is it possible to create a routine in VB.NET with a name-based parameter array? The WebMethod attribute built into the framework is used exactly this way: WebMethod(BufferResponse:=False)
Specifically, I'd like to use it in a class' constructor. I'd like something similar to this:
New MyObject(id:=10,buffer:=True)
I'm not even sure what the terminology is for this kind of parameter list, so I can't even find it when searching.
View 2 Replies
Aug 11, 2010
Given the following code and link to SkyDrive VS2010 project, how would I create this vb.net project and access it in my c# application?
//the following c# project reference to function in vb.net is not working
string retval = ConvertUTF8_toASCII.UTF8_toASCII(stirngToConvert);
View 5 Replies
Nov 14, 2009
i am trying to create a search function/filter for a list box basicly when i type a letter or letters into a text box i want the listbox items to be filtered so say i have 5 names in the list box as follows:
[Code]...
View 8 Replies
Feb 18, 2010
I am working a VB project that requires me to create an "Average" Function. What is the correct format in creating an average function? I tried different ways and gives me an error.
View 2 Replies
Jan 13, 2011
I am trying to update some code. I have a vb file that begins with this...
Imports System.Data.SqlClient
Imports System.Data.Sql
Imports System.Data.SqlTypes
[Code].....
...and it accepts it. Why do I need to explicitly write out System.Data.SqlClient every time I use an object from that class???
View 4 Replies
May 17, 2010
i would like to know if there's something wrong in this asp.net code:
mydatareader = mycmd.executeReader()
if myDataReader.HasRow then
// Do something
[code].....
View 4 Replies
Jul 20, 2011
I am confused about something and I hope someone here can give me an answer
View 3 Replies
May 18, 2010
Let's say we use NASM as they do in this answer: how to write hellow world in assembly under windows.I got a couple of thoughts and questions regarding assembly combined with c# or any other .net languages for that matter.First of all I want to be able to create a library that has the following function HelloWorld that takes this parameter: Name In C# the method signature would looke like this: void HelloWorld(string name) and it would print out something like Hello World from name To sum it up Create a routine in ASM ( NASM ) that takes one or more parameters Compile and create a library of the above functionality Include the library in any .net language Call the included library function Bonus features How does one handle returned values?Is it possible to write the ASM-method inline When creating libraries in assembly or c, you do follow a certain "pre defined" way, the c calling convetion, correct?
View 4 Replies
Nov 20, 2011
I did this and no error or warning appears and when I run it only String[]Array appears in the listbox. can you help me fix this? I already have the logic down I am not sure how to fix this. My project is due tomorrow this is the only part I'm stuck on.
[Code]...
View 3 Replies
Nov 20, 2011
I am learning ADO.NET But it very hard for me... I dont understand why have got this compiler error:"Declaration expected" for the connection.Open().[code]
View 1 Replies
Jun 2, 2009
What would happen if you call Close() on a SqlConnection object before you call Close() on a SqlDataReader using that connection?
Actually, what I really want to know is whether or not the order in which you Close them matters. Does calling SqlConnection.Close() completely close the connection, or will it remain open if you do not call Close() on a SqlDataReader using that connection?
I don't think I really understand how connection closing works.
View 3 Replies
Apr 26, 2012
I keep getting the following exception when I do:
[code]...
View 1 Replies
Jun 19, 2009
I have a SqlConnection global variable in my proyect that it is always open (I wouldn't like to start a discussion about keep the connection open all the time or close it everytime a transaccion is executed).
This variable is sent to every class I need to execute a function or method. Instead of checking the connection in every single operation, is there any way to monitor the connection state in a centralized way ?
View 3 Replies
Jan 4, 2012
I'm trying to add transaction support to our database object.This object is a Remoting object. (this to ensure that on the Windows Client, no database connection is required.)Now I want to add support for transactions;Basically, a client will need to use it like this;
BeginTransaction
ExecuteNonQuery("insert...")
ExecuteNonQuery("insert...")
[code].....
View 2 Replies
Jan 28, 2011
I am recently new to Visual Basic and am starting to learn some things i have managed to connect to the SQL Server and Insert rows to a table. But is there a way to be able to re-use an already existing connection ?My code below. I tried to create a class for the Connection object.
Imports System.Data.SqlClient
Imports System.Data.Sql
Public Class dbConnection
[code]....
View 7 Replies
Mar 8, 2012
What i am trying to is create a function were by a user when he logs in, based on the rights given to them they can either use certain buttons . I no i have to use the enable and disable function.[code]if username is true and user_name is Sales then enable x y z buttons. i been trying looking around and reading and found the following which i cannot get to work with my system but they follow a similiar patten to what i want to achieve.[code]
View 1 Replies
Aug 26, 2009
i'm trying to build websites crawler and i having a bit of problem creating recursive function to get all the site link, provide a link to an example ?
View 2 Replies
May 20, 2010
[code]in this code, do the objects con and cmd get disposed because the return statement is placed before the end using statement.
View 1 Replies
