|
I have an sql table which one of its column data type is bit
How can I update it from c# app ?
Thanks
|
|
|
|
|
example
update tablename set columnbitvalue = 1 where idcolumn = 21;
same as
update tablename set columnbitvalue = '1' where idcolumn = 21;
you can update column which contain bit or integer giving update command as string, but u base in ur id for selected row which u want to update
|
|
|
|
|
Hello,
When l change the value of the combo box, as soon as the combo box loses focus the value will change to the value it was before. The new value does not remain. Has this got something to do with the edit options of the datagrid. I am not sure.
The only way l have solved this problem is to save the new value to the database, and then fill the datagrid from database again with the new. This has to be done everytime the user changes the combo box value.
The way l would like this to work is for the user to change the values in the combo boxes, and have the value remain. When they have finished, they can save everything to the database.
I hope you can help me with this project again. I have the code below that inserts the combo box into the datagrid.
<br />
if ( !this.grdCustomerProducts.TableStyles.Contains("Product") )<br />
{<br />
DataGridTableStyle grdTblStyle = new DataGridTableStyle();<br />
grdTblStyle.MappingName = dt.TableName;<br />
grdCustomerProducts.TableStyles.Add(grdTblStyle);<br />
<br />
GridColumnStylesCollection colStyle;<br />
colStyle = grdCustomerProducts.TableStyles["Product"].GridColumnStyles;<br />
colStyle[0].Width = 150;<br />
<br />
DataGridTextBoxColumn dgtb = (DataGridTextBoxColumn)grdCustomerProducts.TableStyles["Product"].GridColumnStyles[2];<br />
dgtb.TextBox.Controls.Add(cmbQuantities);<br />
}<br />
Thanks for you help in advance,
Steve
|
|
|
|
|
Hi,
I need a DataGridViewColumn With Radiobuttons like CheckBoxColumn in my application.
Immediate help will be appreciated
Srinivas
|
|
|
|
|
hi
You can use a template column to put a radio button control in your datagrid
Regards,
Lucky
|
|
|
|
|
Hi,
Thank You,
But I am working with Win Forms on VS 2005.
there is no template column in DataGridView.
are there any solutions?
Thanks
Srinivas
|
|
|
|
|
Hi:
please help i have a windows application connected to a local MSSQL server and i want to make the application to be used over lan, what sholud i change only the connection string so that it will work over lan and for more than one user.
please help and thanks for your time and consederation
|
|
|
|
|
Firstly, are you using Windows Security (trusted connection) or SQL Server security (you have a separate username and password for SQL Server)?
Does everyone who's going to use your application access SQL Server the same way? Do all your users have access to SQL Server?
These are the things that you need to determine before going forwards. If everyone in your workplace has a trusted connection to SQL Server and access to the DB, then you don't need to provide username and password information in your connection string. Otherwise, you'll have to get a username and password from each user (to include in the connection string) before they can get access to the SQL Server DB.
I hope this helps.
|
|
|
|
|
Hi,
I often end up with a collection of items I have to process. Say - an arraylist of "commands". I want to process these command and then delete the command from the collection. As you cannot modify a collection during a foreach, I often process it in reverse and delete the last (just processed) item like this
lock (col)
{
for (int i = col.count-1 ; i <=0 ; i--)
{
processItem(col[i]);
col.RemoveAt(i);
}
}
Is there a better way to do this ?
/Jan
Do you know why it's important to make fast decisions? Because you give yourself more time to correct your mistakes, when you find out that you made the wrong one. Chris Meech on deciding whether to go to his daughters graduation or a Neil Young concertp
|
|
|
|
|
Maybe something like that:
while(col.count > 0)
{
processItem(col[0]);
col.RemoveAt(0);
}
But I am not sure it is a better way 
|
|
|
|
|
Jan R Hansen wrote: want to process these command and then delete the command from the collection.
Since processItem() doesn't know anything about the commands in the collection (other than the one it's processing), you might consider simply doing this:
lock (col) {
foreach (Command c in col)
processItem (c);
col.Clear();
}
If Command is a heavyweight object, you could try this approach:
lock (col) {
for (int i=0; (i < col.Count); i++) {
Command c = col[i] as Command;
processItem (c);
col[i] = null;
}
col.Clear();
}
/ravi
My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com
|
|
|
|
|
Thanks - I overlooked that I had to lock the collection anyway, so I could just as well use the topmost example. Thanks again ! 
Do you know why it's important to make fast decisions? Because you give yourself more time to correct your mistakes, when you find out that you made the wrong one. Chris Meech on deciding whether to go to his daughters graduation or a Neil Young concert
|
|
|
|
|
Hi all,
I had posted a message earlier on this topic but i did not
get a satisfactory reply,
Please if anyone of u could tell me how to login to
a blog and then post an article to it from a C# windows application.
Thanks & Regards,
Pramod
|
|
|
|
|
You'll have to be more specific than that. What is the blog software? - some provide webservice access which you can use, others don't.
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"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
|
|
|
|
|
i have created a blog on Wordpress.com
and i want to post some data on that blog
so what should be done?
Do these blog providing sites release any API's for this?
Thanks & Regards,
Pramod
|
|
|
|
|
Yadav Pramod wrote: Do these blog providing sites release any API's for this?
If the process of posting an entry is performed via a web form, you can harness the "post entry" functionality by creating a WebResourceProvider[^].
/ravi
My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com
|
|
|
|
|
i want to do that in C# windows Application
Pramod
|
|
|
|
|
Yadav Pramod wrote: i want to do that in C# windows Application
Yes, I know. Do you have a specific question? 
/ravi
My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com
|
|
|
|
|
Ya, My question is how to post the data
on an existing blog?
Pramod
|
|
|
|
|
Yadav Pramod wrote: how to post the data on an existing blog?
View the source of the html page that allows you to post your blog entry. It's likely to be a form of some sort. Then, write a web resource provider[^] to mimic that action. See the GoogleTranslator[^] article for an example.
/ravi
My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com
|
|
|
|
|
I'm having trouble saving a workbook. I show a SaveFileDialog, the user specified where he wants to save the file, and where. When the user clicks on Save button, I say SaveAs... and do something else with the file (after the file is saved). Anyway, that's what it should do.
My code for saving is this:
this.SaveAs(fileName, Excel.XlFileFormat.xlXMLSpreadsheet, missing, missing, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, missing, false, missing, missing, true);
It simply doesn't save the xls file. Does anybody have any idea why?
---------------------------------
Two things are infinite: the universe and human stupidity; and I'm not sure about the the universe. (Albert Einstein)
|
|
|
|
|
Hi,
I want to display Radiobuttons in one of the Columns of DataGridView. Is it possible? if possible please help me.
Thanks in Advance.
Srinivas
|
|
|
|
|
I have a bit of a problem trying to use a C++ class that contains virtual functions though C# p/invoke. Here is a trivial simplification of the problem to illustrate the issue.
With Visual Studio.Net 2003:
If I have a C++ class like so:
class ClassA
{
ClassA(){n = 0;}
int n;
void F(){n++;}
};
And an exported function that uses this class like so:
extern "C"
{
__declspec(dllexport) void ExportedFunc(ClassA** ppA)
{
ClassA* pA = *ppA;
pA->F();
}
}
I can call into this from C# by declaring a mapped structure for marshalling like so:
[StructLayout(LayoutKind.Sequential, CharSet=CharSet.Unicode)]
public class ClassA
{
int n;
}
And a function to wrap the exported C function:
class DLLImports
{
[DllImport("ExportFuncs.dll",
EntryPoint="ExportedFunc",
SetLastError=true,CharSet=CharSet.Unicode,
ExactSpelling=true,
CallingConvention=CallingConvention.StdCall)]
public static extern void ExportedFunc(ref ClassA refA);
}
I can then make a call into the dll containing the exported function like so:
{
.
.
ClassA refA = new classA();
DLLImports.ExportedFunc(ref refA);
.
.
}
Okay so this works a treat.
But if I now modify classA so this it contains a virtual function like so:
class ClassA
{
ClassA(){n = 0;}
virtual ~ClassA(){}
int n;
void F(){n++;}
};
We run into a problem. The C++ class ClassA now has an extra four bytes at the beginning to contain the vTable pointer. So this needs to be taken into account when creating the structure layout in C#. Now I have tried just putting a dummy four btyes in at the beginning and I have tried changing the class to LayoutKind.Explicit and
using the FieldOffset to offset the first item in the class by four bytes, but I still find that when the code gets into the C function the vtable pointer has been reset to null.
Is there a way to overcome the problem or is is simply a case of "don't use classes that contain a virtual function with p/invoke?
Regards
M
|
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
