|
|
I just tried it and couldn't duplicate the problem. It would appear as though you have a second control in the tablelayout, or there is something else drawing another gradient.
|
|
|
|
|
Hi..
i am using inbuilt crystal report of .net2005.
i want combobox instead of text when we ask for any parameter in discrete value window.
i am new wid this.Please help me!!
|
|
|
|
|
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using Microsoft.AnalysisServices;
using Microsoft.DataWarehouse.Interfaces;
using System.Data.OleDb;
using System.Data.Common;
namespace DatabaseApplication
{
public partial class Form1 : Form
{
string dbname;
string connectionstring;
string databasename;
string datasourceviewname;
string datasourcename;
string tableName;
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
string connstring = "Data Source=localhost;Integrated Security=True";
SqlConnection connection = new SqlConnection(connstring);
string query = "select * from sys.databases";
SqlDataAdapter data = new SqlDataAdapter(query, connection);
DataTable dtable = new DataTable();
try
{
connection.Open();
int records = data.Fill(dtable);
if (records > 0)
{
foreach (DataRow dr in dtable.Rows)
{
//Console.WriteLine(dr[0]);
comboBox1.Items.Add(dr[0]);
}
}
}
catch (SqlException sqlexcp)
{
MessageBox.Show("connection error");
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
dbname = comboBox1.Text;
}
private void button1_Click(object sender, EventArgs e)
{
/*databasename = dbname;
datasourceviewname = "oor";
connectionstring = "Data Source=localhost;Integrated Security=True";
//create a datasource name
RelationalDataSource newDS = new RelationalDataSource(datasourceviewname, Utils.GetSyntacticallyValidID(datasourceviewname, typeof(RelationalDataSource)));
Database db = new Database("oor");
db.DataSources.Add(newDS);
newDS.ConnectionString = connectionstring;
newDS.Update();*/
Server server = new Server();
databasename = "cwh_temp";
server.Connect("localhost"); // connection to the MS Analysis service engine
Database db = new Database(databasename, Utils.GetSyntacticallyValidID(databasename, typeof(Database)));
if (server.Databases.ContainsName(databasename))
server.Databases.RemoveAt(server.Databases.IndexOfName(databasename));
server.Databases.Add(db);
db.Update();
connectionstring = "Provider=SQLNCLI.1;Data Source=localhost;Integrated Security=SSPI;Initial Catalog=rmcwh_alevoor";
datasourcename = "ooru";
RelationalDataSource dsNew = new RelationalDataSource(datasourcename, Utils.GetSyntacticallyValidID(datasourcename, typeof(RelationalDataSource)));
db.DataSources.Add(dsNew);
dsNew.ConnectionString = connectionstring;
dsNew.Update();
datasourceviewname = "ooru";
DataSourceView dsv;
dsv = db.DataSourceViews.Add(datasourceviewname, Utils.GetSyntacticallyValidID(datasourceviewname, typeof(DataSourceView)));
dsv.DataSourceID = dsNew.ID;
OleDbConnection cn = new OleDbConnection(dsNew.ConnectionString);
tableName = "UdayPareekScale";
//dss.Tables[1].TableName = "Folder";
try
{
OleDbCommand cmd = new OleDbCommand("Select * from [" + tableName + "]", cn);
OleDbDataAdapter ad = new OleDbDataAdapter(cmd);
DataSet dss = new DataSet();
ad.FillSchema(dss, SchemaType.Source);
dss.Tables[0].TableName = tableName;
dsv.Schema.Tables.Add(dss.Tables[tableName].Clone());
}
catch (NullReferenceException nre)
{
MessageBox.Show(nre.ToString());
}
catch(Exception exp)
{
MessageBox.Show(exp.ToString());
}
//dsv.Schema.Tables.Add(dss.Tables["Folder"].Clone());
dsv.Update();
}
}
}
|
|
|
|
|
Where do you get an error? wich line?
|
|
|
|
|
|
and that line would be.....???? Notice, in your original post, you didn't supply any lines numbers!
|
|
|
|
|
i've highligthed and underlined the line that was giving me a nullreference exception.
|
|
|
|
|
then use your IDE's editor to investigate line 140 (you have turned on "display line numbers" I trust).
whatever object reference gets dereferenced (as in myObject.something) is a candidate for being null and generating said exception.
|
|
|
|
|
how to call functions like this
private void inputCheckedListBox_ItemCheck(object sender, ItemCheckEventArgs e )
from another functions
|
|
|
|
|
you can do it like a classic call
|
|
|
|
|
Usually any functionality i have in an event handler that will be used by anything other than any events it is assigned to i would put in a separate method, which can then be called directly. But that's a suggestion rather than an answer so...
You could try to call it like any other method, i.e.
inputCheckedListBox_ItemCheck(this, new ItemCheckEventArgs());
...but as i said i would never need to do this so i cant say for sure it would work.
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
Thanks for your suggestion and help. But i didnt work.
Well why i need this as i want to get selected item in arraylist from chekbox list. For that i want to CHECK whether item is selected or not.
if you could help me out in that...
|
|
|
|
|
Try this one
put this code in your function where u want to call the function
object mysender = new object();
ItemCheckEventArgs mye = new ItemCheckEventArgs();
inputCheckedListBox_ItemCheck(mysender,mye);
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
It didnt work..
error ItemCheckEventArgs():"it wont take zero value"
|
|
|
|
|
try this...
object mysender = new object();
ItemCheckEventArgs mye = new ItemCheckEventArgs(0, CheckState.Checked, CheckState.Checked);
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
Ya.. it works
thanks a lot.
|
|
|
|
|
It depends on what the inputCheckedListBox_ItemCheck actually does. Usually you can call such a method with null as both arguments.
|
|
|
|
|
Hi
I want to create views of sql server tables , i have loaded columns of a specific tables of specific databases in a check list box in form now i want to know how to fill those columns in a grid view in mdi parent and create view through those columns, means how to create views just like they are created in sql server?
plese some one help
Mariam
|
|
|
|
|
mariamkhaqan wrote: i have loaded columns of a specific tables of specific databases in a check list box in form
I have no idea how this relates to anything else you said...
mariamkhaqan wrote: how to fill those columns in a grid view in
Fill a DataTable with the appropriate data from your database, then just set the DataGridView's DataSource proeprty to the DataTable you created.
|
|
|
|
|
I had a small application of BHO made in c#.
when this BHO got injected on IE7, as the windowStateChange Event gets fired as we switch to different tabs (when many tabs are opened in a windows), but how can we Identify the tab that is active among all the tabs?
|
|
|
|
|
how to read data from lan serial port
i have ip abd port number
|
|
|
|
|
Do you people no know how to to basic research[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
how about going to msdn and get the sample there..!!!
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
