|
|
I'd use a Windows Scheduled Task.
|
|
|
|
|
Hi..
How can import a flash vedio to a Windows Form??
|
|
|
|
|
|
In My Application I us Vb.net 2008 in C# and my database is Sql server 2005 express Edition
In My application I am usig gujarati font so how can i save that gujarati font in database
Plese help me on this matter if any other idea so please tell me also
please help..........
|
|
|
|
|
Hi,
you cannot store strings with a specific font in a sql server. A font is just a description how to display characters. What you want to achieve is that the sql server stores a specific encoding. So set the encoding of your sql database to the one used for your language (try to google this, I don't know which encoding supports your language). This should help.
Regards
Sebastian
|
|
|
|
|
Aajignesh, read the following carefully I think this will help you:
For example table name is Customer. Customer table have two coulmns (CustomerId & CustomerName). You want to store Gujarati Font in second column (CustomerName). Set the datatype of CustomerName column to nvarchar(50), Then make the query look like as below:
Insert into Customer (CustomerId, CustomerName) values ('1', N'Write Name in Gujarati Font')
Note: Don't Forget to install Gujarati Font on your operating system.
Incase of any confusion feel free to ask muhammadshahidfarooq@yahoo.com
|
|
|
|
|
Thanks sir That's Work
1) sir what is the mening of N in this if u know so please tell me
thanks again to help me on this problem
Sir One another problem please help me on it
1) how can i set by default font set gujarati i try but every time i select language than write in gujarati other wise by default i write in english so if u have any idea so plese tell me
thanks you..........
|
|
|
|
|
N in insert query represent Unicode.
Q:Why we use Unicode?
A: Unicode can represent over 65,000 characters, it accommodates many languages whose characters are not represented in ANSI encoding. ANSI character encoding represents characters in one byte, it is limited to 256 characters.
For default input language, follow these steps:
1. Click Start, click Run, type intl.cpl, and then click OK.
2. Click the Languages tab, and then click Details.
3. On the Settings tab, click Add.
4. Select the language that you want in the Input language list, and then click OK.
5. Select the language that you want in the Default input language list.
6. Click OK two times.
|
|
|
|
|
|
Hi,
I have a table like
Sno ReceiptNo CustomerId Amount Date commissionAmount AgentId
1 10 C96 5000 02/02/2009 500 A20
2 10 C96 5000 02/02/2009 300 A46
3 10 C96 5000 02/02/2009 200 A37
4 11 C50 3000 02/03/2009 300 A35
5 11 C96 2000 02/03/2009 200 A43
here one receiptid have multiple records with same customer.
this table contains multiple records with the same receiptno and customer id.but i want to add distinct amount of each receipt of perticular custimer. means here customer C96 total paid amount is 5000+2000 i.e 7000.
I want query for this.If any one give the answer it will be very useful for me . Thanks in advance.
Haritha.
Haritha
|
|
|
|
|
HI Haritha.........
SELECT SUM(amount) FROM customer WHERE ReciptNo IN (SELECT DISTINCT ReceiptNo,amount FROM customer WHERE CustomerId='C96')
![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif) najmalccl@gmail.com
|
|
|
|
|
Haritha, use the following query this will help you:
Select sum(Amount) as Amount_Sum from Customer group by CustomerId
|
|
|
|
|
Either of these will work if using sql server
with temp (ReceiptNo, CustomerID, Amount)
as
(
SELECT ReceiptNo, CustomerID, Amount
FROM customer
group by ReceiptNo, CustomerID, Amount
)
select CustomerID, sum(Amount) from temp group by CustomerID
GO
SELECT ReceiptNo, CustomerID, Amount
INTO [#temp]
FROM customer
GROUP BY ReceiptNo, CustomerID, Amount
select CustomerID, sum(Amount) from #temp group by CustomerID
GO
drop table #temp
GO
|
|
|
|
|
Why the H are you using temporary tables for that? 
|
|
|
|
|
|
select distinct receiptno from tablename...
i will displays all records without duplicates then u can fine total amount of all records ...or particular customer records...
|
|
|
|
|
Hi,
I want to change the font of a specific column in C#.Net 2003 while the rest ramains in the default font. For example I want column 11 has the font "Times ..." while others have the font "Arial". How should I do this? Thanks in advance.
|
|
|
|
|
VS2003 use old DataGrid control. Maybe switch to VS2005 or VS2008. There is better support for data grids.
|
|
|
|
|
Hi all
I am trying to convert .flv file to .3gp file but is it possible to convert it through C# coding ?
or is there any dll which will help me to do that?
thanks
Amitava
AmiAmitava
|
|
|
|
|
I'm sure it's possible, you just need to know the two formats and write code to go between them. Assuming they are even compatible, I have no idea what they are,
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
When I need to convert video formats, I execute an external process called ffmpeg. That's the best shortest way to do what you're trying to do.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
Hi all,
I've a string in rtf format and I want to get plain text from there. But the rtf string is in Unicode and additional space is there after each character. It cause to get the pain text from RichTextBox. How can I solve this matter?
Thanks a lot
I appreciate your help all the time...
CodingLover 
|
|
|
|
|
It sounds like you have a string encoded as UTF-16, and decode it using a different encoding. Each chatacter is two bytes, so for all regular characters every second byte is zero.
Use the Encoding.UTF16.GetString method to decode the data into a string.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
HI,
This is from Chandrakanth working on C#.net with Asp.net with SharepointMOSS 2007.
Actually we are updating data into DataBase by clicking button.
And some of scanned files are going to store in Application Directory.
That name of the application directory is TiffFiles.
Actually the process goes in this below format.
1) We are entering user credential for Login.
2)We are selecting one folder from DROPDOWN. That folder contain Scanned files.By clicking BUTTON RETRIVEDATA the data will be going to store in DataBase, and Files are going to store in TIFFFOLDER.That Folder in Application.
2) And by Clicking WORKFLOW BUTTON the files should move to Folder in Sharepoint Server.The Name of the Folder in Sharepoint Server is SCANNED FILES.
Now the Problem is FILES are not moving to Folder in Shrepoint Server.
Here i am giving code and all. Can any one tell me how to Solve the Problem.
private void readdata(string batch)
{
string strConnection = (string)ConfigurationSettings.AppSettings["ConnectionString"];
SqlConnection con10 = new SqlConnection(strConnection);
SqlCommand cmd10 = new SqlCommand();
cmd10 = new SqlCommand("select * from T_Invoice_Data where BatchName='" + batch + "'", con10);
con10.Open();
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
da = new SqlDataAdapter(cmd10);
da.Fill(ds, "T_Invoice_Data");
DataTable dt;
dt = ds.Tables[0];
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
DataRow dr = dt.Rows[i];
string x = dr[0].ToString();
string x1 = dr[1].ToString();
string x2 = "Invoice4.TIF";
string x2 = dr[2].ToString();
string x3 = dr[3].ToString();
string x4 = dr[4].ToString();
string x5 = dr[5].ToString();
string x6 = dr[6].ToString();
string x7 = dr[7].ToString();
string x8 = dr[8].ToString();
string x9 = dr[9].ToString();
string x10 = dr[10].ToString();
string x11 = dr[11].ToString();
SPSite msite = new SPSite("http://sys245:44486/ScanDocuments");
SPWeb mweb = msite.OpenWeb();
mweb.AllowUnsafeUpdates = true;
string path = @"c:\AuroBindoUsingGoogleOCR\Tiffiles\";
string path2 = path + x;
if (File.Exists(path2))
{
FileStream fStream = File.OpenRead("C:\\AuroBindoUsingGoogleOCR\\Tiffiles" + "\\" + x);
fStream.Read(fileContent, 0, (int)fStream.Length);
fStream.Close();
SPListCollection splist = mweb.Lists;
SPList splis = splist["ScanDocuments"];
string createddate;
createddate = Convert.ToString(DateTime.Today.Day + "_" + DateTime.Today.Month + "_" + DateTime.Today.Year);
splis.RootFolder.SubFolders.Add(x6);
SPFolderCollection folders = mweb.GetFolder("http://sys245:44486/ScanDocuments/" + x6).SubFolders;
folders.Add(createddate);
SPFolderCollection folders2 = mweb.GetFolder("http://sys245:44486/ScanDocuments/" + x6 + "/" + createddate).SubFolders;
folders2.Add(batch);
SPFileCollection f02 = mweb.GetFolder("http://sys245:44486/ScanDocuments/" + x6 + "/" + createddate + "/" + batch).Files;
f02.Add(x, fileContent, true);
SPSite msite1 = new SPSite("http://sys245:44486/");
SPWeb mweb1 = msite.OpenWeb();
mweb1.AllowUnsafeUpdates = true;
SPList list = mweb1.Lists["ScanDocuments"];
SPListItemCollection items = list.Items;
foreach (SPListItem item in items)
{
string l1 = item.Name.ToString();
if (l1 == x)
{
item["FileName"] = x;
item["InvoiceNo"] = x1;
item["InvoiceDate"] = x2;
item["PO NO"] = x3;
item["TotalAmount"] = x5;
item["Location"] = x6;
item["Batch"] = x7;
item["CStaff"] = x8;
item["AssignedTo"] = x9;
item["DelFlag"] = x10;
item["ReOCRFlag"] = x11;
item["PODate"] = x4;
item.Update();
}
}
}
}
}
Thanks and Regards
Chandrakanth
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
