|
How to excecute stored procedure by using c# application in run time?
I need to know the coding.
Please someone help me as soon as possible
Thanx
Thilani
|
|
|
|
|
00thilani wrote: How to excecute stored procedure by using c# application in run time?
Have you searched anywhere yet?
The following classes will be useful to you:
* SqlConnection[^]
* SqlCommand[^]
* SqlDataReader[^]
The following properties and methods on the command will be useful to you:
* CommandType[^]
* ExecuteReader()[^]
If you try something and it doesn't work then show us what you've tried and we can help you out. There are plenty examples in the links that I gave you. If you are still stuck, show us what you did and we can correct it for you.
|
|
|
|
|
I have a WebBrowser component on a form, and it interacts with a site (www.zoomin.co.nz)though Javascript.
The Javascript contains functions such as GPoint gpt= GMap.getCenterLatLong()
In my application I need to be able to call that function in Javascript and find out the values for gpt (of the two floating point values that make it up) in my C# code.
Thanks
|
|
|
|
|
If you look inside the Document property there is a method called Invoke or InvokeScript (something like that anyway), you can pass the function name and parameters of the JavaScript function to invoke through this. As for getting the results it's probably documented in the documentation about the InvokeScript function.
(This may not be completely accurate but I do know that such a method does exists since I've used it but for reasons given in my sig I won't guarantee the accuracy  )
As of how to accomplish this I wouldn't have a clue at the moment and I'm too lazy to google it
|
|
|
|
|
Thanks - I will look at invoke script
I was not too lazy to google it, but found nothing straightforward fron the search 
|
|
|
|
|
hi
i am using c# and ms access and i have a search functionality in my app... i am wondering what's the concept behind showing the search progress by a progress bar?
thanks for your help in advance
|
|
|
|
|
If you have the number of items being searched then just use a progress bar with Maximum set to that value and set Value to the current index you're searching.
If you don't know how many items you're searching then you're best of using the ProgressBar (in .NET 2) with Style set to Marquee which is an "infinite" progressbar. If you're using .NET 1.x there are some articles here on CP which are to do with "Busy" bars which are essentially the same thing.
As of how to accomplish this I wouldn't have a clue at the moment and I'm too lazy to google it
|
|
|
|
|
Thanks but what index you're talking about?
I'm using the LIKE clause to do a simple search...
|
|
|
|
|
Please be more specific with your questions in the future or you'll get more answers you won't understand...
I assume you're executing an SqlCommand (or something similar) that's taking some time and you don't want your UI to hang while this command is running, right?
If this is the case, you could create a progressbar (infinite, like Ed.Poore suggested, since you don't know how long the command will run) and then execute the SqlCommand in a WorkerThread.
That way your UI will remain responsive while the SqlCommand is being executed. Once the command has finished you'll have to signalize to your initial class that the progress bar can be removed and that the results can be displayed.
If you're still unclear on how to do this, please google for the words written in code style to get more information on them (esp. WorkerThread).
Regards,
mav
--
Black holes are the places where god divided by 0...
|
|
|
|
|
The index is referring to (for example) if you were searching through a list or an array then you'll have to iterate through the items and you can use the position of the array / list (i.e. the index) you're currently at to display in the progress bar.
You were not clear in your original question as to what you were searching so I gave you two possible methods. If you're executing an SQL Query then you'll have to use an infinite progress bar.
As of how to accomplish this I wouldn't have a clue at the moment and I'm too lazy to google it
|
|
|
|
|
Hi,
I have a form that has a number of textBoxes that are bound to a one row table in a database. What I want the user to be able to do is change the value in the textbox and then click a save button to save all/any of the changes to the database.
I don't wish to "hard code" the methods and have devised the following; Note that the textboxes are named with the datatables columns prefixed by "textBox" eg Column1 becomes textBoxColumn1.
private void button1_SaveChangesClick(object sender, System.EventArgs e)
{
// Changes made to the text boxes need to be passed to the dataset dsMyClub1
// Create the DataTable
DataTable dtMyClub = dsMyClub1.Tables["MyClub"];
// Create variables containing the original values in the table
DataRow dtMyClubDataRow = dtMyClub.Rows.Find(1);
foreach (DataColumn myDataColumn in dtMyClub.Columns)
{
// reads the datatable and place the value in the variable
string columnName = myDataColumn.ToString();
string columnValue = dtMyClubDataRow[myDataColumn].ToString();
// get the value of the corresponding textbox into a variable
string tempTextBoxName = ("textBox" + columnName);
string textBoxName = tempTextBoxName;
string textBoxNameValue = this.textBoxName.Text.ToString();
// compare the variable with the textbox to see if it has changed
// if it has then update the datatable
if(columnValue != textBoxNameValue)
{
MessageBox.Show("Values are not equal" + columnValue + " " + textBoxNameValue);
}
else
{
MessageBox.Show("Values are equal");
}
The messageBoxes are just for debugging.
The programme has build errors in that "this.textBoxName" doesn't exist at build time.
The problem I have is getting the value in the corresponding textBox so that I can compare values. The only thing I'm getting into textBoxNameValue is the name of the textBox.
TIA
Glen Harvy
-- modified at 22:26 Saturday 22nd July, 2006
|
|
|
|
|
1. Use the Control.Name property (assign the variable name to it) and search for the control with the wanted name inside the Form.Controls collection to find the wanted TextBox.
2. Use reflection to retrieve the value of TextBox with given variable name.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
How I can Save All text in richTextBox as image
|
|
|
|
|
If you take this [^]article as the basis (ok, it adds extra things as syntax highlighting but those can be removed). All you need to do then is call DrawEditControl with a Graphics object created from an image rather than a PrintDocument. E.g.
private void Print()
{
using (Bitmap image = new Bitmap(width, height, PixelFormat.Format24bppRgb))
{
using (Graphics gfx = Graphics.FromImage(image))
{
DrawEditControl(gfx);
}
image.Save(filename, ImageFormat.Bmp);
}
}
As of how to accomplish this I wouldn't have a clue at the moment and I'm too lazy to google it
|
|
|
|
|
Hi
I'm sure I'm missing something, but I can't see what....
I take data from form1 to form2, make my changes and click on form2's save button. It updates correctly the form1's datagridview but doesn't save the data in the database.
Can anyone see why it doesn't save in the database?
Kind regards,
simsen 
My code:
private DataViewManager dsView;
private DataSet ds;
private OleDbDataAdapter da1;
private OleDbDataAdapter da2;
private OleDbCommandBuilder cBuilderKunder;
private OleDbCommandBuilder cBuilderFaktura;
string myDB = "c:\\ANSI\\Fakturasystem.mdb";
private void btnRetKunde_Click(object sender, EventArgs e)
{
// Find den aktuelle row der er selected når der dobbeltklikkes.
CurrencyManager cm = this.BindingContext[dgrKunder.DataSource,
dgrKunder.DataMember] as CurrencyManager;
if (cm != null)
{
DataRowView rowView = cm.Current as DataRowView;
if (rowView != null)
{
// Nu har vi row'en der skal editeres.
// Og vi starter din edit form op.
using (RetKunde ef = new RetKunde())
{
// Initialiserer din edit forms tekstfelter
// til de eksisterende data.
ef.Navn = rowView["Navn"].ToString();
ef.Adresse = rowView["Adresse"].ToString();
ef.Postnr = rowView["Postnr"].ToString();
ef.Byen = rowView["Byen"].ToString();
ef.Telefonnr = rowView["Telefonnr"].ToString();
ef.Mobilnr = rowView["Mobilnr"].ToString();
ef.EmailAdr = rowView["EmailAdr"].ToString();
ef.Noter = rowView["Noter"].ToString();
// Vi viser formen som en dialog, og tester hvilken knap brugeren har
trykket på vha. DialogResult.
if (ef.ShowDialog() == DialogResult.OK)
{
// Hvis brugeren trykkede på OK sætter vi værdierne i Row'en til de værdier
brugeren har tastet ind.
rowView["Navn"] = ef.Navn;
rowView["Adresse"] = ef.Adresse;
rowView["Postnr"] = ef.Postnr;
rowView["Byen"] = ef.Byen;
rowView["Telefonnr"] = ef.Telefonnr;
rowView["Mobilnr"] = ef.Mobilnr;
rowView["EmailAdr"] = ef.EmailAdr;
rowView["Noter"] = ef.Noter;
//opdaterer Adapteren
builderOpbygning();
da1.Update(ds);
}
}
}
}
}
private void builderOpbygning()
{
cBuilderKunder = new OleDbCommandBuilder(da1);
cBuilderFaktura = new OleDbCommandBuilder(da2);
da1.UpdateCommand = cBuilderKunder.GetUpdateCommand();
da1.DeleteCommand = cBuilderKunder.GetDeleteCommand();
da2.UpdateCommand = cBuilderFaktura.GetUpdateCommand();
}
|
|
|
|
|
|
I have read some of the articles - and thought I programmed it correctly - it doesn't help me to read them again ...... I know the code worked - before I bind it by myself and not used the wizard.....
|
|
|
|
|
I saved directly into the database instead of using the update command.
|
|
|
|
|
Hi guys
I'm wondering if I should set the objects that I create to null after I'm done with it... let's say I create FileStream object in private method, after I close the object should I write:
FileStreamObj.close();
FileStreamObj = null;
or:
FileStreamObj.close();
Is enough?
TIA
|
|
|
|
|
It's a good idea if the object can be accessed afterwards because then the code can test whether FileStreamObj is null before trying to access it and getting ObjectDisposedException which will consume more resources. If nothing else can access it after it's disposed, e.g. it's used as a variable in a function of some sorts then there probably isn't any need.
As of how to accomplish this I wouldn't have a clue at the moment and I'm too lazy to google it
|
|
|
|
|
|
Closing the file is enough.
Only set it to null if the reference is going to hang around and some code may try to use it. By setting it to null in that scenario you have a nice easy test to see if it is valid e.g. if (FileStreamObj == null)
|
|
|
|
|
I have an array full of values of type short?[] and want to display them in a MultiLine Textbox which requires values of type string[].
I can not figure out how to convert between the two value types.
Here is my code that I thought would work but I get error - "can not convert type short?[] to string[] "
NumArray = new short?[37];<br />
<br />
public void SetFormData()<br />
{<br />
textbox1.Lines = new string[37] ;<br />
textbox1.Lines = (string[])NumArray; <br />
}
Haz
|
|
|
|
|
You can't convert like that. Try this:
string[] stringArray = new string[37];
for(int i=0; i<37; i++)
{
short? num = NumArray[i];
if (num != null)
stringArray[i] = NumArray[i].ToString();
else
stringArray[i] = "";
}
textbox1.Lines = stringArray;
|
|
|
|
|
Thanks for your speedy response.
Your solution works really well in my program.
Haz
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
